named parameter in like clause

maitscha · **Joined:** Sat May 20, 2006 3:49 am **Posts:** 78

hello,

I have a problem with the following query:

Query query = em.createQuery(" SELECT g.id, g.codeId, g.txtName from PatientGroup as g WHERE lower(g.codeId) like '?1%'");
query.setParameter(1, codeId.toLowerCase());

the parameter ?1 is not found within the like-clause. I get the error "org.hibernate.QueryParameterException: could not locate named parameter [1]"

I can only find examples of ejb-ql without parameters in like-queries...
any ideas?

emmanuel · **Posted:** Tue May 29, 2007 3:19 pm

try without the quotes

maitscha · **Joined:** Sat May 20, 2006 3:49 am **Posts:** 78

without the quotes I get the following error:

"java.lang.IllegalArgumentException: org.hibernate.QueryException: unexpected char: '%' [ SELECT g.id, g.codeId, g.txtName from org.dseas.base.model.PatientGroup as g WHERE lower(g.codeId) like ?1%]"

emmanuel · **Posted:** Wed May 30, 2007 12:38 pm

oh % should be included in your parameter value
like ?1

setParameter(1, "foo%")

maitscha · **Joined:** Sat May 20, 2006 3:49 am **Posts:** 78

emmanuel wrote:

oh % should be included in your parameter value
like ?1

setParameter(1, "foo%")

thx, that worked!