IBM Support

Connecting to Postgres using TLS secured protocol

Question & Answer


Question

When the stage is trying to connect by using a secure JDBC connection during job run, the job log reports:
"Fatal Error: The connector failed to connect to the data source. The reported error is: org.postgresql.util.PSQLException: SSL error: Received fatal alert: protocol_version"
Option: "sslmode=disable" into the "jdbc url" is working but not "sslmode=require"

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"ARM Category":[{"code":"a8m50000000L0zGAAS","label":"DataStage-\u003EJob Stages-\u003EDatabase Stages-\u003EJDBC Connector"}],"ARM Case Number":"TS009318971","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.7.0;11.7.1"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

More support for:
IBM InfoSphere DataStage

Component:
DataStage->Job Stages->Database Stages->JDBC Connector

Software version:
11.7.0, 11.7.1

Document number:
6586078

Modified date:
25 April 2025

UID

ibm16586078

Manage My Notification Subscriptions