Re: SQL Exeption Error upgrading to mysql 5.6.41 - SOLVED
Re: SQL Exeption Error upgrading to mysql 5.6.41 - SOLVED
- Subject: Re: SQL Exeption Error upgrading to mysql 5.6.41 - SOLVED
- From: Gino Pacitti <email@hidden>
- Date: Sun, 14 Oct 2018 15:02:05 +0100
use sendFractionalSeconds=false in the connection string :)
> On 14 Oct 2018, at 12:46, Gino Pacitti <email@hidden> wrote:
>
> Im looking and looking but the error seems to be here:
>
> Invocations of setNanos() are illegal.
> java.lang.IllegalStateException: com.webobjects.foundation.NSTimestamp is an
> immutable object. Invocations of setNanos() are illegal.
> at com.webobjects.foundation.NSTimestamp.setNanos(NSTimestamp.java:1299)
> at
> com.mysql.jdbc.TimeUtil.adjustTimestampNanosPrecision(TimeUtil.java:519)
> at
> com.mysql.jdbc.PreparedStatement.setTimestampInternal(PreparedStatement.java:4282)
> at
> com.mysql.jdbc.PreparedStatement.setTimestamp(PreparedStatement.java:4245)
> at
> com.mysql.jdbc.PreparedStatement.setObject(PreparedStatement.java:3591)
>
>> On 14 Oct 2018, at 12:45, Daniel Bietenbeck <email@hidden>
>> wrote:
>>
>> We got the same problem. Any solution yet?
>>
>> Best regards,
>> Daniel Bietenbeck
>>
>>
>>> Am 14.10.2018 um 13:06 schrieb Gino Pacitti <email@hidden>:
>>>
>>> I just updated my mysql server on linux and columns which are DATETIME and
>>> when I am using NSTimestamp for Qualifiers for a query (plus any inserts
>>> with a NSTimestamp) are causing errors:
>>>
>>> com.webobjects.foundation.NSTimestamp is an immutable object. Invocations
>>> of setNanos() are illegal.
>>>
>>> I have the latest mysql-connector 5.1.47 and it was all working fine but
>>> after the upgrade to server all date inserts or queries are failing?
>>>
>>> Anyone have similar or can point me in the right direction…
>>>
>>> Gino
>>> _______________________________________________
>>> 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
>>
>>
>> _______________________________________________
>> 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
>
> _______________________________________________
> 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
_______________________________________________
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