Problem Creating Connection profile for MySQL Running in Azure

book

Article ID: 140373

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Need to create a connection profile for a MySQL 5.7 database.

Installed the Connector/J component and copied the mysql-connector-java-8.0.18.jar file to folder C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers and restarted the Portal.

The MySQL database runs in Azure.

The application that starts, in Tomcat, requires the following information to be added in the connection string to indicate that MySQL uses SSL and is in UTC time zone.

useUnicode=true&useSSL=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

When creating the connection profile from the TDM Portal, the following error message is presented:

Failed to connect.

The server replied: Failed to obtain JDBC Connection; The server time zone value '' 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.

 

Environment

Release : 4.8.1

Component : CA Test Data Manager

Resolution

Needed needed to change, in Azure, the timezone to UTC and this resolved the issue.