java - Hibernate's setparameterlist not working for the selectquery

Question

i am trying to set the parameter lTList in the sqlquery with something like this => ['a',b','c'] but when i SOP after setting the parameter there is no change => "select .... lt in (:ltList) " what am i doing wrong

//List lTList=new ArrayList<String>();   
        
 Query selectQr = session.createSQLQuery("select id ipfs from ipfs where lt in(:lTList) and user_id='" + userId + "'");

selectQr.setParameterList("lTList", lTList);

There is no error but: query constructed : select .... lt in (:ltList)

query wanted : select .... lt in ('a','b','c')

question from:https://stackoverflow.com/questions/65841679/hibernates-setparameterlist-not-working-for-the-selectquery

Answer 1

"in(:lTList)" "in" and "()" need a blank space