Sorry for the OTness here, but I find this mailing list has more
java knowledge in it than anywhere else I'm likely to look so .
I'm considering adding freeform text search to a web application
I'm working on. I've done the same thing before with other applications
using Lucene, but that approach was, to be blunt, frail because I had to
keep (and manage) two parallel data stores. There was Lucene's file based
storage listing all the text and object keys, and there was my database that
held the objects themselves. Keeping the two in synch through errors,
transaction failures, backups, and recoveries was like pulling teeth and
never *quite* worked right, resulting in the occasional "oh, just rebuild
the whole lucene index" approach to fault recovery.
What I'd really like is some form of vendor-neutral freeform
text search that uses an RDBMS (not the file system) as its repository. Does
anybody know of a java based solution that offers that kind of
functionality?
--- Pat
