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

[JaneYu]

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

[Anonymous]

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 🙂

[JaneYu]

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.

[Anonymous]

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 🙂