I am using Hibernate 3.

I have a column which is a java.util.Date and I have specified its type as Timestamp in the mapping file.

<property name="Timestamp" type="timestamp" not-null="true"/>

There are 2 things I do not understand:

1. Generated database column

When I generate the database table, it creates a mysql column of type datetime not timestamp. The hibernal sql dialect I am using is:
org.hibernate.dialect.MySQLDialect.

2. Milliseconds have disappeared

When I save a timestamp to the database, the milliseconds are being lost:

For example a timestamp before it is written to the database looks like this: 21-09-2005 18:55:42:343. WHen I get it back it looks like this: 21-09-2005 18:55:42:00.

What is causing this?

James

Hi James,
I am using Hibernate 2 but I believe this doesn't have to do anything with the problem.
I think the datetime type in MySql doesn't hold the millis value. The mapping you mention is correct and it works fine, but I hadn't payed attention to this detail before.

Hi Pablo

Thanks for the reply.

yes it looks as though Mysql does not have datetime type that can store milliseconds.

There is a question about this problem on the mysql lists:

http://lists.mysql.org/java/8216

James

Good to know.

Don't forget to rate!

Bye