DB2 Connection Error - ClassNotFoundException: com.ibm.db2.jcc.DB2Driver

[Anonymous]

I'm trying to connect to DB2 in Talend, and I'm getting the error listed below.  Please note, I have all installed db2jcc_license_cisuz, db2jcc_license_cu, and db2jcc4.  I'm not being prompted to install any additional driver, but when I run my job, I get the error below.

Exception in component tDB2Connection_1 (Test_DB2_connect)

java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver

at java.net.URLClassLoader.findClass(URLClassLoader.java:381)

at java.lang.ClassLoader.loadClass(ClassLoader.java:424)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:335)

at java.lang.ClassLoader.loadClass(ClassLoader.java:357)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:264)

at vbr.test_db2_connect_0_1.Test_DB2_connect.tDB2Connection_1Process(Test_DB2_connect.java:455)

at vbr.test_db2_connect_0_1.Test_DB2_connect.runJobInTOS(Test_DB2_connect.java:855)

at vbr.test_db2_connect_0_1.Test_DB2_connect.main(Test_DB2_connect.java:604)

[FATAL]: vbr.test_db2_connect_0_1.Test_DB2_connect - tDB2Connection_1 com.ibm.db2.jcc.DB2Driver

[Anonymous]

Hello,

Can you please clarify in which Talend version/edition you are?6.x?

Best regards

Sabrina

[Anonymous]

Hello,

Here is a community article about:https://community.talend.com/t5/Migration-Configuration-and/ClassNotFoundException-when-running-a-Ta... 

Let us know if it helps.

Best regards

Sabrina

[Anonymous]

I'm on Version: 6.4.1

[Anonymous]

Where can I get Patch_20161124_TPS-1685_v2-6.2?

[Anonymous]

Hello,

https://jira.talendforge.org/browse/TDI-37694 

This issue is fixed in 6.0.2, 6.1.3, 6.2.2, 6.3.1.

What's IBM DB2 and IBM DB2 Z/OS version you are trying to connect? Did you try to create DB connection inside job using DB component or metadata connection?

Best regards

Sabrina

[Anonymous]

Hello,

Here is online installation guide for V 6.4 about:TalendHelpCenter: Supported systems, databases and business applications by Talend components .

Best regards

Sabrina

[Anonymous]

What folder should we be putting these files in? I tried in both the plugins folder and libraries. I'm still getting this error.

[Anonymous · Accepted solution]

Hi Sabrina,

I solved the issue.  Not sure why, but the jar files I had were corrupted.  When I replaced my current jars with new jars, it's working correctly now.  I appreciate your support, learned a lot with this issue.