search

EUDAT-B2HANDLE / B2HANDLE-HRLS

Provides a Java servlet for local Handle System reverse-lookups and searching.
Apache License 2.0
0 stars 6 forks source link

hrls will not start after upgrade to version 8 of mysql-connector-java #59

Closed cookie33 closed 2 years ago

cookie33 commented 3 years ago

In #53 the mysql-connector-java version is updated from 5.1.x to 8.0.y

This causes the following issue. The hrls servlet will not load and gives the following error:

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: The server time zone value 'CEST'

In version 8 it needs a timezone to be set: https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-other-changes.html CEST is just not known.

This can be fixed by adding a timezone to the connection string for handlereverselookupservlet.properties. An example being:

sqlConnectionString = jdbc\:mysql\:///master_database?autoReconnect=true&serverTimezone=Europe/Amsterdam

Here following is added:

&serverTimezone=Europe/Amsterdam
cookie33 commented 2 years ago

Fixed in merged issues.. Close request.