Hibernate date don't save the milliseconds

Question

I'm saving an entity in hibernate with a creation date

 @Id @Column(name = "dtcreation") @Type(type="timestamp") private Date creation;

and I put a new Date on this field:

 entity.setCreation(new Date()); entityDao.persist(entity);

but when it is saved on the db the time don't contains the milliseconds, but put it a 0 if I try to update with a query the value of the milliseconds it works...someone can help me?

after the persist method i have a record with 01/06/2011 15:00:00.0 but if i made an UPDATE i can change the milliseconds, so the db supports it.. the database is informix

java.util.Date is quite old and horrible. If you can, investigate Joda Time instead. It integrates with Hibernate. joda-time.sourceforge.net/contrib/hibernate/userguide.html — artbristol
– artbristol, Commented Jun 1, 2011 at 12:26
i guess your main issue is the DB column you save into (not the date impl, i've never had issues w/ java.util.Date) — bestsss
– bestsss, Commented Jun 1, 2011 at 12:28
I doubt this is an hibernate issue. What's the underlying database? — Maurice Perry
– Maurice Perry, Commented Jun 1, 2011 at 12:29
Your last sentence is jumbled-up and confusing, I'd edit it but I don't want to mess it up if my interpretation is wrong. If you could clarify your description of what happens, that would be helpful. — Nathan Hughes
– Nathan Hughes, Commented Jun 1, 2011 at 12:35
Which DB are you using? Are you sure you use the right Dialect? — Dave
– Dave, Commented Jun 1, 2011 at 12:43

Stevi Deter · Accepted Answer · 2011-06-01 16:24:39Z

This is consistent with the documented behavior of java.util.Date and java.sql.Timestamp

java.util.Date stores down to the second, and java.sql.Timestamp is a thin wrapper to accommodate the nanosecond value of a SQL timestamp value. If you read the note on the Timestamp javadoc, it clearly states this difference.

If you don't want to lose your second fractions, and don't want to investigate alternative date libraries (e.g. the aforementioned Joda Time) you'll need to make the field a java.sql.Timestamp, and use the milisecond value of the current date to construct the initial value

java.util.Date date = new java.util.Date(); java.sql.Timestamp timestamp = new java.sql.Timestamp(date.getTime()); entity.setCreation(timestamp);

How do you have the entity? Hibernate not save de milliseconds :S

Chad Wilson · Accepted Answer · 2011-06-01 13:04:59Z

Without your code to test it's difficult for me to definitively answer, but in taking a look at the Javadoc for java.sql.Timestamp, it appears that you're mixing types with annotating the field as a timestamp. Change the java type from Date to Timestamp and see if that solves your problem.

Collectives™ on Stack Overflow

Hibernate date don't save the milliseconds

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related