Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.1.2


Name and version of the database you are using: MySQL 5.0

I do case sensitive search Hibernate 2 with no problem:
"from User u where binary u.name=?"

However, in Hibernate 3 I have to remove 'binary' otherwise I get error:
unexpected token .......

I am using getHibernateTemplate().find (string, params) to perform the search.

I guess it is because find() accept HQL not SQL anymore.

If it is true, how do I perform a case sensitive search ?

thanks !
lx

i have to switch back to H2 query parser by setting this hibernate.properties:

hibernate.query.factory_class org.hibernate.hql.classic.ClassicQueryTranslatorFactory