Hi,
I faced a problem with querying for local times in hibernate.
Suppose I have a table with a time( without date) field in it. I want to query it for a specific local date. I create a Calendar, set the TimeZone and time; and I expect hibernate to get the time in the specified timezone when setting the parameter for the query; but instead hibernate gets the time at the default time zone.
Is there an easy way to get my desired behavior from the hibernate?

You could achieve this with a custom UserType. Other than the UserType method, I do not know another way off the top of my head.

Example:
http://www.hibernate.org/265.html

You could even make it a parameterized user type. Basically, the nullSafeGet will have to apply the timezone information, while the set will have to apply the timezone for the DB.