Problem connection to Access DB

Five Stars

Problem connection to Access DB

Hello,

 

I'm new to Talend and I have a problem to connect to my MS Access DB.
I'm using Talend big data 7.1 and Access 2013.
When creating a new connection to a database and testing my connection to my Access file I have this message:

(translation: fail to connection You must modify parameters of the database)
Echec de la connexion Vous devez modifier les paramètres de la base de données.
java.lang.RuntimeException: java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/util/ErrorHandler
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:204)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1139)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:4189)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$67.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NoClassDefFoundError: com/healthmarketscience/jackcess/util/ErrorHandler
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:124)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:149)
... 9 more
Caused by: java.lang.ClassNotFoundException: com.healthmarketscience.jackcess.util.ErrorHandler
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
... 13 more

 

I also have this additionnal parameter:jackcessOpener=org.talend.ucanaccess.encrypt.CryptCodecOpener;memory=false
I don't know what it is...

I checked my ODBC manager (I'm in 64) and I have MS Access Database with .mdb .accdb.

In this form, it is not working BUT!

It is working fine when I'm using tAccessConnection. I can perfectly connect to my table in Access and send it to my MariaDb.
But I have 15 tables and I don't want to have 15 tAccessConnection and manually write all the schemas...

 

Thanks for your help! Smiley Happy


Accepted Solutions
Five Stars

Re: Problem connection to Access DB

I come back a month later, not to thanks someone, but to give the solution I found if anybody read this:

Talend Big Data: Desinstall

Talend Data Integration: Install

Download required parameters.

Works perfectly.
Thanks to myself Smiley Happy


All Replies
Nine Stars

Re: Problem connection to Access DB

What is this class?

 

com/healthmarketscience/jackcess/util/ErrorHandler

Is this something custom to your business?  The Java classloader cannot find it which is the source of your error.  You may need to add a .jar file with that class to the classpath of your project.  Do a search for adding custom jars to Talend.

 

--
Please give Kudos and mark topics as solved where appropriate.
Five Stars

Re: Problem connection to Access DB

Hello,

 

Thanks for your answer.

 

I actually tried to download a .jar of that jackcess and put in my classpath.

But I don't know where is that classpath... I tried to copy it in different parts of my workspace, without success...

For exemple here: http://www.java2s.com/Code/Jar/j/Downloadjackcess200jar.htm

Five Stars

Re: Problem connection to Access DB

After many tries and installs, you can see in the screenshot what I have on the project.

2019-05-06_12h03_06.png2019-05-06_12h04_21.png

 

I also went into Window->Preferences->Java->Build Path and I also create a library.

Five Stars

Re: Problem connection to Access DB

Hello,

 

Can someone help me, I really need to create as simple as it should be, a connexion to my Access DB.

 

Thanks a lot!

Five Stars

Re: Problem connection to Access DB

I come back a month later, not to thanks someone, but to give the solution I found if anybody read this:

Talend Big Data: Desinstall

Talend Data Integration: Install

Download required parameters.

Works perfectly.
Thanks to myself Smiley Happy

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now