Hi,

Hibernate version: 3.2

Name and version of the database you are using: oracle express 10g

Hi,

I'm trying to migrate my postgresql database to oracle express 10 on rhel 5. All seems ok. My application use tomcat and hibernate to access database. I have a problem between java timestamp and oracle timestamp.

When I set hibernate in verbose mode, I can see the sql string generated. Here is an exemple:

SQL> select * from etat_materiel where date_<='2008-06-19 11:17:55.433';
select * from etat_materiel where date_<='2008-06-19 11:17:55.433'
*
ERROR at line 1:
ORA-01843: not a valid month



Apparently it's not the good format for sql timestamp, but I can't find where in hibernate I can specify another way of creating this sql string.

Does anybody have been confronted to the same problem and how to solve it ?

Regards.

PS: I use
- tomcat 6
- hibernate 3.2
- oracle express 10 on rhel5