topic Re: DB2 Connection Error - ClassNotFoundException: com.ibm.db2.jcc.DB2Driver in Talend Studio

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

Anonymous — Tue, 24 Sep 2019 20:15:19 GMT

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

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

Anonymous — Wed, 25 Sep 2019 04:29:50 GMT

Hello,

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

Best regards

Sabrina

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

Anonymous — Wed, 25 Sep 2019 04:30:30 GMT

Hello,

Here is a community article about:https://community.talend.com/t5/Migration-Configuration-and/ClassNotFoundException-when-running-a-Talend-6-2-1-Job-with-tDB2/ta-p/40380

Let us know if it helps.

Best regards

Sabrina

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

Anonymous — Wed, 25 Sep 2019 11:55:33 GMT

I'm on Version: 6.4.1

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

Anonymous — Wed, 25 Sep 2019 12:00:24 GMT

Where can I get Patch_20161124_TPS-1685_v2-6.2?

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

Anonymous — Fri, 27 Sep 2019 09:01:38 GMT

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

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

Anonymous — Fri, 27 Sep 2019 09:06:45 GMT

Hello,

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

Best regards

Sabrina

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

Anonymous — Fri, 27 Sep 2019 17:54:21 GMT

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

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

Anonymous — Fri, 27 Sep 2019 22:01:15 GMT

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.