Please login or register to access secure site features.

Note: By continuing to use DevConnect Program Services you agree to our latest Registered Member Terms.

Sign in using DevConnect ID

Forgot password?

Trouble logging in?

Submit a ticket for Registration Support.

I have an SSO ID

?
sign in

Don't have a DevConnect or SSO ID ?

Create a DevConnect account or join the program.

register now
^
Forum Index » Avaya Orchestration Designer » SQL Driver on WebSphere   XML
 
Author Message
NLiyana



Joined: 19/03/2021 14:01:05
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

This message was edited 1 time. Last update was at 19/03/2021 15:05:23

WilsonYu



Joined: 06/11/2013 14:29:24
Messages: 3720
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.
NLiyana



Joined: 19/03/2021 14:01:05
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: 06/11/2013 14:29:24
Messages: 3720
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: 31/01/2020 10:42:28
Messages: 71
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: