prepared statement - parameters with subqueries

[new to h2]

Hi,
I am a new user of H2 database and recently met the following problem.
Maybe someone have any idea what's wrong?

stm = con.prepareStatement("SELECT T.* FROM ( SELECT ROWNUM() AS
POS,U.* FROM USER U WHERE U.USER_NAME LIKE '%?%') T WHERE T.POS
BETWEEN ? AND ? ");
stm.setString(1,"ABC");
stm.setInt(2,1);
stm.setInt(3,5);
I got :
Invalid value "3" for parameter "parameterIndex" [90008-147]
Note : Java debuger shows ONLY 2 prep statement parameters!

where
stm = con.prepareStatement("SELECT T.* FROM (SELECT ROWNUM() AS
POS,U.* FROM USER U WHERE U.USER_NAME LIKE '%ABC%') T WHERE T.POS
BETWEEN ? AND ? ");
stm.setInt(1,1);
stm.setInt(2,5);
works fine.

Thank you

[Noel Grandin]

questions marks inside quotes are not treated as parameters.
You would need to do:

WHERE U.USER_NAME LIKE CONCAT('%', ?, '%')

[new to h2]

You are absolutely right. Thanks a lot :)