topic Re: How to update jackcess jar in Talend Studio

How to update jackcess jar

jeanphi45 — Sat, 16 Nov 2024 00:28:24 GMT

Hello ,

I have jackcess jar files here :

D:\TOS_BD-20190620_1446-V7.2.1\configuration\.m2\repository\com\healthmarketscience\jackcess\jackcess\2.1.12\jackcess-2.1.12.jar

D:\TOS_BD-20190620_1446-V7.2.1\configuration\.m2\repository\com\healthmarketscience\jackcess\jackcess-encrypt\2.1.4\jackcess-encrypt-2.1.4.jar

I would like to update them and if possible with a menu.

Which menu in Talend ?

Thanks in advance

Re: How to update jackcess jar

Anonymous — Wed, 10 Mar 2021 04:24:47 GMT

Do you want to replace it with a new version of jackcess jar? If so, please refer to this KB article.

https://community.talend.com/s/article/How-to-replace-the-old-Redshift-jar-on-the-system-with-the-new-one-hgPTn

Regards

Shong

Re: How to update jackcess jar

jeanphi45 — Fri, 19 Mar 2021 16:56:43 GMT

Hello it displays Invalid Page

Re: How to update jackcess jar

Anonymous — Mon, 22 Mar 2021 03:12:01 GMT

@Jean-Philippe Chenu, sorry, I did not notice that this article is only visible to Talend employees, I copy the article content here, please try the steps and let me know if it works.

Below are the steps for you to replace the old jar on your system with the new one:

1) Download the new RedshiftJDBC41-1.2.10.xxxx.jar and save it someplace on your system.

2) Close the studio. Go to <talendinstallation>\6.2.1\studio\configuration\.m2\repository\org\talend\libraries\RedshiftJDBC41-1.1.13.xxxx\6.0.0

and copy the name of the jar file which should be something like this - RedshiftJDBC41-1.1.13.1013-6.0.0. Copy the old jar from this location to someplace safe in case you need to go back to it.

3) Rename the newly downloaded jar with name in step 2 above and replace the old jar with this the newly downloaded-newly named jar

4) Restart studio and run your job.

Regards

Shong

Re: How to update jackcess jar

jeanphi45 — Thu, 25 Mar 2021 13:40:40 GMT

Thanks, but why Redshift ? And how to do when the version number changes ? If I create a directory (as jar version number) , how can Talend manage it ?

Re: How to update jackcess jar

jeanphi45 — Mon, 29 Mar 2021 14:22:43 GMT

It seems that even with a recent jackcess driver there is still the error "net.ucanaccess.jdbc.UcanaccessSQLException: precision or scale out of range" where there are text fields. I've tried with 2.23 and 4.0.0 jackcess drivers.

Re: How to update jackcess jar

jeanphi45 — Mon, 29 Mar 2021 15:33:32 GMT

Ok hum... It works when I fill the length of varchar fields in my output schema. When I migrated my project in v7 il have lost lengths in Metadata in input and then in the output.