IBM Support

JDBC_INIT_56 - Could not connect to the database

Troubleshooting


Problem

  1. The JDBC connection string is not correct.

  2. The target database is either not running or is not reachable from the Data Collector server due to a networking issue.

Symptom

When validating, previewing, or running a pipeline, the error JDBC_INIT_56 - Could not connect to the database occurs.

image-20240412-184557.png

Resolving The Problem

  1. Make sure that the JDBC connection string is correct, particularly the IP address/hostname and the port number, for the target database. Refer to the database vendor’s documentation for the correct syntax for the JDBC connection string.

  2. Ensure that the database is up and running and that it is reachable from the server where the Data Collector is running. A socket connect test at the command line may be performed to ensure that connectivity between the Data Collector server and the database is working as expected. For example, this is a successful socket connect test for a local instance of a MySQL database:

     % telnet localhost 3306
Trying ::1...
Connected to localhost.
Escape character is '^]'.
J
8.0.3kd0kk�<aU"@Rx>O
                    vcaching_sha2_password^CConnection closed by foreign host.

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

ibm17186214

Page Feedback