[jira] [Commented] (OPENJPA-2753) Create profiles to start various databases via Docker

["ASF subversion and git services (JIRA)" <ji...@apache.org>]

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

ASF subversion and git services commented on OPENJPA-2753:
----------------------------------------------------------

Commit f7a4445e681cc7c30ed855283660aae38792215b in openjpa's branch refs/heads/master from [~struberg]
[ https://gitbox.apache.org/repos/asf?p=openjpa.git;h=f7a4445 ]

OPENJPA-2753 downgade to 5.1.x MySQL jdbc driver

mysql-jdbc-8.0.13 has a nasty bug in handling DATE columns.
from 1978-04-26-00:00:00+1 the JDBC driver adopts to the server TZ (GMT)
-> 1978-04-25-23:00:00GMT
then cuts off the hour
-> 1978-04-25 and stores this in the DB

When reading back we get:
1978-04-25 expanded to 1978-04-25-00:00:00GMT
-> adopted to locale timezone: 1978-04-25-01:00:00CET
which is then on the wrong day :(


> Create profiles to start various databases via Docker
> -----------------------------------------------------
>
>                 Key: OPENJPA-2753
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2753
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: build / infrastructure
>    Affects Versions: 3.0.0
>            Reporter: Mark Struberg
>            Assignee: Mark Struberg
>            Priority: Major
>             Fix For: 3.0.1
>
>
> We currently rely on fix installed versions of various databases.
> With the advent of Docker we could use maven profiles to start those databases as docker images.
> E.g. 
> {noformat}
> $> mvn -N -Ptest-mysql-docker docker:start
> $> mvn -Ptest-mysql-docker clean install
> $> mvn -N -Ptest-mysql-docker docker:stop
> {noformat}
> The `-N` is needed to start maven Non-Recursive. Otw you might see some nasty log output which does not belong there ;)
>  
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)