Don't make the mistake of complicating the task. Just read straight from mysql into lucene via java. There is no benefit of exporting data to xml just to regrab the data back into lucene.
Get the Lucene In actioin book if you haven't cause all the samples there are real-world practical. Are you need to add is 10 lines of mysql type java/jdbc code and you are ready to create your first index. Download luke for lucene, GUI testing tool so you can browse the index, perform searches, validate/test search performan bottlenecks, dissect queries, etc. On Wednesday, July 13, 2005, at 05:04AM, Klaus Hubert <[EMAIL PROTECTED]> wrote: >Hi Ian, > >That's something I'm looking for. Right, a simple >source code which reads a >database and adds the fields to the index. What I've >found also so far is >another solution at >http://www-128.ibm.com/developerworks/java/library/j-lucene/. >First step is >to export my MySQL database in simple XML and go from >there. It is just an >additional step and I would stick with this if I don't >find another method >to do all at once. > >Thanks, > > Klaus > >-----Original Message----- >From: Ian Lea [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 13, 2005 10:19 AM >To: java-user@lucene.apache.org >Subject: Re: SIMPLE Lucene / MySQL Indexer > >Something like this? > >IndexWriter iw = whatever >ResultSet rs = whatever > >while (rs.next()) { > Document ldoc = new Document(); > ldoc.add(Field.Text("f1", rs.getString("f1")); > ldoc.add(Field.Unstored("f2", rs.getString("f2")); > ldoc.add(Field.Keyword("f3", rs.getString("f3")); > ... > iw.addDocument(ldoc); >} > >rs.close(); >iw.close(); > > >On the IDE front, most people seem to use Eclipse >nowadays. > > >-- >Ian. > >On 13/07/05, Klaus Hubert <[EMAIL PROTECTED]> >wrote: >> Hi, >> >> I played with several search engines to replace >MySQL FULLTEXT index >> and hope that Lucene is the best solution for that. >> >> I am reading Mannings book on Lucene in action and >it seems to be the >> most powerful search engine I found so far. >> >> I'm stuck at some problem and need help from you >experts. I managed to >> create an index as described in the examples. I also >managed to read a >> MySQL database in Java. >> >> My question is, if anybody here has some SIMPLE >example which does >> this in one step. I am good in PHP and in Visual >Basic, but very new >> to Java. Maybe I'm using the wrong tools (NetBeans >IDE and JCreator) >> but I don't get it managed to create an Lucene Index >on 3 database >> fields. >> >> I appreciate any help. >> >> Thank you so much, >> >> Klaus > >--------------------------------------------------------------------- >To unsubscribe, e-mail: >[EMAIL PROTECTED] >For additional commands, e-mail: >[EMAIL PROTECTED] > > > >__________________________________________________ >Do You Yahoo!? >Tired of spam? Yahoo! Mail has the best spam protection around >http://mail.yahoo.com > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
