What ojdbc driver we have to use with confluence 7.13?

[Vaibhav Dingreja]

We are upgrading our confluence from 7.3.5 to 7.13. But we are getting this error.

2021-09-01 11:13:55,944 ERROR [Catalina-utility-1] [ContainerBase.[Standalone].[localhost].[/]] log Exception sending context initialized event to listener instance of class [com.atlassian.confluence.setup.ConfluenceConfigurationListener]
java.lang.UnsupportedClassVersionError: oracle/jdbc/OracleDriver has been compiled by a more recent version of the Java Runtime (class file version 54.0), this version of the Java Runtime only recognizes class file versions up to 52.0 (unable to load class [oracle.jdbc.OracleDriver])
at org.apache.catalina.loader.WebappClassLoaderBase.findClassInternal(WebappClassLoaderBase.java:2437)
at org.apache.catalina.loader.WebappClassLoaderBase.findClass(WebappClassLoaderBase.java:864)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1333)
at org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1187)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)

[Tinker Fadoua]

@Vaibhav Dingreja 

Let me jump here as this is one of my favourite topics.

Did you read the upgrade notes for the versions in between? I will invite you to spend sometime doing it as there are configuration changes you need to be aware of.

Let me know if you have any questions.

Best,

Fadoua

[Kishan Sharma]

Hi @Vaibhav Dingreja Welcome to the Community!

Installing Oracle thin driver will do in your case. 

For Oracle 12c R2 use the 12.2.0.x driver (ojdbc8.jar)

For Oracle 19c you can use either ojdbc8.jar or ojdbc10.jar.

Please refer this link for more details.

[Vaibhav Dingreja]

We tried with 10.jar only and we are using oracle 19c and then only we facing this error

[Kishan Sharma]

Can you please confirm which JDK/JRE version are you using ? As per this link some Oracle Java versions have bugs that impact Confluence. You can't run Confluence on Java 1.8.0_25 and 1.8.0_31 

[Vaibhav Dingreja]

we are using openjdk version "1.8.0_275".

[Vaibhav Dingreja]

Which version of jdk is supported by confluence7.13?

[Kishan Sharma]

Below Oracle JRE / JDK versions are supported by Confluence 7.13

Java 1.8

Java 11

Have you tried ojdbc8.jar to see it that works? 

[Saad Ahmed]

Hi Kishan,

Vaibhav is my colleague.

I have a question here - could you please suggest us what version of ojdbc driver we should use? we are on oracle 19c.

I understand above you suggested to use 8.jar and 10,jar for 19c, But we have different versions for driver as well. Could you suggest us here? As this this link only suggests 8.jar or 10.jar for 19c and not the driver version.

Regards,

Saad.

[Kishan Sharma]

Hi Saad,

You can test with below JREs which were used by Atlassian when testing Confluence.

Oracle JDK 8u291
Oracle JDK 11.0.11
Adoptium OpenJDK 8u292b10

The JDBC thin driver mentioned here should work.