Modified on Fri, 16 Sep 2022 at 09:26 AM

Sign in fails with java.sql.SQLException in the backend log

While trying to log in, after the authentication, the Oops... Unable to process request error message is observed. The backend log contains an entry similar to the following: 

io.micronaut.transaction.exceptions.CannotCreateTransactionException: Could not open Hibernate Session for transaction
Caused by: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection
java.sql.SQLException: The server time zone value ‘CEST’ 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 specific time zone value if you want to utilize time zone support.


Generally, this means that the web application is not able to connect to the database and the JDBC client needs to specify the time zone value using serverTimezone.

To resolve this issue for theEurope/Amsterdam time zone, for example, update the value of TOWER_DB_URL as shown below:

export TOWER_DB_URL": "jdbc:mysql://<YOUR_DATABASE_IP>:3306/tower?serverTimezone=Europe/Amsterdam"

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article