Hi,could somebody put an example of how to use a wildcard % with named parameters,I know do it in a SQLQuery
String sql = "select * from tablename where fieldname1 like ? ;
SQLQuery query = session.createSQLQuery(sql);
query.addEntity(classname.class);
query.setString(0,"%"+fieldname1+"%");
that's work fine
but I want to do it with named paramaters,where we have to put the % wildcard?
String queryString = "from " + classname.class.getName() + " e where e.nombre like :nombre ";
List list = hibernateTemplate.findByNamedParam(queryString,"nombre", nombre);
return list;
}

If we put the widcards inside the String of the query eg where e.field like :nombre%";
throws an unexpected '%'
Also I tested put in hibernateTemplate.findByNamedParam(queryString,"%nombre%", nombre);
throws an cannot locate named parameter [%nombre%].

Can we use wildcards with hibernate named parameters??

This should be something like:

String hql = "from " + classname.class.getName() + " e where e.nombre like :nombre ";
Query query = session.createQuery(sql);
query.setString("nombre","%"+fieldname1+"%");

Hope this helps.

Thanks steckemetz,I knew how to do it with createSQLQuery and createQuery, I wrote the code in my msg very similary to your code but with an createSQLQuery method using an ?.
thanks to your answer I got the idea in a method findByNamedParam of spring hibernateTemplate:
String queryString = "from " + class.class.getName() + " e where e.nombre like :nombre ";
String orderByPart = "";
orderByPart += " order by e.iafiliado";
queryString += orderByPart;
List list = hibernateTemplate.findByNamedParam(queryString,"nombre", "%"+nombre+"%");
return list;
Your answer help me ,Thanks.