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 !

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.

Tutorial

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.