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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch