lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nader Henein <...@bayt.net>
Subject Re: Lucene vs SQL database
Date Thu, 29 Sep 2005 12:46:04 GMT
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


Mime
View raw message