IBM Support

jdbc conector giving misleading error message with org.postgresql.Driver jdbc driver.

Troubleshooting


Problem

DataStage Job aborts connecting to PostgreSQL database with the jdbc connector stage . The error msaage indicating that a suitable jdbc driver cannot be found.

Symptom

  Error message such as the following is seen in the Director log file.

   Item #: 11
   Event ID: 10
   Timestamp: 2018-07-02 12:58:50
   Type: Fatal
   User Name: scuuser
   Message Id: IIS-CONN-JDBC-00004
   Message: main_program: Fatal Error: The connector failed to locate a suitable driver for the specified URL value.

Cause

The URL provided is incorrect for PostgreSQL, for PostgreSQL this must contain a database name

jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

The give URL was just jdbc:postgresql://host, this will fail and produce the error message.

 

 

Environment

 

Diagnosing The Problem

 

Resolving The Problem

Provide a legal URL such as

jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

 

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
01 July 2018

UID

ibm10715519

Page Feedback