Products | Versions |
---|---|
TIBCO BusinessConnect | all versions |
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."
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.