topic Re: Oracle JDBC driver in Talend Studio

Oracle JDBC driver

borke02 — Fri, 15 Nov 2024 22:10:50 GMT

Hi there,

I'm using Talend Data Integration v8.0.1 and trying to connect to a Oracle database. For this I need to download and install the Oracle jdbc driver. The missing module is ojdbc8-19.3.0.0.jar. Do I have to download the file listet here: https://mvnrepository.com/artifact/com.oracle.ojdbc/ojdbc8?

The file is from Sep 15, 2019 and seems very old. Also there is a note that the artifact was moved to an other repository (https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc8).

Here I can download a version 21.8.0.0 from Dec 06, 2022. Again, there is a note that the artiface was moved to https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc10. Here, the latest version is 19.17.0.0 from Dec 01, 2022.

So, which version is the correct one?

Best regards

Frank

Re: Oracle JDBC driver

Anonymous — Mon, 23 Jan 2023 10:52:46 GMT

You can try a newer version of the Jar if you like, but I would stick with the one that the Studio is asking for. Talend Studio uses a multitude of third party Jars and it is tested to ensure that they are all compatible. The underlying code is written around those Jars. Now you can update them if you wish, but you do need to keep in mind that it can lead to problems. If that happens, then you can change the version of the Jar back.

ojdbc8-19.3.0.0.jar is guaranteed to work. Later versions *may* still work, but it is not guaranteed.

Re: Oracle JDBC driver

borke02 — Thu, 26 Jan 2023 12:25:50 GMT

Okay, thanks.

I just thought of security issues and therefore I wanted to use the newest driver.

Re: Oracle JDBC driver

Anonymous — Sun, 29 Jan 2023 15:46:43 GMT

In case of security issues, Talend will replace the JAR. This will be provided as a Monthly release (patch)

We're changing a lot of jars every month to keep up with CVE-s.

I'd suggest for you to take a look at this document: https://help.talend.com/r/en-US/8.0/studio-user-guide/overriding-external-modules-by-customizing-mvn-uri

If you customize it this way when Talend updates the dependency it will override your customization. (So years later you won't force a lower version of a dependency to studio like with tLibraryLoad.)