search cancel

Test Data Manager Portal - Unable to connect to MySQL


Article ID: 228699


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)



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:



TDM Portal  4.9.x

Component :


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


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.