lucene-dev mailing list archives

Dear  All

I need  help  to  update the index created for the database search

I created the index with  three field  mapping to the three column of database(oid(primarykey),title,
contents)
Then I created the document for each row and added to the writer      

    doc.add(Field.Keyword("OID",oid+""));
    doc.add(Field.Text("title",title));
    doc.add(Field.Text("contents",contents));
    writer.addDocument(doc);

Here search is only on  title and the contents and oid is the key to retrieve the details
from the database.

Later if the "contents" column in the database is  updated. We have to updated the content
in the index also

If I use the writer with false

IndexWriter writer = new IndexWriter("C\index", new StandardAnalyzer(),false);

then all the record are inserted in to index without deleting the old index causing duplication



If I use the writer with true

IndexWriter writer = new IndexWriter("C\index", new StandardAnalyzer(),false);

then record are inserted in to index deleting all the old index.

My question is 
1) How to update the existing index 
2) When I fetch the rows from the database in order to update or insert in index how to know
which record is modified in database and which record is not present is index

Thanks is advance
Raju