• 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
Re: Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1


  • Subject: Re: Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1
  • From: David Holt <email@hidden>
  • Date: Thu, 14 Jul 2011 10:40:52 -0700

A quick google around (mysql Data truncation: Data truncated for column) shows it might be a fairly common problem. Maybe your drivers are different between dev/deploy?

Maybe this provides a work-around?

http://bugs.mysql.com/bug.php?id=7829

[12 Jan 2005 15:28] Mark Matthews
If you don't want truncation checked for, add 'jdbcCompliantTruncation=false' to your JDBC
url, and the driver will act as Connector/J 3.0 did.

Always a good idea to check the CHANGES file that comes with the driver when upgrading:

"- The driver is more strict about truncation of numerics on
      ResultSet.get*(), and will throw a SQLException when truncation is
      detected. You can disable this by setting 'jdbcCompliantTruncation' to
      false (it is enabled by default, as this functionality is required
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: Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1
      • From: Lars Sonchocky-Helldorf <email@hidden>
References: 
 >Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1 (From: Lars Sonchocky-Helldorf <email@hidden>)

  • Prev by Date: Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1
  • Next by Date: Re: Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1
  • Previous by thread: Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1
  • Next by thread: Re: Strange behavior of com.webobjects.jdbcadaptor.MySQLPlugIn: Data truncated for column 'mailToInterviewer' at row 1
  • Index(es):
    • Date
    • Thread