I have to generate a query for two non related entities

query is 'select e0.a as a e1.b as b from entity0 as e0,entity1 as e1 where e0.id = e1.id '

I am using hibernate-search-3.1.0.GA:

I am not sure how to wrap the lucene query...

I tried

MultiFieldQueryParser mparser = new MultiFieldQueryParser(new String[] { "aTerm", "bTerm" },new StandardAnalyzer());

//aTerm,bTerm mapped to corresponding attributes in different classes


Query query = mparser.parse(query);
FullTextQuery fq = fs.createFullTextQuery(query, org.hibsearch.data.entity.Entity0.class,org.hibsearch.data.entity.Entity1.class);


When its exectued i get the results for each entities, as it generates two seperate SQLs than a single one (hib search works this way).

Any idea/hack to simulate the above query (joined version) in hibernate search ?

Hi,

It might help if you post your annotated entities. It is really hard to understand the problem from a single SQL statement.

Generally, HQL and Hibernate Search are not the same thing and serve different purposes. Hibernate Search offers fulltext search capabilities, something databases are normally quite bad in. It does not offer a replacement for SQL. In some use cases it might be required to mix both approaches. You might want to do a fulltext search to determine the entity ids of the entities matching the fulltext query. Then you would use the ids in some sort of HQL query to further limit your results.

Regarding your query. Using MultiFieldQueryParser basically combines the search terms with an 'OR'. This means all entities which either match 'aTerm' or 'bTerm' will be returned. I think you would have to build a much more complicated query using for example Lucene's BooleanQuery to get closer to what you are after.

--Hardy