Troubleshooting
Problem
If a Schema name is provided in a JDBC stage which is using a MySQL database, the Schema name must match the Database name provided in the JDBC connection string.
The Schema field can be left blank. It is not a required field for MySQL databases.
The reason the Schema name (if provided) must match the Database name is that Database and Schema are two names for the same object in MySQL.
Symptom
A JDBC pipeline connecting to a MySQL datbase fails validation.
Selecting the Validation Error in the SDC UI displays the following message:
JDBC_104 - Schema must be empty or exactly the same as database name for MYSQL databases.
Resolving The Problem
There are two options to resolve this error:
Recommended: Leave the Schema field blank.
Example:
JDBC Connection String:jdbc:mysql://mysqldb.example.com:3306/testdb
Schema:
Alternative: configure the Schema to match the Database name in the JDBC Connection String:
Example:
JDBC Connection String:jdbc:mysql://mysqldb.example.com:3306/testdb
Schema:testdb
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
15 March 2025
UID
ibm17186196