How can I make a simple parameterized HQL query like:

from User where username = :username

case insensitive so it would match Users regardless of whether their usernames are upper-case, lower-case, or mixed-case?

Bruce

case sensitivity commands for hql can be found right here
http://www.hibernate.org/293.html

wait. That is a source code modification you'd have to compile into the hibernate jar. Not to mention it looks like a bad hack.

Hmm, I'd suggest either changing cases in the code, or using a sql query which will use the database's upper or lower commands.