|
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) |
