JPQL Like Statement

[ghermezkon]

hi
how to send parameter to like statement?

i'm use this syntax but it's error:
List test = em.createQuery("select t from test t where t.uid like ':uid%'").setParameter("uid" , "1").getResultList();

error:
Syntax error: :uid parameter not found

thanks

[mrohad]

Try:
List test = em.createQuery("select t from test t where t.uid like :uid ").setParameter("uid" , "1%").getResultList();

[ghermezkon]

ok
thanks it's word fine for String variable.
anybody help me with Integer variable??

[mrohad]

what do u mean integer var , like geting a String as param..

[ghermezkon]

no
for Integer field or variable not use character %