You can translate the question and the replies:

Unable to create jdbc data source in denodo design studio

Hi Team, Denodo installation is done in aws,am trying to create JDBC data source in denodo design studio in local machine ,am using mysql database as a source ,i have added mysql connector version 8 driver (.jar) in denodo home(denodo/lib/extensions/jdbc-drivers-external/mysql-5/) which is in aws ,i selected mysql5 adapter while creating data source but am getting error as "unable to establish the connection:communication link failure the last packet sent successfully to the server was 0 milliseconds ago,the driver has not recieved any packet from the server", please help me resolve this issue, Thank you
user
03-11-2021 04:44:04 -0400

1 Answer

Hi, This error typically occurs when a client has a problem connecting to the MySQL server. It could be related to firewall settings, port in use, or incorrect URI. For example, I followed the [Importing a JDBC Driver User Guide](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/importing_extensions/importing_extensions#importing-a-jdbc-driver) to import the mysql version 8 driver and I also got this error. I looked in the data source driver properties, and saw that the property useSSL was true by default. Setting this property to false resolved my error. I would suggest you check with an administrator to confirm that there is no connection issue between the Denodo server and the MySQL server. I would also validate the connection URI using any third party tool to test if the connection URI is correct and works. Hope this helps!
Denodo Team
03-11-2021 16:13:37 -0400
You must sign in to add an answer. If you do not have an account, you can register here