How to resolve "JDBC URL not correct" while connecting to MySQL 5.5 using Mysql 8 adapter in TDV ?

How to resolve "JDBC URL not correct" while connecting to MySQL 5.5 using Mysql 8 adapter in TDV ?

book

Article ID: KB0072151

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.5.2

Description

How to resolve "JDBC URL not correct"  while connecting to MySQL 5.5 using Mysql 8 adapter in TDV ? 

 

Issue/Introduction

How to resolve "JDBC URL not correct" while connecting to MySQL 5.5 using Mysql 8 adapter in TDV ?

Resolution

In some instances, some 5.5 MySql servers will need 2 extra parameters in the end of the JDBC string in order to connect correctly.

"?useSSL=false&allowPublicKeyRetrieval=true"

This is based on the way the server is configured.

Using the useSSL=False flag disables SSL requirements for the connection, making it compatible with previous versions which do not support SSL connections or do not have the configuration enabled.

And the allowPublicKeyRetrieval=true flag allows the client to automatically request the RSA public key from the server.

 

Additional Information

Powered by Wolken Software