You can use something like hibernate to load the database tables into
java objects and then load them into Lucene Documents, fast and dirty
will take you a few hours to code, but if you're going the distance a
couple of days should do the trick.
Nader Henein
George Abraham wrote:
Eugene,
You could grab all the fields for a record in a SQL database, mash it all
together and transfer it into one indexing field in Lucene. Use some
scripting tools (or even JDBC and Java) to do this. However if you are
asking if Lucene can go and look over a SQL database and return results,
that would not work. Lucene has to index the database fields first. The
indexing would happen with the first two sentences of my post.
HTH,
George
On 9/29/05, Eugeny N Dzhurinsky <[EMAIL PROTECTED]> wrote:
Is there any way to use the contents of the SQL database as source for
Lucene
search engine? Is there any example applications or workarounds to do
that?
--
Eugene N Dzhurinsky
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
Nader S. Henein
Senior Applications Architect
Bayt Technologies
*****************************
Bayt.com
Dubai Internet City
Building 2, Office 314
P.O. Box 500245
Tel. +971 4 3911900
Dir. +971 4 3613675
Cell. +971 50 5659557
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]