Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2018-10-19 12:13 PM

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

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.
Labels (2)
Labels
673 Views
0 Likes
1 Solution

Accepted Solutions
Anonymous
Not applicable
‎2018-10-22 05:10 AM
Author

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

View solution in original post

673 Views
0 Likes
2 Replies
Anonymous
Not applicable
‎2018-10-22 02:14 AM
Author

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

673 Views
0 Likes
Anonymous
Not applicable
‎2018-10-22 05:10 AM
Author

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
674 Views
0 Likes