Re: JDBC and MySQL 5.0
Re: JDBC and MySQL 5.0
- Subject: Re: JDBC and MySQL 5.0
- From: Denis Stanton <email@hidden>
- Date: Sat, 7 Jan 2006 12:59:32 +1300
On 7/01/2006, at 8:38 AM, Michael DeMan wrote:
Hi,
I was wondering if anybody is using MySQL 5.0. I'm having a
problem converting application from 4.1 to 5.0. I've tried both
the org.gjt.mm.mysql.Driver and com.mysql.jdbc.Driver drivers to no
avail.
Everything works in MySQL 4.x, but breaks in 5.0.5 in regards to
TIMESTAMP columns. Other PHP based applications we have converted
just fine.
MySQL tightened up their standards regarding timestamps a little
while ago. I thought it was between 3 and 4, rather than 4 and 5,
but it seems to fit your question otherwise.
Previously '0000-00-00 00:00:00' was accepted as being similar to
null for a timestamp. Now it is considered to be just plain invalid.
There is a work-around for those of us with older code. Try adding
'&zeroDateTimeBehavior=convertToNull' to your URL for the database.
If that parameter is not right for you you could look up
'zeroDateTimeBehavior' in the MySQL documentation
Denis
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden