Changeset 7822

Timestamp:

Jun 8, 2020, 1:32:37 PM (3 years ago)

Author:

Nicklas Nordborg

Message:

References #2214: Upgrade Hibernate and other 3-rd party components

Updated MySQL JDBC driver to 8.0.19. The 8.0.20 was also tested but there seems to be an issue with Date parameters in some queries: ​https://bugs.mysql.com/bug.php?id=99713

I have also changed the default configuration to use MySQL 8.

There was an issue with the TestChangeHistory.test_list_by_user() that sometimes worked and sometimes failed. The most likely reason is the filter on the current time which could be affected by rounding milliseconds up/down, so the timestamp used for filtering was modified by -1 second.

Location:

trunk

Files:

• config/dist/base.config (modified) (1 diff)
• doc/3rd-party-components.txt (modified) (1 diff)
• lib/dist/mysql-connector-java-8.0.13.jar (deleted)
• lib/dist/mysql-connector-java-8.0.19.jar (added)
• src/test/TestChangeHistory.java (modified) (2 diffs)

trunk/config/dist/base.config

@@ -36 +36 @@
 # MySQL
 # -----
-# db.dialect          = org.hibernate.dialect.MySQL5InnoDBDialect
-# db.url              = jdbc:mysql://localhost/base2?characterEncoding=UTF-8&useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true
+# db.dialect          = org.hibernate.dialect.MySQL8Dialect
+# db.url              = jdbc:mysql://localhost/base2?characterEncoding=UTF-8&useCursorFetch=true&defaultFetchSize=100&useServerPrepStmts=true&sslMode=DISABLED
 # db.dynamic.catalog  = base2dynamic
 # db.queries          = /mysql-queries.xml

trunk/doc/3rd-party-components.txt

@@ -106 +106 @@
 needed if you are using MySQL as your database.
 
-More info : http://www.mysql.com/products/connector/
-Version   : 8.0.13
+More info : https://dev.mysql.com/downloads/connector/j/
+Version   : 8.0.19
 License   : GPLv2 (mysql-connector-LICENSE.txt)
-Jar files : mysql-connector-java-8.0.13.jar
+Jar files : mysql-connector-java-8.0.19.jar
 
 

trunk/src/test/TestChangeHistory.java

@@ -86 +86 @@
     
     //LogManagerFactory old = set_log_manager(new DbLogManagerFactory());
-    Date since = new Date();
+    Date since = new Date(System.currentTimeMillis()-1000);
     int bioSourceId = TestBioSource.test_create("Biosource 1", false);
     int sampleId = TestSample.test_create(bioSourceId, "Sample 1", 0, false);
@@ -181 +181 @@
       {
         q.restrict(Restrictions.gteq(Hql.property("hst", "time"), 
-            Expressions.parameter("time", since)));
+            Expressions.parameter("time", since, Type.TIMESTAMP)));
       }
       ItemResultList<ChangeHistory> l = q.list(dc);