IBM Support

IBM DataStage JDBC connector test connection fails with org.postgresql.util.PSQLException.

Question & Answer


Question

Why does IBM DataStage JDBC connector test connection fails with error: 
org.postgresql.util.PSQLException: An error occurred while setting up the GSS Encoded connection.

Cause

PostgreSQL 12 and later now allow GSSAPI encrypted connections. This parameter controls whether to enforce using GSSAPI encryption or not.

Answer

If encryption is not configured, should be disabled by setting JDBC connection parameter gssEncMode=disable.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSZJPZ","label":"IBM InfoSphere Information Server"},"ARM Category":[{"code":"a8m0z000000TN4xAAG","label":"DataStage->Job Stages->Real Time Stages->JDBC Connector"}],"ARM Case Number":"TS004107738","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
26 August 2020

UID

ibm16323207