I am using the below Hibernate code to filter workFlowName
.
crt.add(Restrictions.like("workFlowName", workFlow, MatchMode.ANYWHERE));
// crt is the criteria
The problem is when I pass the value to workFlow from web (TextBox).it fetching the value correctly (I am passing sym
in text box if fetch 10 records.if i pass the same value like %sym%
again it is fetching same record).
Whether the criteria will omit when it see %%
as argument?
Hibernate does not escape special chars in like (e.g. the percentage
%
sign). But there are descriptions how to solve it (escape it):In general we could implement our own
EscapedILikeExpression
(taken from the first link above)and
And now we should be able to call