Oracle 19 support in Nuxeo LTS 2017

[Rodri_]

Hello,

I am working with nuxeo LTS 2017 right now and I am using Oracle as VCS. I have seen that the supported version for this nuxeo’s version is Oracle 12c. However, I want to know if it is possible to use Oracle 19. Is it? Can I work with nuxeo LTS 2017 + Oracle 19 even if in the documentation the supported version is 12c?

If not, can I know when nuxeo will add Oracle 19 support? I also checked nuxeo LTS 2019, but the supported versions are 12c and 18c, not 19.

Thank you.

[Patrick_Abgrall]

The official compatibility matrix for LTS 2017 at https://doc.nuxeo.com/nxdoc/910/compatibility-matrix/ states that 'Nuxeo Platform will likely work with greater versions of the aforementioned databases. Do not hesitate to inform Nuxeo support of your attempts with different versions.' In general, Nuxeo does not make new certifications on past releases. You might have to change the default JDBC drivers for Oracle new ones (Open questions that comes to mind: Are these compatible and certified with JDK 8? Are there dropped features in these latest releases of JDBC drivers, when compared to the 12c drivers with which Nuxeo is certified?)

[Rodri_]

Thanks for the info, I didn't notice that in the documentation!

[Rodri_]

Hello,

at the end, I am using Oracle 19 with Nuxeo LTS 2017. However, I am still using the ojdbc7 driver as the ojdbc8 driver gave me a lot of problems. If I put the ojdbc8 driver several errors appear while launching Nuxeo platform, so I kept the driver for Oracle 12c.

According to Oracle JDBC interoperability matrix, it is possible to use ojdcb7 with Oracle 19:

Information: https://www.oracle.com/database/technologies/faq-jdbc.html

Let's see if everything work good!

Regards.