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.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.