É possível usar o apache lucene para pesquisas em bancos de dados? Tipo, eu informaria um termo e ele tentava localizar nas tabelas do banco? Detalhe: nunca utilizei o Lucene!
Alguém?
http://wiki.apache.org/lucene-java/LuceneFAQ
How can I use Lucene to index a database?
Connect to the database using JDBC and use an SQL “SELECT” statement to query the database. Then create one Lucene Document object per row and add it to the index. You will probably want to store the ID column so you can later access the matching items. For other (text) columns it might make more sense to only index (not store) them, as the original data is still available in your database.
For a more high level approach you might want to have a look at LuSql (a specialized tool for moving data from JDBC-accessible databases into Lucene), Hibernate Search, Compass, DBSight, or Solr’s Data Import Handler which all use Lucene internally.
Thanks!!! I will test!!!