BusinessConnect to MySQL server database fails after Daylight Saving Time change

BusinessConnect to MySQL server database fails after Daylight Saving Time change

book

Article ID: KB0075830

calendar_today

Updated On:

Products Versions
TIBCO BusinessConnect all versions

Description

After the Daylight Savings time change, BC can no longer connect to a MySQL database.  The error generated is: 

"java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up."


 

Environment

all environments with MySQL Databases

Resolution

This is because of a MySQL issue with regard to time synchronization between the MySQL client and the server.  To work around this issue, set the following two MySQL environment variables.

mysql> SET @@global.time_zone = '+00:00';

mysql> SET @@session.time_zone = '+00:00';

This will allow the client and the server to connect successfully.

Issue/Introduction

After the Daylight Saving Time change in March, BC can no longer connect to MySQL Database, after successfully connecting previously.