topic Re: Problem connection to Access DB in Talend Studio

Problem connection to Access DB

Anonymous — Sat, 16 Nov 2024 05:55:34 GMT

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!

Re: Problem connection to Access DB

nfz11 — Sat, 04 May 2019 07:00:30 GMT

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.

Re: Problem connection to Access DB

Anonymous — Mon, 06 May 2019 07:42:48 GMT

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

Re: Problem connection to Access DB

Anonymous — Mon, 06 May 2019 11:06:15 GMT

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

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

Re: Problem connection to Access DB

Anonymous — Fri, 10 May 2019 15:45:14 GMT

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!

Re: Problem connection to Access DB

Anonymous — Fri, 07 Jun 2019 12:20:00 GMT

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

Re: Problem connection to Access DB

lec86042 — Sun, 23 Feb 2020 03:48:03 GMT

I am using DI integration but i only able to connect to local access DB. If i try to connect to an access DB that is stored in our server then im unable to connect from my local pc ("jdbc:ucanaccess://W:/CPXDatabases/Test/chempax.mdb"). I have mapped the location to my pc but no luck. Anyway, i guess i will keep trying to see if changing to DI like you suggested works.

Re: Problem connection to Access DB

Anonymous — Sat, 18 Apr 2020 13:10:26 GMT

Hi Tom,

I'm facing the same subject for 48h.

When you say : "Talend Data Integration: Install Download required parameters...." you refer to ...?

Possibly to describe a little more ?

Thanks in advance,

Bogdan

Re: Problem connection to Access DB

lec86042 — Sat, 18 Apr 2020 16:58:48 GMT

Just make sure you install all the JARs. Jackcess is the main one. But once u install the DI app, start by using the tdbconnection then select Access and map the location. Once you have that you should be able to use the other db components/connectors to query tables or whatever u want.

Re: Problem connection to Access DB

Anonymous — Sat, 18 Apr 2020 18:28:23 GMT

Thank you for reply.

I've installed already all jack* jars and follow your instructions but unfortunately no positive results.

When I'm asked to connect to database it is mandatory to fill user name/ password/ jdbc parameters or I DON'T HAVE ANY cause no such parameters are defined.

Same thing if I try to set a Metadata connexion.

Regards

Re: Problem connection to Access DB

lec86042 — Sat, 18 Apr 2020 19:52:23 GMT

Can you show your errors?

I made it work using MetaData but it was super tough and i spent way too much time.

Using tDBConnection was easier to setup.

Database = Access and click Apply

Database = the path to where the access db is located (it may create errors if you did not adjust memory and you db is huge or not on local computer).

username & password is not needed but you get a warning, so i just enter my name and fake pwd.

That is it and you then create some connectors.

I'm not an expert but i will try to help if i can.

I attached an image of a simple workflow.

Snag_19aace38.png

Re: Problem connection to Access DB

BobSmileyJCF — Tue, 07 Jun 2022 22:53:30 GMT

Years after your post now, and I'm having the exact same issues.

I'm using a tDBConnection component selecting "Access" as the database, with a full path to my locally stored access database, but I can't guess a schema or issue a query in a tDBInput.

At first it said I needed jackcess jar files; I found them on mavenlink, downloaded and installed them, and I've now moved on to a new set of issues.

When clicking "guess schema" in the tDBInput basic settings tab, I get "Database connection is failed" dialog. I'd like to read the table schemas and data from my local access database and move it to a SQL Server back end, but I can't make the initial connection to the access database.

How did you get this to work? It's not a straightforward as i would expect given how easy it is to access data from more complex database systems!

Re: Problem connection to Access DB

ddurawilson1654689985 — Wed, 08 Jun 2022 12:36:35 GMT

Thanks for solution..