Hi,

We need two machines with different time zone settings to read and write date-time values to a common database. It seems to make sense to store all dates in GMT (UTC) and convert to the local time zone via a UserType. I've read the forum postings and Wiki page on this topic at:

http://www.hibernate.org/100.html

What's still not clear, though, is how the use of a UserType affects parameterized queries that involve java.util.Dates as parameters. Will they work correctly, assuming we set the parameter type to that of the UserType? Is anyone using this approach successfully?

Thanks.

Well, I'm going to give the user type approach a try.

Related question: I want to write an automated test that verifies that all Date and Calendar properties are mapped to one of the UTC-aware user types. I know I can use SessionFactory.getAllClassMetadata to get all of the entity classes and loop through their properties, but how can I find all of the classes that are mapped as components, composite-elements, etc. and loop through their properties?

Is there a better way to do this? I thought about replacing Hibernate's built in date/time types with the modified versions, but that seems very invasive, and I'm guessing it will break when date/times are used as query parameters. Or will it?