Saving system date

[deepa karra]

Hi,
I want to save a record along with current date and time using hibernateDAO.
I am using oracle database. What is the datatype I need to use and also do i need to convert the java date into the oracle date format?

[Charan kumar sarvepalli]

Configure in hbm file <property> type as java.sql.Timestamp and in POJO declare as java.util.Date hibernate will do the remaining.

[deepa karra]

Thanks Charan,
I tried using the <property> as java.sql.timestamp. It is saving the current date. But the time is always being saved as 12:00:00 AM 000

The date is saved as 08/04/10 12:00:00 AM 000.

[Aneesh Vijendran]

The date is saved as 08/04/10 12:00:00 AM 000.

Make sure the object passed to hibernate is also an instance of java.sql.Timestamp

Cheers
Aneesh

[deepa karra]

Aneesh,
Thank you. The time is still the same as 12:00:00AM

[Aneesh Vijendran]

Well interesting!

1. How are you constructing the date object (before passing to Hibernate) ?
2. Can you please print the date before passing to hibernate and see if the time is 12:00 am there as well?

If (2) is true, then you know the answer.

[deepa karra]

Hi Annesh,
Thankyou. I solved the problem.
I was parsing the date to MM/dd/yyyy HH:mm:ss using simpledateformat.
Now I changed it as
SimpleDateFormat sdf = new SimpleDateFormat();

[Aneesh Vijendran]

Glad to know that. Happy Hacking!!