Trouble with timezone with hibernate and MySQL

Question

I am trying to configure hibernate(5.3.3 Final) with tomcat (8.5) and mysql (v.8.0.12). When I launch my HibernateTest.java (very simple code from tutorial, no problem here) with the hibernate.connection.url set as ‘jdbc:mysql://localhost:3306/sakila’ I am encountering the following error:

Caused by: java.sql.SQLException: The server time zone value 'Paris, Madrid 
(heure d?été)' is unrecognized or represents more than one time zone. You 
must configure either the server or JDBC driver (via the serverTimezone 
configuration property) to use a more specifc time zone value if you want to 
utilize time zone support.

MySQL is currently set on the ‘SYSTEM’ timezone for the global and the session (mysql> select @@global.time_zone, @@session.time_zone). And my system timezone is indeed Paris/Madrid. In my hibernate.cfg.xml file, when I write the connection url :

jdbc:mysql://localhost:3306/sakila?useJDBCCompliantTimezoneShift=true;useLegacyDatetimeCode=false;serverTimezone=UTC;

The error is :

com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near '=false;serverTimezone=UTC;'.

It is not the problem mentioned in the stackoverflow post ‘issues with mysql server timezone and jdbc connection’, because the ‘&’ is refused by eclipse, see screenshot attached of the hibernate.cfg.xml file :

[The reference to entity "useLegacyDatetimeCode" must end with the delimiter ';'] 1

It is not an invisible character between 'mysql:' and '//localhost' as mentioned in the stackoverflow post ‘Malformed database URL, failed to parse the main URL sections’. I’ve tried to work the problem around by setting via MySql Workbench the option for the local time (default-time-zone = '+02:00') which fits with the summer time for Madrid/Paris (my case here). It doesn’t change a thing. Any idea? Do I have to configure it somewhere else? Thank you for your help, I've been on this one for 3 days now, without success.

Answer 1

I've finally came across a solution. As it looked that neither ';' nor '&' would do the trick to add more than one parameter, I took out all the parameters, and tried only one parameter :

jdbc:mysql://localhost:3306/sakila?serverTimezone=UTC

And it did the trick, I no longer have problems with this.

Answer 2

You need to escape the &:

jdbc:mysql://localhost:3306/sakila?useSSL=false&serverTimezone=UTC

See more here: https://docs.jboss.org/exojcr/1.12.13-GA/developer/en-US/html/ch-db-configuration-hibernate.html