Hi, I could able to create create the index . However, when i am trying to search, i am hitting 0.
Environment : Windows DB : Oracle -> I have created a directory called : c://dbindex. I am seeing the indexes are created. My sql Query fetches just one row select id, CSC_SITE_ID, ADDRESS1,CITY, STATE from WIPS_ADDRESSES where csc_site_id = 41813612; Result : 41813612 BUIDING 2166 12TH LGGETTE FORT LEWIS WA -> I have created another directory called c://qa//a.query where I have an entry called FORT LEWIS Also, tried with 41813612 I am not hitting any result. Please let me know what is going wrong. Please explain more on this syntax : SearchFiles [-index dir] ** This is index directory [-field f] ** Are these fileds same as filed in the table [-repeat n] ** Please throw more lights on this [-queries file] ** Do I have to copy paste the sql query or the result i am expecting [-raw] ** What is this [-norms field]"; ** What is this I am attaching both the http://www.nabble.com/file/p17443570/SearchDatabase.java SearchDatabase.java http://www.nabble.com/file/p17443570/SearchDatabase.java SearchDatabase.java http://www.nabble.com/file/p17443570/IndexDatabase.java IndexDatabase.java -- View this message in context: http://www.nabble.com/Indexing-the-ORACLE-using-lucene-tp10429479p17443570.html Sent from the Lucene - Java Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]