• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
JDBC and MySQL 5.0
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Follow-Ups:
    • Re: JDBC and MySQL 5.0
      • From: Denis Stanton <email@hidden>
    • Re: JDBC and MySQL 5.0
      • From: Arturo Perez <email@hidden>
  • Prev by Date: Re: WOToOneRelationship and "dirty" editing context
  • Next by Date: Re: JDBC and MySQL 5.0
  • Previous by thread: Re: [OT] Is there a free MS SQL JDBC Adaptor?
  • Next by thread: Re: JDBC and MySQL 5.0
  • Index(es):
    • Date
    • Thread