here is my query:
query ="SELECT a FROM X a WHERE " +"a.level = :l and a.site =
and a.code like ':code%'")
my problem is tht im getting an exception saying [testng] javax.ejb.EJBException: java.lang.IllegalArgumentException: org.hibernate.QueryParameterException: could not locate named parameter [code]
i basically want to search all values of code that contain the value of the parameter code thts y i have the % after it. for instance, if cud is 123 then
123ASS should be returned as well. please help!