topic Re: Talend Open Studio - tDBInput DB2 error "impossible de trouver ou charger la classe principale" in Installing and Upgrading

Talend Open Studio - tDBInput DB2 error "impossible de trouver ou charger la classe principale"

Anonymous — Sat, 16 Nov 2024 07:26:23 GMT

Hi, i'm french

When i run a simple job with only tDBInput on DB2 database, i have this error...

Not for MySQL or PostGreSQL !

I tried to change the db2jcc4.jar and db2jcc_licence_cisuz.jar but i still have the error.

I read that we had to make a new workspace for this error but it does not work better...
I reinstalled TOS (7.0.1) (JRE 1.8.0.181)

The other non-DB2 related job works fine, so I'm still thinking about a java connector problem...

Thank you in advance for your help.

Re: Talend Open Studio - tDBInput DB2 error "impossible de trouver ou charger la classe principale"

Anonymous — Mon, 22 Oct 2018 06:14:45 GMT

Hello,

I would recommend using JDK instead of JRE. Please have a look at these points.

Set the JAVA_HOME Environment variable:
Define your JAVA_HOME environment variable so that they point to the JDK installation directory.
Example: C:/Java/jdk1.8.65
Add the previously defined JAVA_HOME variable to the Path environment variable.
Example: <PathVariable>;%JAVA_HOME%\bin.

Additionally, if setting the JAVA HOME fails add the following line in the .ini file (example: Talend-Studio-win-x86_64.ini) for studio:

-vm path to java bin

Example:

-vm C:\Program Files\Java\jdk1.8.0_65 \bin

Let us know if it is OK with you.

Best regards

Sabrina

Re: Talend Open Studio - tDBInput DB2 error "impossible de trouver ou charger la classe principale"

Anonymous — Mon, 22 Oct 2018 09:10:39 GMT

Thank you but this answer is impossible.

This is not a general problem but only with BD2, so inevitably a problem of jar.

I thought the problem revolved around 3 jar DB2 (db2jcc4.jar, db2jcc_license_cisuz-6.1.0.jar, db2jcc_license_cu-6.0.0.jar) and I ended up finding the solution.

At work I go through a proxy and talend can not install its external archives itself
I download them myself (on https://talend-update.talend.com/nexus/content/repositories/libraries/org/talend/libraries/) and point to it when talend asks me.

But for db2jcc_license_cu, Talend asks me the 6.0.0 or the repository Talend only offers 6.1.0, when i choose it Talend accepts it but I have this error .

I was able to retrieve an older jar via a colleague who talend worked well with the DB2 component, jar of 2015 apparently ... and I do not have the error anymore !

I think you should put this jar 6.0.0 on Talend-update.

Cordially

talend-update_db2jcc_licence_cu.png