tAccessConnection issue

Anonymous — Mon, 05 Mar 2018 09:17:40 GMT

Hi all,

I try to connect to an Access DB with the tAccessConnection component but I have the following error :

Exception in component tAccessConnection_1 (test_job)

java.lang.ClassNotFoundException: net.ucanaccess.jdbc.UcanaccessDriver at java.net.URLClassLoader.findClass(Unknown Source)

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

at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at test.test_job_0_1.test_job.tAccessConnection_1Process(test_job.java:362)

at test.test_job_0_1.test_job.runJobInTOS(test_job.java:754)

at test.test_job_0_1.test_job.main(test_job.java:603)

I had :

- put all the jar needed by the component

- put also the UCanAccess-3.0.2-bin.zip

But I still have the issue

Can anyone help me ?

I also tried to load the UCanAccess-3.0.2-bin.zip with a tLibraryLoad but it doesn't work.

Thanks a lot !

Re: tAccessConnection issue

Anonymous — Tue, 06 Mar 2018 08:11:59 GMT

Hello,

Did you use tlibraryload to load external jars(UCanAccess-3.0.2-bin.jar)? Are you referring to component reference about:TalendHelpCenter:tLibraryLoad with a related scenario TalendHelpCenter:Library import scenario?

Best regards

Sabrina