[jira] [Commented] (CAY-2691) MySQL driver 8.0.x stores LocalDateTime differently than 5.1.x

["Andrus Adamchik (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAY-2691?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17304015#comment-17304015 ] 

Andrus Adamchik commented on CAY-2691:
--------------------------------------

I suppose we should port this to 4.1 as well. 

> MySQL driver 8.0.x stores LocalDateTime differently than 5.1.x
> --------------------------------------------------------------
>
>                 Key: CAY-2691
>                 URL: https://issues.apache.org/jira/browse/CAY-2691
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Database integration
>         Environment: MySQL
>            Reporter: Nikita Timofeev
>            Assignee: Nikita Timofeev
>            Priority: Major
>             Fix For: 4.2.M3
>
>
> MySQL driver version 8.0.x uses java default timezone info to adjust {{LocalDateTime}} value stored in the DB. This process is symmetrical, so the result is OK for the Cayenne itself. But the exact value is different from the 5.1.x version, and, more importantly, this could cause problems with other systems that could read values directly from the DB.
> The solution is to use additional {{Calendar}} parameter in the {{statement.setTimestamp()}}, {{statement.setDate()}} and {{statement.setTime()}} methods.
> See also [this mail thread|https://lists.apache.org/thread.html/r30735c36ba034e280c6a20f2a6910f1cb6aa1f906b6234b8b1c9fe1c%40%3Cuser.cayenne.apache.org%3E]



--
This message was sent by Atlassian Jira
(v8.3.4#803005)