Why SQLQuery setParameter cannot use LIKE?

Question

I have here:

Session session = getSession();
SQLQuery query = session.createSQLQuery("SELECT * FROM PERSON WHERE NAME LIKE '%?%'");
query.setParameter(0, personName);

I get the following error:

java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!

But when I try:

Session session = getSession();
SQLQuery query = session.createSQLQuery("SELECT * FROM PERSON WHERE NAME = ?");
query.setParameter(0, personName);

its working.

I need to use LIKE.

Answer 1

You can do like this:

Session session = getSession();
SQLQuery query = session.createSQLQuery("SELECT * FROM PERSON WHERE NAME LIKE ?");
query.setParameter(0, "%" + personName + "%");