Oracle Date support with Hibernate

vastav5star · **Posted:** Fri Dec 28, 2007 4:51 am

Hi ,
I am having code which runs well with Mysql and SQL Server ,i am Hibernate to map with DataBase .
And i am using same piece of code with Oracle With Hibernate to Map to DataBase . But i am facing problems with Oracle Date .

The Date field in the Hibernate Mappping file works fine with the MySql and SQL Server.
But for Oracle its causing a problem.
When i use to_date for the Oracle it just works fine.

Can anyone suggest a work around at Hibernate layer or at the Oracle Database , so that i can run same piece of code ,which is running on other two.

Thanks
Srivastava

[/quote][/code]

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

Quote:

... i am using same piece of code with Oracle With Hibernate to Map to DataBase . But i am facing problems with Oracle Date .
The Date field in the Hibernate Mappping file works fine with the MySql and SQL Server.
But for Oracle its causing a problem.

and how should we know what is the problem you've been facing with? Is there any exception? what is odd about Oracle's Date?

Is there any difference between the date you store in database and the date you retrieve? (a 1 day difference?)

If that's the case, the reason is Oracle does not have a only DATE type, it's DATE type is DATETIME type compared to other databases. And I believe there is a bug in Oracle's JDBC driver.

The solve the problem just disable "daylight saving" of the operating system which runs the Java application.

pasha · **Joined:** Sat Nov 27, 2004 4:13 am **Posts:** 137

Quote:

... i am using same piece of code with Oracle With Hibernate to Map to DataBase . But i am facing problems with Oracle Date .
The Date field in the Hibernate Mappping file works fine with the MySql and SQL Server.
But for Oracle its causing a problem.

and how should we know what is the problem you've been facing with? Is there any exception? what is odd about Oracle's Date?

Is there any difference between the date you store in database and the date you retrieve? (a 1 day difference?)

If that's the case, the reason is Oracle does not have a only DATE type, it's DATE type is DATETIME type compared to other databases. And I believe there is a bug in Oracle's JDBC driver.

The solve the problem just disable "daylight saving" of the operating system which runs the Java application.

vastav5star · **Posted:** Fri Dec 28, 2007 10:17 am

HI ,
thanks for your response .

I have problem retreving date from the database .

In the database the one of the columns is having the date field ,
now i am trying to retrieve the data , it throws throws the exception saying that ora 01861 :exception one of the literal is not correctly matched.

All the Date manipulations are casuing the same problem..

Thanks
Srivastava

vastav5star · **Posted:** Fri Dec 28, 2007 10:22 am

This is the error i am getting

ORA-01861: literal does not match format string

malm66 · **Joined:** Sat Nov 25, 2006 11:37 am **Posts:** 72

How do you retrieve, e.g. using a Hibernate criteria or a HQL query or a native query? And how do you specify the argument causing the problem? It could be as simple as the date format expected by Oracle is different to what you or Hibernate or the JDBC driver (see 1st question) put into the query.