Good day!

I'm using Oracle 10i database.
There are some rows in the table (Account) where Account_Name column data contains escape symbols. For example, 'SUB_'

Using HQL it is not a problem to search data with symbol '_', explicit ESCAPE definition will be used.


But when I use criteria based search, there is a problem.

The result query will look like the following:



There is no explicit ESCAPE symbol definition, consequently the query returns incorrect data (in my case - empty result set).

So, the questions are:
1) Can I search data with escape symbols using Hibernate Criteria?
2) How can I do this?

Thanks in advance!

The org.hibernate.criterion.LikeExpression class can do this. There's a constructor that looks like this which gives you the ability to specify an escape character:

protected LikeExpression(
String propertyName,
String value,
Character escapeChar,
boolean ignoreCase)

Unfortunately it's protected. I just copied the source to a new class in one of my own packages and made the constructors public.

I believe that if you use a parameterized query that setString will properly escape the characters. Let us know how that works out, I may need it in the future.

I used something like below with similar requirements