Unable to pass positional parameters into HQL query

Question

Whilst trying to create an API for my app I tried to make a query that takes a value passed in and then returns the response from the db.

@Query(value = "SELECT u FROM User u WHERE u.userID = ?")
User getUserById(String id);

I have created queries this way in other projects but cannot figure out why I get the following error on this project

JDBC style parameters (?) are not supported for JPA queries.

Answer 1

have you tried this :

@Query(value = "SELECT u FROM User u WHERE u.userID  = :id")
User getUserById(String id);

Answer 2

Encounter the same problem in HQL, in XML approach with positional Parameter

Exception: Legacy-style query parameters (?) are no longer supported

HQL Query

String hql = "from Customer cust where cust.city=?";

Solution: Change the hql query as below

String hql = "from Customer cust where cust.city=?0";

And here we go!!