lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Sojan <>
Subject Re: Database integration best practices ...
Date Wed, 27 Mar 2002 08:58:34 GMT

I forgot one thing to ask:

search results should be anchored to a unique id which maps to a 
serial in the database. If my search now results in multiple such
id's what is the best way to transform this into a row-fetching 
SQL-statement? I think I would end up in something:

SELECT * FROM atable WHERE id = 12 AND id = 23 AND id = 34 AND ....

... and so on.

For this purpose it would be nice to limit lucene search results, so 
that the SQL statement can be limited. Any better idea!?


To unsubscribe, e-mail:   <>
For additional commands, e-mail: <>

View raw message