tAccessConnection issue

Six Stars

tAccessConnection issue

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


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


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.