Error: Could not find or load main class local_project - DB2

[Prabhakaran1]

Hi,

       We are using Talend open studio Version 7.0.1, we got the following error while creating a table and insertion job in IBM DB2 using tDBoutput component.

Error: Could not find or load main class local_project

We have installed jdk1.8.0_161 in the system and we are not facing this issue while connecting the same component with Oracle or SQL Server

Please help

[Anonymous]

Hello,

Could you please try to check out "Die on error" option on basic settings of tDBOutput component to see if there is any error message printed on console?

Best regards

Sabrina

[Prabhakaran1]

Hi Sabrina,

             Thanks for your prompt reply, but we got the same error message even though Die on Error settings has enabled, please find the snapshot

[Anonymous]

Hello,

Does this issue only repro on this specific job? No extra space in your installation path?

Best regards

Sabrina

[Prabhakaran1]

Hi,

The issue only pertains to DB2 connection, we can able to connect other sources (Oracle, SQL Server) via both tDBinput & tDBoutput component. Even DB2 connection is connected through tDBinput component but we can't able to create a table via tDBoutput component. And also please refer the snapshot we have no spaces in installation path

Regards,

Prabhakaran

[Anonymous · Accepted solution]

Hello,

Could you please let us know if this resolved topic helps?

https://community.talend.com/t5/Design-and-Development/Could-not-find-or-load-main-class-after-chang...

Are these required jar files OK with you? db2jcc4.jar, db2jcc_license-cisuz.jar and db2jcc_license-cu.jar.

Best regards

Sabrina

[Prabhakaran1]

Hi,

  I followed the link shared ie., i downloaded & re-installed db2jcc_license_cu.jar file again. i got the error as db2jcc_license_cisuz. jar is not readable, then by following the below link, finally the issue has been resolved

Thank you...

https://community.talend.com/t5/Design-and-Development/Connecting-to-DB2-via-JDBC-missing-jar/m-p/76...

I would not recommend using the generic connection. You will run into trouble while reading metadata and also the type mapping does not work correctly.
The DB2 driver configuration has a misconfiguration in Talend because the Modules view show both license files:
db2jcc_licence_cisuz.jar
db2jcc_licence_cu.jar
as needed but only one is needed. This looks like a bug.
You can fix that by removing the line with the need first license file in:
/path/to/TOS/plugins/org.talend.designer.components.localprovider_5.4.1.r111943/components/tDB2Connection/tDB2Connection_java.xml
and all other DB2 components you use.
Alternatively you can change the attribute to REQUIRED="false"

[kasi]

Hi All,  I have faced same issues few Months back and got resolved by changing to  REQUIRED="false" . 

Now I am facing new after this many days ,My DB2 jobs are not able to run and showing it as.

Error: Could not find or load main class 

Job is not expecting any   DB2 jars

DB2.JPG

[Anonymous]

Same issue here. It's not a Job issue. The root cause is somewhere in the Studio. 

It's not the first time we have this issue.  And never with a clear resolution.

So far only deleting the workspace helps sometimes.

this needs to be solved as it is accuring randomly every few month on random Jobs