IBM Support

JDBC_INIT_38 - MySQL Database Name and Schema Mismatch

Troubleshooting


Problem

  1. If a Schema name is provided in a JDBC stage connecting to a MySQL database, the Schema name must match the Database Name provided in the JDBC connection string.

    1. The Schema field can be left blank. It is not a required field for MySQL databases.

    2. 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

  1. Pipeline using a JDBC stage with a MySQL database fails validation.

  2. Selecting the validation error in the UI produces the following error messages:

    1. JDBC_INIT_38 - The Schema Name must be empty or exactly the same as database name for MYSQL databases

Resolving The Problem

There are two methods to resolve this error:

  1. Recommended: Leave the Schema field blank.

    1. Example:

      JDBC Connection String: jdbc:mysql://mysqldb.example.com:3306/testdb

      Schema:

  2. Alternative: Configure the schema field to match the database name.

    1. Example:

      JDBC Connection String: jdbc:mysql://mysqldb.example.com:3306/testdb

      Schema: testdb

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSM7CU","label":"IBM StreamSets Data Collector"},"ARM Category":[{"code":"","label":""}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
15 March 2025

UID

ibm17186209

Page Feedback