[FIXED] Unable to pass positional parameters into HQL query

Issue

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.

Solution

have you tried this :

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

Answered By - Elarbi Mohamed Aymen
Answer Checked By - Mary Flores (JavaFixing Volunteer)