Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Dario.

Asked: March 08, 2018 - 3:17 pm UTC

Last updated: March 13, 2018 - 2:23 am UTC

Version: 11.2.0.2.0

Viewed 10K+ times! This question is

You Asked

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

and Chris said...

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

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

To Dario

J. Laurindo Chiappa, March 10, 2018 - 5:30 pm UTC

Two points :

- true, you canĀ“t upgrade the JVM only, but in each database patchset (and in each database PSU/CPU) you can receive JVM patches.. Besides that, the JVM component alone RECEIVES dedicated patches, too... Check with Support to see if any db patchset/cpu/psu OR any JVM patch fixed your connection problem... You are using 11.2.0.2.x AND the last db patchset in 11gR2 would let your version 11.2.0.4.y, check that...

and

- just to remember, in database 12c you CAN install/use MULTIPLE version of Java - another reason to upgrade to 12c asap....

Regards,

J. Laurindo Chiappa

Alternatives

Dario Nikolic, March 12, 2018 - 8:16 am UTC

Tnx Chris.

Guess solution will be:
- install java 1.8 on linux
- write java class in a way that:
- it connect's to both DBs and
- transfer data between them
- call that java from:
- crontab or
- oracle external job

Br,
Dario
Connor McDonald
March 13, 2018 - 2:23 am UTC

That is a reasonable approach to take, yes.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library