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:03:55 +0100
Useful Resource :
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html
> On 14 Oct 2018, at 15:02, Gino Pacitti <email@hidden> wrote:
>
> 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
_______________________________________________
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