Thank you Marc and thank u all... it` working :) :clap:
Marc Schwarz wrote: > > Maybe you should seperate the add method from the database function... > > Separate the db loop something like that: > > try > { > ResultSet rs2 = stm.executeQuery(sql); > while(rs2.next()) { > String text = rs2.getString("textvalue"); > addDoc(w, text,rs2.getString("id")); > count_ds++; > } > > > and then the addDoc seems something like that: > > > private static void addDoc(IndexWriter w, String value,String empty) > throws > IOException { > Document doc = new Document(); > doc.add(new Field("title", value, Field.Store.YES, > Field.Index.ANALYZED)); > w.addDocument(doc); > } > > > -----Ursprüngliche Nachricht----- > Von: luciusvorenus [mailto:lucius.vore...@hotmail.de] > Gesendet: Donnerstag, 28. Januar 2010 23:02 > An: java-user@lucene.apache.org > Betreff: Re: AW: index a database > > > yes.... many thanks .. > But .... /.../my index folder is empty. Have I done something wrong in > "private static void indexDocs"? It is not indexed > > > > > Marc Schwarz wrote: >> >> StandardAnalyzer analyzer = new StandardAnalyzer(Version.LUCENE_CURRENT); >> >> any difference with that ? >> >> -----Ursprüngliche Nachricht----- >> Von: luciusvorenus [mailto:lucius.vore...@hotmail.de] >> Gesendet: Donnerstag, 28. Januar 2010 22:46 >> An: java-user@lucene.apache.org >> Betreff: Re: index a database >> >> >> lucene 3.3 >> >> i tried liek this >> >> "" >> import org.apache.lucene.demo.FileDocument; >> import org.apache.lucene.document.Document; >> import org.apache.lucene.document.Field; >> import org.apache.lucene.analysis.Analyzer; >> import org.apache.lucene.analysis.standard.StandardAnalyzer; >> import org.apache.lucene.index.IndexWriter; >> import org.apache.lucene.search.IndexSearcher; >> import org.apache.lucene.search.Query; >> import org.apache.lucene.queryParser.QueryParser; >> import org.apache.lucene.store.FSDirectory; >> import org.apache.lucene.util.Version; >> import java.sql.*; >> import java.util.Properties; >> import org.apache.lucene.document.*; >> import java.io.*; >> import org.apache.lucene.store.Directory; >> import org.apache.lucene.store.FSDirectory; >> import org.apache.lucene.store.SimpleFSDirectory; >> >> public class Con{ >> public static void main(String[] args) throws Exception >> >> { >> final File INDEX_DIR = new File("index"); >> >> >> Class.forName("com.mysql.jdbc.Driver").newInstance(); >> Connection conn = >> DriverManager.getConnection("jdbc:mysql://127.0.0.1/test", "root", >> "passwort"); >> StandardAnalyzer analyzer = new StandardAnalyzer(null); >> Directory directory = new SimpleFSDirectory(new >> File("home/lucius/Desktop/index")); >> IndexWriter w = new IndexWriter(directory, analyzer,true, >> new >> IndexWriter.MaxFieldLength(25000)); >> >> System.out.println("Indexing to directory '" + INDEX_DIR >> + "'..."); >> indexDocs(w, conn); >> w.optimize(); >> w.close(); >> >> >> >> } >> >> >> private static void indexDocs(IndexWriter writer, Connection conn) > throws >> Exception { >> String sql = "select c_id, city from city"; >> Statement stmt = conn.createStatement(); >> ResultSet rs = stmt.executeQuery(sql); >> while (rs.next()) { >> Document d = new Document(); >> d.add(new Field("c_id", rs.getString("c_id"), Field.Store.YES, >> Field.Index.NO)); >> d.add(new Field("city", rs.getString("city"), Field.Store.NO, >> Field.Index.ANALYZED)); >> >> writer.addDocument(d); >> } >> >> } >> } >> >> >> >> """" >> I ' on the right track ? >> >> now i get this message after compiling >> "" >> Exception in thread "main" java.lang.NullPointerException >> at >> > org.apache.lucene.analysis.StopFilter.getEnablePositionIncrementsVersionDefa >> ult(StopFilter.java:162) >> at >> > org.apache.lucene.analysis.standard.StandardAnalyzer.<init>(StandardAnalyzer >> .java:73) >> at >> > org.apache.lucene.analysis.standard.StandardAnalyzer.<init>(StandardAnalyzer >> .java:63) >> at Con.main(Con.java:29) >> """ >> >> >> once again many thanks >> >> Erick Erickson wrote: >>> >>> What version are you using? Because there's no such constructor >>> (i.e. one that takes a File) in 3.0..... >>> >>> You might want to use something like FSDirectory.open(file) in >>> your IndexWriter constructor.... >>> >>> If this doesn't work, more details please.... >>> >>> Erick >>> >>> On Thu, Jan 28, 2010 at 3:30 PM, luciusvorenus >>> <lucius.vore...@hotmail.de>wrote: >>> >>>> >>>> Hello >>>> >>>> I tried to index a database >>>> >>>> "" >>>> import org.apache.lucene.demo.FileDocument; >>>> import org.apache.lucene.document.Document; >>>> import org.apache.lucene.document.Field; >>>> import org.apache.lucene.analysis.Analyzer; >>>> import org.apache.lucene.analysis.standard.StandardAnalyzer; >>>> import org.apache.lucene.index.IndexWriter; >>>> import org.apache.lucene.search.IndexSearcher; >>>> import org.apache.lucene.search.Query; >>>> import org.apache.lucene.queryParser.QueryParser; >>>> import org.apache.lucene.store.FSDirectory; >>>> import org.apache.lucene.util.Version; >>>> import java.sql.*; >>>> import java.util.Properties; >>>> import org.apache.lucene.document.*; >>>> import java.io.*; >>>> import org.apache.lucene.store.Directory; >>>> import org.apache.lucene.store.FSDirectory; >>>> >>>> public class Con{ >>>> public static void main(String[] args) throws Exception >>>> >>>> { >>>> final File INDEX_DIR = new File("index"); >>>> >>>> >>>> Class.forName("com.mysql.jdbc.Driver").newInstance(); >>>> Connection conn = >>>> DriverManager.getConnection("jdbc:mysql://127.0.0.1/test", "root", >>>> "passwort"); >>>> StandardAnalyzer analyzer = new >>>> StandardAnalyzer(null); >>>> IndexWriter writer = new IndexWriter(INDEX_DIR, >>>> analyzer, >>>> true); >>>> System.out.println("Indexing to directory '" + >>>> INDEX_DIR >>>> + "'..."); >>>> indexDocs(writer, conn); >>>> writer.optimize(); >>>> writer.close(); >>>> >>>> >>>> >>>> } >>>> >>>> >>>> private static void indexDocs(IndexWriter writer, Connection conn) >>>> throws >>>> Exception { >>>> String sql = "select c_id, city from city"; >>>> Statement stmt = conn.createStatement(); >>>> ResultSet rs = stmt.executeQuery(sql); >>>> while (rs.next()) { >>>> Document d = new Document(); >>>> d.add(new Field("c_id", rs.getString("c_id"), >>>> Field.Store.YES, >>>> Field.Index.NO)); >>>> d.add(new Field("city", rs.getString("city"), >>>> Field.Store.NO, >>>> Field.Index.ANALYZED)); >>>> >>>> writer.addDocument(d); >>>> } >>>> >>>> } >>>> } >>>> """ >>>> and i get this message >>>> >>>> "" >>>> symbol : constructor >>>> >>>> >> > IndexWriter(java.io.File,org.apache.lucene.analysis.standard.StandardAnalyze >> r,boolean) >>>> location: class org.apache.lucene.index.IndexWriter >>>> IndexWriter writer = new IndexWriter(INDEX_DIR, >>>> analyzer, >>>> true); >>>> ^ >>>> 1 error >>>> >>>> What i am doing wrong?? >>>> >>>> I'm a newbie ... >>>> >>>> Thank U >>>> -- >>>> View this message in context: >>>> http://old.nabble.com/index-a-database-tp27358959p27358959.html >>>> Sent from the Lucene - Java Users mailing list archive at Nabble.com. >>>> >>>> >>>> --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org >>>> For additional commands, e-mail: java-user-h...@lucene.apache.org >>>> >>>> >>> >>> >> >> -- >> View this message in context: >> http://old.nabble.com/index-a--mysql-database-tp27358959p27363073.html >> Sent from the Lucene - Java Users mailing list archive at Nabble.com. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org >> For additional commands, e-mail: java-user-h...@lucene.apache.org >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org >> For additional commands, e-mail: java-user-h...@lucene.apache.org >> >> >> > > -- > View this message in context: > http://old.nabble.com/index-a--mysql-database-tp27358959p27363752.html > Sent from the Lucene - Java Users mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org > For additional commands, e-mail: java-user-h...@lucene.apache.org > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org > For additional commands, e-mail: java-user-h...@lucene.apache.org > > > -- View this message in context: http://old.nabble.com/index-a--mysql-database-tp27358959p27374590.html Sent from the Lucene - Java Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org For additional commands, e-mail: java-user-h...@lucene.apache.org