Hi,
I have Oracle DB stored procedure (java) which:
- pulls data from Miscosoft SQL Server 2000 and
- inserts them into Oracle DB 11.2.0.2.0
Java version on Oracle DB is: 1.5.0_10
SELECT dbms_java.get_ojvm_property(PROPSTRING=>'java.version') FROM dual;
Problem occured when SQL Server was upgraded to version 2016.
- current jdbc driver wasn't able to connect to Microsoft SQL 2016 so newer driver was installed.
- new jdbc driver is compiled with higher java version so it can't be used from Oracle DB which runs jdk 1.5
- guess Oracle DB should have installed java 1.8 since java 1.7. have some security issues when connecting to Microsoft SQL 2016
* com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.lang.RuntimeException: Could not generate DH keypair"
Questions:
1. Is it possible to upgrade java on Oracle DB 11.2.0.2.0 from 1.5 to 1.8 and with what concequences?
2. How can we upgrade java on Oracle DB 11.2.0.2.0 to java 1.8
Br,
Dario
The JVM version is tightly integrated with the database. You can't upgrade it separately.
If you want to get to Java 1.8, you need to upgrade the database to 12.2