Informix - Problem description
Problem IT35220 | Status: Closed |
JDBC FAILS TO CONNECT TO GROUP WHEN USING SSL | |
product: | |
IBM CSDK / 5724C2381 / 450 - CSDK 4.50 | |
Problem description: | |
When attempting to connect to a group that contains a single Connection Manager using SSL, the JDBC driver will fail with the following stack: 0 java.sql.SQLException java.sql.SQLException at com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java:1532 ) at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:169) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:270) at test_grp.main(test_grp.java:60) Caused by: com.informix.asf.IfxASFException at com.informix.asf.Connection.establishConnection(Connection.java: 1530) at com.informix.asf.Connection.connect(Connection.java:335) at com.informix.asf.Connection.connectToPrimary(Connection.java:187 9) at com.informix.asf.Connection.(Connection.java:324) at com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java:1257 ) ... 4 more Caused by: java.lang.IndexOutOfBoundsException at java.io.BufferedInputStream.read(BufferedInputStream.java:338) at com.informix.asf.IfxDataInputStream.read(IfxDataInputStream.java :121) at com.informix.asf.Connection.recvConnectionResponse(Connection.ja va:551) at com.informix.asf.Connection.establishConnection(Connection.java: 1445) ... 8 more Exception in thread "main" java.lang.NullPointerException at test_grp.main(test_grp.java:70) The error code displayed at the top of the stack is 0 in my internal tests on Linux however the customer running the same code from Windows receives a -79716 SQLCode. The same code runs successfully with Informix JDBC 4.10.JC12 and 4.10.JC13. It fails with Informix JDBC 4.50.JC3 and 4.50.JC4W1. It does not matter if I pass the SSL_TRUSTSTORE and SSL_TRUSTSTORE_PASSWORD at the command line or in the connection string url. Problem is easy to reproduce. I have a single Connection Manager in a group in my sqlhosts file like this: # --- Group for CM --- g_ss group - - e=ss_avail ss_avail onsocssl njdc-lxphx01 9405 g=g_ss I am using a SERVERSET in my Connection Manager configuration file like this: NAME testSSL_cm LOGFILE /work1/tpalmer/testing/cm/cm1.log SSL_LABEL test_cm SERVERSET testSSL_ss { INFORMIXSERVER ids1410fc3_ssl SLA ss_avail DBSERVERS=ids1410fc3_ssl } | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Informix JDBC 4.50. * **************************************************************** * PROBLEM DESCRIPTION: * * When attempting to connect to a group that contains a single * * Connection Manager using SSL, the JDBC driver will fail with * * the * * following stack: * * * * -79716 * * java.sql.SQLException * * java.sql.SQLException * * at * * com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java: * * 1532 * * ) * * at * * com.informix.jdbc.IfxDriver.connect(IfxDriver.java:169) * * at * * java.sql.DriverManager.getConnection(DriverManager.java:664) * * at * * java.sql.DriverManager.getConnection(DriverManager.java:270) * * at test_grp.main(test_grp.java:60) * * Caused by: com.informix.asf.IfxASFException * * at * * com.informix.asf.Connection.establishConnection(Connection.j * * ava: * * 1530) * * at * * com.informix.asf.Connection.connect(Connection.java:335) * * at * * com.informix.asf.Connection.connectToPrimary(Connection.java * * :187 * * 9) * * at * * com.informix.asf.Connection.(Connection.java:324) * * at * * com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java: * * 1257 * * ) * * ... 4 more * * Caused by: java.lang.IndexOutOfBoundsException * * at * * java.io.BufferedInputStream.read(BufferedInputStream.java:33 * * 8) * * at * * com.informix.asf.IfxDataInputStream.read(IfxDataInputStream. * * java * * :121) * * at * * com.informix.asf.Connection.recvConnectionResponse(Connectio * * n.ja * * va:551) * * at * * com.informix.asf.Connection.establishConnection(Connection.j * * ava: * * 1445) * * ... 8 more * * Exception in thread "main" java.lang.NullPointerException * * at test_grp.main(test_grp.java:70) * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * Users of Informix JDBC 4.50. * **************************************************************** * PROBLEM DESCRIPTION: * * When attempting to connect to a group that contains a single * * Connection Manager using SSL, the JDBC driver will fail with * * the * * following stack: * * * * -79716 * * java.sql.SQLException * * java.sql.SQLException * * at * * com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java: * * 1532 * * ) * * at * * com.informix.jdbc.IfxDriver.connect(IfxDriver.java:169) * * at * * java.sql.DriverManager.getConnection(DriverManager.java:664) * * at * * java.sql.DriverManager.getConnection(DriverManager.java:270) * * at test_grp.main(test_grp.java:60) * * Caused by: com.informix.asf.IfxASFException * * at * * com.informix.asf.Connection.establishConnection(Connection.j * * ava: * * 1530) * * at * * com.informix.asf.Connection.connect(Connection.java:335) * * at * * com.informix.asf.Connection.connectToPrimary(Connection.java * * :187 * * 9) * * at * * com.informix.asf.Connection.(Connection.java:324) * * at * * com.informix.jdbc.IfxSqliConnect.(IfxSqliConnect.java: * * 1257 * * ) * * ... 4 more * * Caused by: java.lang.IndexOutOfBoundsException * * at * * java.io.BufferedInputStream.read(BufferedInputStream.java:33 * * 8) * * at * * com.informix.asf.IfxDataInputStream.read(IfxDataInputStream. * * java * * :121) * * at * * com.informix.asf.Connection.recvConnectionResponse(Connectio * * n.ja * * va:551) * * at * * com.informix.asf.Connection.establishConnection(Connection.j * * ava: * * 1445) * * ... 8 more * * Exception in thread "main" java.lang.NullPointerException * * at test_grp.main(test_grp.java:70) * **************************************************************** * RECOMMENDATION: * **************************************************************** | |
Comment | |
Upgrade to Informix JDBC 4.50.JC6. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 09.12.2020 29.12.2020 29.12.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |