Hi, i really need help here. I use the type date for column named LOGS, hoping that system's date and time will be inserted from myEntity.setLogs(new Date())
The date is inserted successfully by hibernate but the time is set to zero. I've used the latest version of oracle jdbc driver for 9.2.0.1 release, but it still goes like this.

The column type is oracle DATE, the entity uses java.util.Date.

Any help would really be appreciated !
Thanks !

Hibernate version:
2.1

Mapping documents:
<property
name="logs"
type="date"
column="LOGS"
/>

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:
oracle 9.2.0.1

The generated SQL (show_sql=true):
Hibernate: update PERINTAHBAYAR set VERSION=?, TGLPERINTAHBAYAR=?, KODESUPPLIER=?, NILAIPEMBAYARAN=?, FLAGSUDAHKONFIRMAKHIR=?, LOGS=? where NOPERINTAHBAYAR=? and JENISTRANSAKSI=? and VERSION=?

Debug level Hibernate log excerpt:


[/quote]

type="timestamp"


P.S. we would prefer if you spent a leeetle bit more time reading the docs before posting here, thanks.

I changed the SQL column type from DATE to TIMESTAMP.
It works ! Thanks !

But still the type="date" doesnt work. From what i read in hibernate in action, mapping type="date" corresponds with java type java.util.Date and SQL Type DATE, and that's what i really wanted.

Still curious if i miss something important while wading through the book and the reference.

Thanks alot !

No, it corresponds to a java.sql.Date.

And I think you are confused about the semantics of a ANSI SQL DATE type.

Sorry, i thought that ANSI SQL also stores time in DATE type. T_T

Thanks again.