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

 

Cause

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

Environment

TDM Portal  4.9.x

Component :

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 indep[endent 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.