topic Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider in Talend Studio

tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

JaneYu — Fri, 08 Mar 2019 22:25:44 GMT

I have a talend job with only one component- tAccessConnection

the access database is saved at my local PC

Database: "C:/TOS_BD-20180116_1512-V6.5.1/workspace/test.accdb"

UserName: "" Password: ****

MS Access Databse 32 bit ODBC driver was installed ( My PC is 64 bit)

I got the following error, Please help.

Exception in thread "main" java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider
at org.talend.ucanaccess.encrypt.CryptCodecOpener.open(CryptCodecOpener.java:16)
at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:158)
at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:57)
at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:103)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at adhoc_cs25_00009.cs25_00009_0_1.CS25_00009.tAccessConnection_1Process(CS25_00009.java:603)
at adhoc_cs25_00009.cs25_00009_0_1.CS25_00009.runJobInTOS(CS25_00009.java:3128)
at adhoc_cs25_00009.cs25_00009_0_1.CS25_00009.main(CS25_00009.java:2874)
Caused by: java.lang.ClassNotFoundException: com.healthmarketscience.jackcess.CryptCodecProvider
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
[statistics] disconnected
at java.lang.ClassLoader.loadClass(Unknown Source)
... 9 more

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

Anonymous — Sat, 09 Mar 2019 07:13:28 GMT

Hi,

Could you please double check whether all the associated jars for the Access components were installed by you?

Usually when you are opening the component, if there is any missing jar, an orange ribbon will be there asking to install the missing jars from internet.

Could you please check it? also please verify the Modules view of Talend as shown in below link

https://help.talend.com/reader/9X9IRskQ0CYqyLOnf~MsXw/3S78DVaGGLL7uKyXjJn0dw

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

JaneYu — Mon, 11 Mar 2019 14:28:05 GMT

Hi Nikhil,

Thank you for your reply. I did install all necessary jars. please see below picture. Thank you.

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

JaneYu — Mon, 11 Mar 2019 14:31:51 GMT

Hi Nikhil,

When I run the talend job, it failed though the tAccessConnection looks ok. Below the screenshot. Thank you for your help

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

Anonymous — Tue, 12 Mar 2019 00:57:44 GMT

Hi,

Could you please add the missing library mentioned in the error using tLibraryLoad and try to run the job again?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

JaneYu — Wed, 13 Mar 2019 14:00:50 GMT

Hi Nikhil,

Could you please tell me which library to install?

I use tLoadLibrary and installed jackcess-encrypt-2.1.0.jar, jackcess-2.1.0.jar and ucanacess-2.0.9.5.jar, but still got error.

Exception in thread "main" java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

at org.talend.ucanaccess.encrypt.CryptCodecOpener.open(CryptCodecOpener.java:16)

at net.ucanaccess.jdbc.DBReference.<init>(DBReference.java:158)

at net.ucanaccess.jdbc.DBReferenceSingleton.loadReference(DBReferenceSingleton.java:57)

at net.ucanaccess.jdbc.UcanaccessDriver.connect(UcanaccessDriver.java:103)

at java.sql.DriverManager.getConnection(Unknown Source)

at adhoc_cs25_00009.testacessdb_0_1.TestAcessDB.tAccessConnection_2Process(TestAcessDB.java:546)

at adhoc_cs25_00009.testacessdb_0_1.TestAcessDB.runJobInTOS(TestAcessDB.java:2341)

at adhoc_cs25_00009.testacessdb_0_1.TestAcessDB.main(TestAcessDB.java:2087)

Caused by: java.lang.ClassNotFoundException: com.healthmarketscience.jackcess.CryptCodecProvider

at java.net.URLClassLoader.findClass(Unknown Source)

at java.lang.ClassLoader.loadClass(Unknown Source)

at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

Anonymous — Wed, 13 Mar 2019 18:36:52 GMT

Hi,

The error is saying that the class com.healthmarketscience.jackcess.CryptCodecProvider is missing. Could you please install any jar containing this class using tLibrarayLoad?

For example, http://www.java2s.com/Code/Jar/j/Downloadjackcessencrypt200jar.htm

Please double check the details of the Jar before installing to make sure that it is the right one (including the above example).

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

JaneYu — Wed, 13 Mar 2019 19:40:31 GMT

Hi Nikhil,

I downloaded that jackcess-encrypt-2.0.0.jar.zip from http://www.java2s.com/Code/Jar/j/Downloadjackcessencrypt200jar.htm

After extracting the zip file to jar file, I used tLibraryLoad and load the jackcess-encrypt-2.0.0.jar file.

However, I still got the same error after re-open the talend studio. Please help. Thank you

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

Anonymous — Wed, 13 Mar 2019 19:42:01 GMT

Hi,

Did you add the import command in the advanced section of tLibraryLoad?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

JaneYu — Wed, 13 Mar 2019 19:49:18 GMT

No, I did not do anything in the import command.

What I did is in Basic Settings of tLibraryLoad, Browse a Module File: ( find that jackcess-encrypt-2.0.0.jar), then run the talend job (with tLibraryLoad component).

What should I write in the import command? ( Advanced settings of tLibraryLoad, right?)

Thank you,

Jane

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

Anonymous — Wed, 13 Mar 2019 19:51:25 GMT

Hi Jane,

Please try import com.healthmarketscience.jackcess.CryptCodecProvider;

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

JaneYu — Wed, 13 Mar 2019 20:06:21 GMT

Hi Nikhil,

Now the access connection is working. It seems tLibrayLoad needs to run before tAccessConnetion every time.

I thought one time load is good for all other talend jobs.

Re: tAccessConnection failure-java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/CryptCodecProvider

Anonymous — Fri, 15 Mar 2019 09:04:13 GMT

Hi Jane,

You will have to use tLibrarayLoad every time in the job.

In case you are using a subscription product, I would recommend you to raise a service ticket to double check why the jar is not automatically allocated to the component.

If my posts have helped you to reach the solution, it would be great if you could mark my posts which helped you to arrive at the solution. It is the best way to tell thanks to the contributors to the community.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂