Hello,

How can I define a FullTextQuery to retrieve all the records ?

Best regards,
Eric

I'm not excactly sure what you mean by "retrieve all records" since from what I understand a simple query.list() will return all the records that matched your fulltext query.

Being a newbie too, I guess you're having the same problem I had a couple of days ago: query multiple fields. I haven't yet found a way to query *all* possible fields, but MultiFieldQueryParser at least allows you to specify an array of fields you want to include.

Hope this helps.

Fr.

Hi,

if you want to retrieve all records for an indexed class (without any query restrictions) the FullTextQuery would look like this:


// the field _hibernate_class stores the class name
QueryParser luceneParser =
new QueryParser("_hibernate_class", new KeywordAnalyzer());

//clazz is the class for which you want to retrieve all records for
Query luceneQuery = luceneParser.parse(clazz.getName());

//limit results to the given class: clazz
FullTextQuery query = fullTextSession.createFullTextQuery(luceneQuery, clazz);

but a this point a simple HQL query will be more efficient

Jo, thats true. But HQL would retrieve real objects from the database. the index search lets you use projection (if applicable) and results in a much faster responce. I have 50,000 datasets and use descriptor objects to display them in a list. Hibernate Search with projection is a lot faster than the HQL query...

I beg to differ, there is no reason why a paginated SQL query would be slower that a paginated Lucene query if the query is nothing more that retrieving everything.