Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp
I have the following code snippet where in some cases the call to ftQuery.getResultSize() returns > 0 but the ftQuery.list() actually returns an empty list. I have several test cases and only in some cases does this situation arise. This seems similar to the issue in post (
http://forum.hibernate.org/viewtopic.php?t=980700).
Code:
// wrap Lucene query in a org.hibernate.Query
FullTextQuery ftQuery = fullTextSession.createFullTextQuery(query, returnTypes);
// Log the query we are using
logQuery(ftQuery);
// execute search
retObj = ftQuery.list();
logger.debug("### results size: " + ftQuery.getResultSize() + ", results: " + retObj);
when I output the actual query hibernate is running and run it in TOAD the query works fine given the values from the ID field. I ran the lucene query in Luke and the number of results matches the ones from the sysout above.
I should mention that on my entity the ID is a composite class.
Here is the FieldBridge I wrote for the composite key.
Code:
public class SearchTermsViewIdFieldBridge implements TwoWayStringBridge {
@Override
public String objectToString(Object arg0) {
String retString = null;
if (arg0 instanceof SearchTermsViewId) {
SearchTermsViewId id = (SearchTermsViewId)arg0;
StringBuilder sb = new StringBuilder();
retString = sb.append(id.getSearchRef()).append("_")
.append(id.getSearchRefId()).append("_")
.append(id.getXSearchTermId())
.toString();
}
return retString;
}
@Override
public Object stringToObject(String arg0) {
String[] fields = arg0.split("_");
SearchTermsViewId id = new SearchTermsViewId();
id.setSearchRef(fields[0]);
id.setSearchRefId(fields[1]);
id.setXSearchTermId(fields[2]);
return id;
}
For example, the following 2 lucene queries get hits, but the ftQuery.list() returns an empty list:
Quote:
example 1: searchTerm.searchTermString:steak*
example 2: searchTerm.searchTermString:italian*
however, the following lucene query gets hits and ftQuery.list() returns correct number of ojbects:
Quote:
+searchTerm.searchTermString:steak* +searchTerm.searchTermString:angus*
I'm using Hibernate version: 3.3.0 and Hibernate Search: 3.1.0.GA and Spring 2.5
Any suggestions?
Login
FAQ
Search