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 <eugenydzh@jdevelop.com> 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: java-user-unsubscribe@lucene.apache.org
>>For additional commands, e-mail: java-user-help@lucene.apache.org
>>
>>
>>
>>
>
>
>
--
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: java-user-unsubscribe@lucene.apache.org
For additional commands, e-mail: java-user-help@lucene.apache.org
|