The database i'm using has another nls_date_format as hibernate anticipate.
The database has the default nls_date_format. I need
'YYYY-MM-DD HH24:MI:SS' which uses hibernate.

Is there a possibility to say the thin-driver, which nls_date_format to use?
[The THIN-driver don't reads environment and registry!]
Is there a possibilty to set the session without altering the
database default? [We use Oracle 8.0.5, which has no ON LOGON-
Trigger.]
Is there a possibilty to say hibernate to use a to_date function
in the generated sql?

Our environment:
hibernate 2.1.6
Oracle: 8.0.5 db, ojdbc14.jar
A part of the stack-trace:
DEBUG net.sf.hibernate.SQL - insert into WKORB (VIP, TIMESTAMP, TIMESTAMP0, USERAGENT, ANBIETER, WKORBID) values (?, ?, ?, ?, ?, ?)
. . .
DEBUG net.sf.hibernate.type.TimestampType - binding '2005-03-17 16:59:42' to parameter: 2
. . .
java.sql.BatchUpdateException: ORA-01024: Ungültiger Datentyp im OCI-Aufruf

Without the timestamps the statement works well.
I get the same problem, if i use this statement in plain SQLPLUS.


best regards
jens himmelreich