You will have to provide us more details about what you are trying to do Have you mapped your entities to the database tables? Are you trying to get all data from a single table using HQL? And any specific reason why you included "case sensitiveness" in your question?
I've a simple criteria to search the database based on the name entered in the text field. I'm searching in only one table. Below code works fine when I remove the ignore case criteria. when I add this example to the Criteria, it takes all the numeric fields in the tyable in the where clause of the criteria instead of name only. Please suggest
Example example = Example.create(person); example.ignoreCase();
It works fine for me. What I see in the query is it converts the input value into lowercase in the where clause. can you please help me understand how does I still get the correct results from the database?
Originally posted by Bharath Gowda: can you please help me understand how does I still get the correct results from the database?
Without seeing the actual SQL query getting fired, i don't know how it might be accomplishing this But just a guess - Case insensitivity is handled at DB server level and each server will have its own way of specifying this. So i guess the JDBC driver or may be the dialect that you are using with hibernate (the dialect is configured through the hibernate configuration file) is handling this.