lucene FTQ combined with hibernate Criterion [index + DB]

noootsab · **Joined:** Sun May 14, 2006 7:31 am **Posts:** 10

Hi All,

I'm wondering if there is a gentle way to create a Query where some clauses hit a lucene index and others hit the database persisted objects.

I leverage my question :

I wondering if something similar is possible

Code:

Criteria criteria;
{add some Criterion -> DB}
criteria.add(Expression.eq("field", "value");

org.apache.lucene.search.Query luceneQuery;
{create the lucene query string and parse it -> Lucene Index}

FullTextQuery ftp = fullTextSession.createFullTextQuery(luceneQuery);

ftq.setCriteriaQuery(criteria);

query.list();

Is someone inspired :-D ?

Ty

Best.

andy

sanne.grinovero · **Posted:** Sat Apr 19, 2008 11:04 am

Hi,
this is currently not possible, and probably will never be as I don't see how it could be implemented in an efficient way.

I have had a similar need, what whe did is put some more data in the lucene index to get the same effect: searching on some fields by fulltext and others by id.

We have a complex search form with many fields, when a user fills some we have a strategy selection: depending on the fields we choose the Criteria implementation or the Lucene implementation, returning a paged list of managed entities anyway.

regards,