This is an automated email from the ASF dual-hosted git repository.
struberg pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/openjpa.git
The following commit(s) were added to refs/heads/master by this push:
new f7a4445 OPENJPA-2753 downgade to 5.1.x MySQL jdbc driver
f7a4445 is described below
commit f7a4445e681cc7c30ed855283660aae38792215b
Author: Mark Struberg <strub...@apache.org>
AuthorDate: Fri Nov 2 13:42:25 2018 +0100
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 :(
---
pom.xml | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/pom.xml b/pom.xml
index c07884e..7315a38 100644
--- a/pom.xml
+++ b/pom.xml
@@ -75,7 +75,7 @@
<!-- common JDBC driver versions -->
<derby.version>10.14.2.0</derby.version>
<hsqldb.version>2.4.1</hsqldb.version>
- <mysql.connector.version>8.0.13</mysql.connector.version>
+ <mysql.connector.version>5.1.47</mysql.connector.version>
<postgresql.version>42.2.5</postgresql.version>
<!-- other common versions -->
<slf4j.version>1.7.23</slf4j.version>
