Author Message
NLiyana012024
Joined: Feb 2, 2021
Messages: 2
Offline
Hello,
We are seeing the following error after DB server upgrade to SQLServer 2017. What is the compatible sql driver to use with Java 1.6 and DD 5.1.

I am also trying to locate the SQL driver that's currently in the Appserver (webShpere) server. What's the path to it? Not familiar with WebSphere that much.

Return=-1,
e=The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.
Error: "java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 64".
ClientConnectionId:130c8ba1-5b79-41ff-9ab4-4c25be2944e2DSRA0010E: SQL State = 08S01, Error Code = 0


Thanks in advance
WilsonYu
Joined: Nov 6, 2013
Messages: 3950
Offline
I am pretty sure the problem is between Websphere and the JDBC driver. Also DD 5.1 is too old for us to do anything.
NLiyana012024
Joined: Feb 2, 2021
Messages: 2
Offline
Hi Wilson,
Where is the JDBC driver located at in Websphere? I was thinking of changing the driver and give it a try.

Thanks.
WilsonYu
Joined: Nov 6, 2013
Messages: 3950
Offline
That's part of the Websphere administrator. I can't tell you off top of my head (without access one now) since Websphere is not our product.
massimo__croci
Joined: Jan 31, 2020
Messages: 518
Offline
Hi.

For the JDBC driver on IBM WebSphere, take a look here:


https://www.ibm.com/support/knowledgecenter/SSFPJS_8.5.6/com.ibm.wbpm.imuc.doc/topics/tupdatejdbcdrivers.html


https://www.ibm.com/support/knowledgecenter/en/SSNW2F_5.2.1/com.ibm.p8.installingre.doc/p8pis063.htm
Go to:   
Mobile view