topic Update / Switch to new installed module / Oracle jdbc driver? in Talend Studio

Update / Switch to new installed module / Oracle jdbc driver?

borke02 — Fri, 15 Nov 2024 21:47:21 GMT

Hi,

I have installed a new Oracle jdbc driver through the module tab. But after some clicks there is still the initial driver installed. How can I switch to the new driver?

The facts:

- Talend Data Integration v8.0.1

- Initial installed Oracle jdbc driver: ojdbc8-19.3.0.0.jar

- New Oracle jdbc driver: ojdbc8-23.2.0.0.jar

What I've done:

- Click on "three dots button" on the right of Maven URI

- Select ojdbc8-23.2.0.0.jar as the new module file

- Set Custom MVN URI to mvn:com.oracle.ojdbc/ojdbc8/23.2.0.0/jar

On module tab there is still ojdbc8-19.3.0.0.jar and mvn:com.oracle.ojdbc/ojdbc8/19.3.0.0/jar for the Oracle components

In studio\configuration\.m2\repository\com\oracle\ojdbc\ojdbc8 there is a sub folder 19.3.0.0 and 23.2.0.0

Best regards

Frank

Re: Update / Switch to new installed module / Oracle jdbc driver?

Anonymous — Wed, 24 May 2023 04:59:56 GMT

Hello,

Here is a JDBC driver version override documentation.

Could you please let us know if it helps for your use case?

https://help.talend.com/r/en-US/8.0/studio-user-guide/overriding-external-modules-by-customizing-mvn-uri

Best regards

Sabrina

Re: Update / Switch to new installed module / Oracle jdbc driver?

borke02 — Wed, 24 May 2023 12:21:58 GMT

Hi Sabrina,

I already did that with the new driver version. However, the Maven URI still points to version 19.3.0.0. When I select the new driver version and set the custom MVN URI, I get an error that this module is already installed. Should I set a different custom URI?

This is how it looks in the directory studio\configuration\.m2\repository\com\oracle\ojdbc\ojdbc8:

Best regards,

Frank

Re: Update / Switch to new installed module / Oracle jdbc driver?

Anonymous — Thu, 25 May 2023 07:20:24 GMT

Hello,

Are you using JDK 11? Is it OK with you to Load your new Oracle jdbc driver with tLibraryLoad beforing start Talend job?

Best regards

Sabrina