Author Message
RajaMohammed
Joined: Mar 9, 2014
Messages: 196
Offline
Dear,
I am using OD 7.0.1, JDK 1.7.0_05, Tomcat 7.0.55. It was working fine before. Recently Database team enabled TLS v1.2.
From that day my application throwing below error, when I test using OD eclipse. If I run same in OD 7.2.2, JDK 1.8 it is working fine. But I cannot use JDK OD 7.2.2 now due to some other internal issues.
So please help to fix OD 7.0.1 with JDK 1.7 to work work database with TLS v1.2 enabled.

06/09/2022 19:37:25 ERROR - In Progress | session id:usaumpp01-2022249163720-8 | AlinmaRetailRegistered_V61_4:HandleTables-CALL_DATA_HIST_INS | | The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:3ad3322c-4b11-4911-ad13-7b42c1141fd0". | Exception stack trace | EXCEPTION>
com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:3ad3322c-4b11-4911-ad13-7b42c1141fd0".
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:2670)
massimo__croci
Joined: Jan 31, 2020
Messages: 518
Offline
Hi.

Java/JDK/JRE 7 supports TLS 1.2 but the default is TLS 1.0 while Java/JDK/JRE 8 uses TLS 1.2 as default.

Take a look at

https://www.devconnectprogram.com/forums/posts/list/22155.page#p154039

RajaMohammed
Joined: Mar 9, 2014
Messages: 196
Offline
Yes. As I mentioned before, . If I run same in OD 7.2.2, JDK 1.8 it is working fine. But I cannot use JDK OD 7.2.2 now due to some other internal issues. And OD 7 not supports jdk 8.
massimo__croci
Joined: Jan 31, 2020
Messages: 518
Offline
- The oldest OD supporting Java/JDK/JRE 8 is the 7.1.0.0.1202 (https://www.devconnectprogram.com/site/global/products_resources/avaya_aura_orchestration_designer/releases/7_1/index.gsp).
Might you use that release ? Bear in mind it's 'End of support' since December 8th 2021 so no upgrade/patches/support/etc ...

- You can upgrade your Java 7 version to 1.7.0_131-b12 (7u131), but I'm not sure this release is free of any charge.
For JRE 1.7.0_131-b12, Oracle says (https://www.oracle.com/java/technologies/javase/7u131-relnotes.html)

" TLSv1.2 and TLSv1.1 are now enabled by default on the TLS client end-points. This is similar behavior to what already
happens in JDK 8 releases. "

- On the web there are many blogs showing how to 'enable' the TLS 1.2 on Java 7, but I never tried before so I cannot state "it
works" or "it's useful for your case".

No other ideas.

RajaMohammed
Joined: Mar 9, 2014
Messages: 196
Offline
Thank you very much brother. It is working fine now. I used JDK 1.7 u80 in same OD 7.0.1 and used DB string as jdbc:sqlserver://<<HostIP:Port>>>;databaseName=IVR;sslProtocol=TLSv1.2. May be helpful for others too.
massimo__croci
Joined: Jan 31, 2020
Messages: 518
Offline
Not a problem, glad it works now. Thanks for the info !
Go to:   
Mobile view