The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

TDV New Datasource Creation Error


Jyothsna Nayak

Recommended Posts

We are facing the following error when creating a MySQL Datasource in TDV Studio.

Unable to connect to data source "/shared/Admin Database/Data Sources/CACHE DATABASE/MySQL Cache" at

"xx.xx.xx.xx:3306@" with the supplied connection information. [datasrc-3961050]

Unable to connect to data source "/shared/Admin Database/Data Sources/CACHE DATABASE/MySQL Cache" at

"jdbc:mysql://xx.xx.xx.xx:3306/DBNAME". Make sure the URL information, user name and password

are correct. [datasrc-3961025]

Cause: Communications link failure

 

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. [Log ID: 85a492e6-04c4-491a-be42-d9b29eb93472]What can be done to correct this error

Link to comment
Share on other sites

We raised a ticket with Tibco Support to resolve this issue.

They instructed us to follow the following steps to resolve the issue.

1. Open the advanced settings panel for the datasource. Then change the connection format to "mysql://xx.xx.xx.xx:3306/DBNameuseSSL=false&allowPublicKeyRetrieval=true"

2. Change jar from mysql-connector-java-8.0.11.jar to mysql-connector-java-5.1.48.jar. Placethe jar file "mysql-connector-java-5.1.48.jar" in location "confadapterssystemmysql_5_5". Then restart the TDV server.

3. Createda new MySql 5.5 datasource with the same connection details as earlier. Create datasource and introspect to fetch underlying objects.

This fixed the issue and we were able to connect and introspect the MySQL 8.0 database.

Note: It is important that connectivity between the TDV server and the MySQL Database is active on port 3306.

Thank you.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...