topic Re: Upgrade a JDBC Driver in Talend Studio

Upgrade a JDBC Driver

drosemeyer — Mon, 05 Dec 2016 13:26:39 GMT

After installation of Talend Open Studio 6.2/6.3 PostgreSQL V9.4 configuration uses driver postgresql-9.4-1201.jdbc41.jar. PostgreSQL recommends using postgresql-9.4.1212.jar for java 1.8 environment.
It is easy to change the driver in the job for delivery but I didn’t find a way to change it in Open Studio workbench.
Can anyone help me to solve this problem?
Regards Dirk

Re: Upgrade a JDBC Driver

Anonymous — Tue, 06 Dec 2016 03:50:45 GMT

Hi,
The driver files are in the maven repository. Check you own repository (user-home/.m2/repositories/org/talend/libraries/)
Could you please try to rename your new .jar file with the old one(rename postgresql-9.4.1212.jar as postgresql-9.4-1201.jdbc41.jar) and restart your studio to see if it works?

Best regards
Sabrina

Re: Upgrade a JDBC Driver

Anonymous — Tue, 06 Dec 2016 08:20:26 GMT

I am currently working on an update and will suggest Talend this. In this update is also included the latest JDBC driver.
But for now: Please try to load the recent driver with tLibraryLoad at the earliest possible time in your job.

Re: Upgrade a JDBC Driver

drosemeyer — Tue, 06 Dec 2016 08:46:37 GMT

Hi Sabrina,
this works, thanks a lot.
In my Windows installation the repository is located in
<talend home>\configuration\.m2\repository\org\talend\libraries\
Is it planned to provide a function for this in future releases?
Regards Dirk

Re: Upgrade a JDBC Driver

Anonymous — Tue, 06 Dec 2016 10:20:28 GMT

Poisoning the maven is a very ugly solution and will not work in the enterprise release.
I cannot hardly imagine, Talend will provide such a function to "tweak" the maven this way. It violates a clean software engineering.

Re: Upgrade a JDBC Driver

Anonymous — Wed, 07 Dec 2016 09:27:40 GMT

Hi,
Thanks for your suggestion. Feel free to create a new feature/work item jira issue on talend bug tracker.
Best regards
Sabrina

Re: Upgrade a JDBC Driver

Anonymous — Thu, 12 Sep 2019 21:54:15 GMT

Is there any best way to update the OJDBC7 to 8 version instead of delete and rename (Looks not proper way)