Skip to main content

Qlik

cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
Announcements
A fresh, new look for the Data Integration & Quality forums and navigation! Read more about what's changed.
cancel
Turn on suggestions
Showing results for 
Search instead for 
Did you mean: 
borke02
Contributor III
‎2023-01-23 02:25 AM

Oracle JDBC driver

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

Labels (3)
Labels
1,376 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2023-01-23 05:52 AM

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.

View solution in original post

1,376 Views
0 Likes
3 Replies
Anonymous
Not applicable
‎2023-01-23 05:52 AM

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.

1,377 Views
0 Likes
borke02
Contributor III
‎2023-01-26 07:25 AM
Author

Okay, thanks.

 

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

1,376 Views
0 Likes
Anonymous
Not applicable
‎2023-01-29 10:46 AM

In response to borke02

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...

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.)

1,376 Views
0 Likes
Top