CODEWITHSUNDEEP
javaoracle-databasetls1.2
niespolo
niespolo

Reputation: 43

TLS versions for Java in Oracle Database

I am using a pl/sql procedure which calls a java class in Oracle Database 11g Enterprise Edition Release 11.2.0.4.0. The java class should make a call to a webservice, which however supports only TLS 1.1 and 1.2. I've checked the Java version as follows:

create or replace function test_get_java_property (prop in varchar2) return varchar2 is language java name 'java.lang.System.getProperty (java.lang.String) return java.lang.String';
SELECT dbms_java.get_ojvm_property (PROPSTRING => 'java.version') FROM dual;

The result of the query is "1.6.0_43" and if I type "java –version" from the path "E:\oracle\product\11.2\dbhome_1\jdk\bin" I get this:

Java version "1.5.0_51"
Java (TM) 2 Runtime Environment, Standard Edition (build 1.5.0_51-b10)
Java HotSpot (TM) 64-Bit Server VM (build 1.5.0_51-b10, mixed mode)

So the Java version doesn't support TLS 1.1 or 1.2. For this reason TLS 1.1 or 1.2 must be enabled. Maybe it's necessary to update the version of java in the database, if it is possible. If so, how should I proceed? I cannot update the Oracle version. I appreciate any other kind of solution.

Upvotes: 0

Views: 633

Answers (1)

Jonathan Rosenne
Jonathan Rosenne

Reputation: 2217

You probably need a proxy, i.e. a Java program which talks to the database with no security and talks TLS to the web service.

Upvotes: 1

Related Questions