Lists

Open Menu Close Menu

Terms and Conditions
Lists hosted on this site
Email the Postmaster
Tips for posting to public mailing lists

Re: JDBC and MySQL 5.0

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: JDBC and MySQL 5.0

Subject: Re: JDBC and MySQL 5.0
From: Arturo Perez <email@hidden>
Date: Fri, 06 Jan 2006 14:41:51 -0500

Michael DeMan wrote:

objectsWithFetchSpecification, includeDeleted: false [2006-01-06 11:07:42 PST] <Thread-2> <com.gemini.radius.wo.WorkingPage> long response thread raised : com.webobjects.jdbcadaptor.JDBCAdaptorException: Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP. [2006-01-06 11:07:42 PST] <Thread-2> STACK TRACE: [2006-01-06 11:07:42 PST] <Thread-2> com.webobjects.jdbcadaptor.JDBCAdaptorException: Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP.

MySQL 5 is much stricter with data type checking. As you can see from the above, your application is trying to store 0000-00-00 00:00:00 as a timestamp. But that value is not a valid timestamp according to relevant standards.

Have you tried validating your timestamp values to make sure they are correct before sending them onto MySQL?

HTH
-arturo

_______________________________________________
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



References:  
  >JDBC and MySQL 5.0 (From: Michael DeMan <email@hidden>)




Prev by Date:
JDBC and MySQL 5.0

Next by Date:
Re: JDBC and MySQL 5.0

Previous by thread:
JDBC and MySQL 5.0

Next by thread:
Re: JDBC and MySQL 5.0

Index(es):

Date
Thread