topic Re: Error: Could not find or load main class local_project - DB2 in Talend Studio

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

Prabhakaran1 — Thu, 16 Aug 2018 14:16:15 GMT

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

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

Anonymous — Fri, 17 Aug 2018 07:29:51 GMT

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

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

Prabhakaran1 — Sat, 18 Aug 2018 05:59:02 GMT

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

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

Anonymous — Wed, 22 Aug 2018 09:17:01 GMT

Hello,

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

Best regards

Sabrina

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

Prabhakaran1 — Wed, 22 Aug 2018 14:46:15 GMT

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

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

Anonymous — Thu, 23 Aug 2018 10:43:21 GMT

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-changing-component/m-p/53011

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

Best regards

Sabrina

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

Prabhakaran1 — Fri, 24 Aug 2018 08:50:03 GMT

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/76590

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"

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

kasi — Tue, 07 Jan 2020 11:31:51 GMT

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

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

Anonymous — Fri, 21 Feb 2020 15:32:12 GMT

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