IBM Support

Teradata JDBC driver throws exception related to SSLMODE when connecting to a Teradata server

Troubleshooting


Problem

Teradata JDBC driver is unable to connect to the server and throws an exception error related to SSLMODE.
  
Caused by: java.io.IOException: SSLMODE=PREFER cannot use Teradata port 1025 connection because the database has HTTPS connections enabled, but a connection cannot be made on HTTPS port 443.
	at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.isUsableSocket(TDNetworkIOIF.java:1515)
	at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.connectToHost(TDNetworkIOIF.java:614)
	at com.teradata.jdbc.jdbc_4.io.TDNetworkIOIF.createSocketConnection(TDNetworkIOIF.java:185)

Cause

Teradata JDBC driver defect JDBC-191891 (Avoid IllegalArgumentException: Last character in replacement string).

Diagnosing The Problem

Cognos Analytics drivers folder includes version 20.00.00.08 or older of the Teradata JDBC driver.

Resolving The Problem

Use Teradata JDBC driver version 20.00.00.10 or higher.
 

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl3zAAC","label":"Administration"},{"code":"a8m50000000Cl6nAAC","label":"Data Source"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
23 August 2023

UID

ibm17028418

Page Feedback