IBM Support

JDBC_INIT_54 - Could not find the database due to invalid connection string

Troubleshooting


Problem

  1. The database server is unable to find the database name specified in the JDBC Connection String

    1. The database name may be misspelled or incorrect

    2. The database specified may not reside on the server specified.

    3. The JDBC Connection String may not be formatted correctly, leading the JDBC driver to improperly identify the database name.

Symptom

  1. Pipeline with a JDBC stage fails validation.

  2. When you select the validation error in the UI, it displays the following message: JDBC_INIT_54 - Could not find the database: JDBC Connection String

Resolving The Problem

  1. Verify the JDBC connection string to ensure the host, port, and database name are all correct.

  2. Verify the JDBC Connection String is in the correct format for the database driver in use

    1. Consult the database driver documentation to find the correct format for the connection string. For example:

      1. MySQL Connector/J: https://dev.mysql.com/doc/connector-j/en/connector-j-reference-jdbc-url-format.html

      2. Postgres JDBC Driver: https://jdbc.postgresql.org/documentation/use/#connecting-to-the-database

      3. Oracle Thin Client: https://docs.oracle.com/en/database/oracle/oracle-database/21/jajdb/

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

ibm17186212