Am 14.07.2011 um 19:40 schrieb David Holt:
> 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?
Thanks for that hint!
That was the case. I had an stray MYSQL driver and other stuff lying around in
/Library/Java/Extensions on the server. After cleaning up that mess everything
worked like a charm!
And I also thank you for your other mail as it provided a sane way to convert
our charset mess of a database to UTF-8.
cheers,
Lars
>
> 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
> for JDBC compliance)."
>
>
> On 2011-07-14, at 10:23 AM, Lars Sonchocky-Helldorf wrote:
>
>> Hi everybody!
>>
>>
>> When running one of our application on our staging server I get Database
>> Exceptions like this:
>>
>> Jul 14 16:57:23 PortalWonderTest[2100] DEBUG NSLog - === Begin Internal
>> Transaction
>> Jul 14 16:57:23 PortalWonderTest[2100] DEBUG NSLog - evaluateExpression:
>> <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE TERMIN SET
>> mailToInterviewer = ? WHERE TERMINID = ?" withBindings: 1:2011-07-14
>> 16:57:23(mailToInterviewer), 2:14478(terminid)>
>> Jul 14 16:57:23 PortalWonderTest[2100] INFO
>> er.transaction.adaptor.Exceptions - Database Exception occured:
>> com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression
>> failed: <com.webobjects.jdbcadaptor.MySQLPlugIn$MySQLExpression: "UPDATE
>> TERMIN SET mailToInterviewer = ? WHERE TERMINID = ?" withBindings:
>> 1:2011-07-14 16:57:23(mailToInterviewer), 2:14478(terminid)>:
>> Next exception:SQL Warning:22001 -- error code: 0 -- msg: Data truncation:
>> Data truncated for column 'mailToInterviewer' at row 1
>> Jul 14 16:57:23 PortalWonderTest[2100] DEBUG NSLog - === Rollback Internal
>> Transaction
>> Jul 14 16:57:23 PortalWonderTest[2100] ERROR
>> er.extensions.appserver.ERXApplication - Exception caught:
>> java.lang.reflect.InvocationTargetException
>>
>> full log here:
>>
>> <Data truncation.log>
>>
>>
>> The strange thing about this is that when I am trying to reproduce this
>> locally I don't run into an Exception, the same SQL is generated and
>> processed nicely. Also, if I run the SQL:
>>
>> UPDATE TERMIN SET mailToInterviewer = '2011-07-14 16:57:23' WHERE TERMINID =
>> '14478'
>>
>> in Sequel Pro I get the expected result without any problems.
>>
>>
>> The column is of type DATE.
>>
>>
>> Previously, the attribute was defined like the following in the EOModel:
>>
>> {
>> allowsNull = Y;
>> columnName = mailToInterviewer;
>> externalType = DATE;
>> name = mailToInterviewer;
>> prototypeName = creationDate;
>> },
>>
>> where creationDate was erroneously chosen as prototype:
>>
>> {
>> allowsNull = Y;
>> columnName = ERSTELLTAM;
>> externalType = DATETIME;
>> name = creationDate;
>> valueClassName = NSCalendarDate;
>> },
>>
>> So I thought that the definition of creationDate as DATETIME conflicted with
>> the column type DATE (and causes the truncation of "2011-07-14 16:57:23")
>>
>> So I changed this to:
>>
>> {
>> allowsNull = Y;
>> className = "com.webobjects.foundation.NSTimestamp";
>> columnName = mailToInterviewer;
>> externalType = DATE;
>> name = mailToInterviewer;
>> },
>>
>> but it still didn't work. Changing it to
>>
>> {
>> allowsNull = Y;
>> className = NSCalendarDate;
>> columnName = mailToInterviewer;
>> externalType = DATE;
>> name = mailToInterviewer;
>> },
>>
>> like all the other date attributes in the model doesn't work either. As I
>> said only on the staging and live machine. Everything of the above DID WORK
>> on my development machine.
>>
>>
>>
>> Has somebody any clues?
>>
>>
>> cheers,
>>
>> Lars
>>
>> _______________________________________________
>> Do not post admin requests to the list. They will be ignored.
>> Webobjects-dev mailing list ([email protected])
>> Help/Unsubscribe/Update your Subscription:
>> http://lists.apple.com/mailman/options/webobjects-dev/programmingosx%40mac.com
>>
>> This email sent to [email protected]
>
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
