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 !

1 REPLY
Moderator

Re: tAccessConnection issue

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

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