Como usoLIKE % en hibernate. Quiero usar un SQL conLIKE % en mihbm.xml expediente. Tengo 2 consultas que estoy consolidando a 1.

La consulta se ve así:

select * from PAY_GROUP_VW where CASE_SID=? AND CASE_TLE like %?%

Yo tambien lo intenté%?%. He usado como cláusula sin% y funciona. Pero% No funciona.

Excepción envuelta:

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
    at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343)

Así es como paso los parámetros:

q.setParameter(0, csId);
q.setParameter(1, csTle);
return q.list();

Tratado como% ||? y obtuve la siguiente excepción:

org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
    at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
    at org.springframework.orm.hibernate3.HibernateTemplate.executeFind(HibernateTemplate.java:343)