search cancel

Test Data Manager Portal - Unable to connect to MySQL

book

Article ID: 228699

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Hello;

I´m trying to make my TDM portal works with some MySql instances, and i can´t make it to work.

When i try to connect using Portal, it returns:

Exception raised: connection profile: GCMYSATUAT01_PLRCPROGRAMA cannot be used: : Failed to obtain JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.

I can connect from the server using ODBC,  and even using a DSN-Less ODBC on Datamaker, it works normally.

 

*I´m using the reference page: https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-9/installing/supported-data-sources/notes-on-implementation-with-specific-data-sources.html#concept.dita_1dcf72d4deca5c21cf3a2704f77ddf29624ee21f_mysqlmysql56

 

Environment

TDM Portal  4.9.x

Component :

Cause

Client needed a newer version of the MySQL JDBC driver to allow the connection

Resolution

Please download the mysql-connector-java-8.0.18.jar  and install a newer JDBC file in the TDM Portal.

The MySQL 8 drivers can be found here.
MySQL :: Download Connector/J

download the platform independent ones.
You will need to download and put it in the same place and restart the portal to test.
If this does not work we can set up a WebEx for me to review your environment.
We will need the ability during the session to restart the portal as needed.