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

Hibernate version: Hibernate2
DB: Oracle 10g

I am trying to save a timestamp field of the format ("mm/dd/yyyy hh:mm:ss a" ) in the Oracle DB.

Now using the HibernateUTC$CalendarType, I set the field correctly in the GMT format.

When I see the saved field in the table, the date and time field is correct ie it displays 1/1/2221 12:00:00.00 PM -05:00, but the timezone offset is wrong. It is always in the Oracle db timezone offset, which is the EST.

When I set the time/calendar, I am setting it correctly with the correct offset. But it is always saving as -5. Any help would be greatly appreciated.

Hi,

I assume that with HibernateUTC$CalendarType you refer to this code: http://www.hibernate.org/100.html. Is this the implementation you are using?

How is the TIMESTAMP field defined? Are you creating the schema yourself using Hibernate or do you work with an existing schema. If so, Oracle has the concept of TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE. Depending on your column definition you might get different results.

You might have to change the implementation of your custom UserType (HibernateUTC) to accommodate your db settings or vice versa.

--Hardy