Dear all
I'm trying to use
"SELECT * FROM X WHERE Y.A LIKE '%?%' ", and this is my hibernate query

Query query = hbSession.createQuery(from X as x where x.a like '%:name%');
query.setParameter("name", name);

once i try to execute this part I have got this from Hibernate:

14:07:52,328 ERROR [STDERR] java.lang.IllegalArgumentException: Parameter name does not exist as a named parameter in [from X as x where z.a like '%:name%']
14:07:52,437 ERROR [STDERR] at net.sf.hibernate.impl.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:324)
14:07:52,438 ERROR [STDERR] at net.sf.hibernate.impl.AbstractQueryImpl.setString(AbstractQueryImpl.java:343)
14:07:52,438 ERROR [STDERR] at com.netplus.hibernate.dao.impl.MemberDAOImpl.findByName(MemberDAOImpl.java:154)
14:07:52,439 ERROR [STDERR] at com.netplus.hibernate.ejb.MemberFacadeEJB.getMemberByName(MemberFacadeEJB.java:113)
14:07:52,494 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14:07:52,494 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

Query query = hbSession.createQuery(from X as x where x.a like ':name');
query.setParameter("name", "%" + name + "%" );