JDBC and MySQL 5.0
JDBC and MySQL 5.0
- Subject: JDBC and MySQL 5.0
- From: Michael DeMan <email@hidden>
- Date: Fri, 6 Jan 2006 11:38:11 -0800
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.
I'm hoping somebody has come across this before and knows the quick-
fix before I spend too many hours digging into it.
The exception I'm getting is:
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.
_______________________________________________
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