Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Oracle time zone

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

allordev

Post subject: Oracle time zone

Posted: Thu Apr 26, 2007 9:31 am

Newbie

Joined: Thu Apr 26, 2007 8:58 am
Posts: 1

I'm using hibernate 3.2. I map a column like that:

Code:

<property name="myDate" update="true" insert="true"
         type="java.util.Calendar" not-null="false" />

Then I save object with myDate "Tue May 01 00:00:00 GMT 2007".
When I retrieve the data from HSQLDB myDate.getTime() returns : "Tue May 01 02:00:00 CEST 2007" (correct at my time zone).
From Oracle I get: "Tue May 01 00:00:00 CEST 2007" (incorrect - wrong time zone).In DB in Oracle myDate is TIMESTAMP WITH TIME ZONE. It is stored correctly.

How do I retrieve Calendar from Oracle correctly?

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum