Hibernate Community • View topic - hibernate +mysql + date fields

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

hibernate +mysql + date fields

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

rcrutz_18

Post subject: hibernate +mysql + date fields

Posted: Tue Feb 09, 2010 10:29 pm

Newbie

Joined: Mon Feb 08, 2010 10:40 am
Posts: 4

hi! i´m newbe in hibernate and I traying to work with 2 related tables, but there´s a problem and I can´t find what is wrong.
when i traying to map date, datetime or timestamp fields from mysql i have problems. I change that fields types and the mappings without any results. Is always the same error.
could not execute query.
Caused by: Cannot convert value '0000-00-00' from column 7 to TIMESTAMP.!!!
someone can help me?
what´s wrong?
tanks in advance!

Richard

Top

nordborg

Post subject: Re: hibernate +mysql + date fields

Posted: Wed Feb 10, 2010 3:56 am

Expert

Joined: Wed Mar 03, 2004 6:35 am
Posts: 1240
Location: Lund, Sweden

'0000-00-00' is not a valid date and it can of course not be converted to a timestamp. But you may tell the JDBC driver to convert such dates to null by setting zeroDateTimeBehavior=convertToNull in the connection url. For example:

Code:

jdbc:mysql://localhost/test?zeroDateTimeBehavior=convertToNull

More information can be found at http://dev.mysql.com/doc/refman/5.1/en/ ... rties.html

Top

rcrutz_18

Post subject: Re: hibernate +mysql + date fields

Posted: Wed Feb 10, 2010 10:49 am

Newbie

Joined: Mon Feb 08, 2010 10:40 am
Posts: 4

that's a good notice!
i will see the information atached
thanks!

Richard

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum