Hi,

I'm very new to hibernate, and I'm making a small change to an existing site. THe current search page doesn't use wildcards for the various string fields. So I want to add this in.

Short Story:
The query and param values are sent to hibernate like so:
getHibernateTemplate().find(query, valuesList.toArray());

Is this not valid for HQL?: like '%?%'


Long Story:
The params are stored in a hashmap, and they are looped over to build up the query - something like:

while(keys.hasNext()) {
.....
String key = (String) keys.next();
Object value = params.get(key);
valuesList.add(value);

if(value instanceof String) {
query += "p." + key + " like ?";
} else {
query += "p." + key + "=?";
}
}

The values are stored in the valuesList map and sent to the following hibernate function:
return getHibernateTemplate().find(query, valuesList.toArray());


I want to add the wildcard before and after the "?" in the first 'if' body ('%?%'). I got it to work by adding the wildcard to the parameter value (when the hashmap is built up), but I'd rather do it here so the change is only done in one section as opposed to doing it everywhere a String variable is added to a hashmap.

Thanks

Hibernate version: 3

Full stack trace of any exception that occurs:
javax.servlet.ServletException: stpns.services.DaoServiceException: java.lang.IllegalArgumentException: No positional parameters in query: from stpns.dom.Publisher as p where p.name like '%?%'
org.springframework.web.servlet.FrameworkServlet.serviceWrapper(FrameworkServlet.java:402)
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:355)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

Name and version of the database you are using: MySQL 4.1

The generated SQL (show_sql=true): ?

Debug level Hibernate log excerpt: ?

Solution: As the other thread suggested, I changed it to this and it worked:
query += "p." + key + " like '%' || ? || '%'";


Sorry! I should've searched on the ERROR MSG, and I might have found this. (Although searching by phrases would be really useful in this forum -- too bad for PHPBB)

I do this: