IBM Support

QUERY_EXECUTOR_002 - Can't open connection: Failed to get driver instance

Troubleshooting


Problem

In this case, the QUERY_EXECUTOR_002 error is referencing an additional underlying error, JDBC_06 - Failed to get driver instance.

The required database driver is not installed as an external library for the JDBC stage.

Documentation - JDBC Query Executor

Symptom

When validating or running a pipeline which uses the ‘JDBC Query Executor’ stage, the following error is displayed:

QUERY_EXECUTOR_002 - Can't open connection: JDBC_06 - Failed to initialize connection pool: java.lang.RuntimeException: Failed to get driver instance for jdbcUrl=<jdbc_connection_string>

Resolving The Problem

To add the necessary driver to the external library, please see the following steps:

  1. Select the JDBC Query stage > External Libraries, then click the Upload External Libraries button.

  2. Select the JDBC driver required for your specific database from your local environment.

  3. Save your changes, then restart the engine.

  4. After restarting, test the pipeline again to see if the error persists.

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

ibm17186092

Page Feedback