findByCriteria returning values by ignoring case

Question

i am using following code to check user.

DetachedCriteria queryCriteria = DetachedCriteria
queryCriteria.add(Restrictions.eq("UserName", userObj.getUserName().trim()));
userList = htObj.findByCriteria(queryCriteria);

where userobj is user object passes from backing bean

the problem is that it returns result without type restriction, e.g. though i enter 'admin' as username and there is 'ADMIN' in database it matches the record

This is not a Spring nor a JSF problem. – Luiggi Mendoza Feb 27 '13 at 15:25 — Luiggi Mendoza, Feb 27 '13 at 15:25

score 0 · Accepted Answer · edited May 23 '17 at 12:27

0

I think the problem lies more in the database than in the criteria query : check Case sensitive on restrictions 'equals id' in Hibernate restrictions and configure your database accordingly.

edited May 23 '17 at 12:27

Community

1
1

answered Feb 27 '13 at 15:08

benzonico

10,635
5
42
50

thanx .. . i got my answer from this link, the issue was the column charset and collate in sql database – mohit_pipariya Feb 28 '13 at 05:46

findByCriteria returning values by ignoring case

1 Answers1