Troubleshooting
Problem
When trying to set up a connection to MySQL using the jdbc connector 8.x versions, the connection fails with
XQE-DS-0006 Unable to logon to the data source
Symptom
DataSource connection test fails
Cause
The jdbc classes for MySQL were significantly updated. There is now a need to specify if SSL is used as well as the Timezone.
Resolving The Problem
Change your connection parameters from
jdbc:mysql://ServerName:Port/DatabaseName?padCharsWithSpace=true&noAccessToProcedureBodies=true or
jdbc:mysql://ServerName:Port/DatabaseName?noAccessToProcedureBodies=true
To
jdbc:mysql://ServerName:Port/DatabaseName?padCharsWithSpace=true&noAccessToProcedureBodies=true&useSSL=False&serverTimezone=America/New_York
or
jdbc:mysql://ServerName:Port/DatabaseName?noAccessToProcedureBodies=true&useSSL=False&serverTimezone=America/New_York
Please note that Timezone is unique per environment. America/New_York was used as an Example.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"","label":""}],"Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
14 August 2020
UID
ibm16260215