I have a question as how to escape wild characters while using criteria.

http://opensource.atlassian.com/project ... se/HHH-284 discusses similar question with HQL's.

For example, if want to search all names which have a "ABC" string my criteria query would be



and the above code is working perfectly.

But if I want to search with names which have a "%" character in it



the above code will not work as expected. I was escaping the % character in %%% with %\\%% but still I am getting every name. Is there any other way to escape these wild character search?

With following names availabale,
names ( user%one, ABC%one, ABC, user, XYZ%, %XYZ )
the results should be
results ( user%one, ABC%one, XYZ%, %XYZ )

Has anyone had to work with such a scenario, and if could you guide me in getting some information atleast that would be helpful.

Does anyone know how to make the following SQL

select *
from TableA where id like '%\%%' escape '\'

to work using Criteria API.

I made the following code to work



to generate following sql

select *
from TableA where id like '%\%%' escape '\'

where a_id is the database column in tableA and mapped with hibernate id as



however in this forum post (http://forums.oracle.com/forums/message.jspa?messageID=1274832) they discuss also this issue and my try with such a solution has not worked.

can anyone, if they have a chance to work with such problem, guide me?

Is there anything wrong in the approach I took by using Restrictions.sqlRestriction( ... ); as I am still not satisifed with the solution I have. There should be a cleaner approach.