topic Re: Connection Error while connecting to DB2 from Talend. in Talend Studio

Connection Error while connecting to DB2 from Talend.

Anonymous — Sat, 16 Nov 2024 11:31:00 GMT

Hi I am getting the below error while connecting to DB2. Can you please help me in this.
Exception in component tDB2Connection_1
java.lang.ClassNotFoundException: com.ibm.db2.jcc.DB2Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
connecting to socket on port 3946
connected
at java.lang.Class.forName(Unknown Source)
at sakthi.db2totd_0_1.DB2TOTD.tDB2Connection_1Process(DB2TOTD.java:293)
at sakthi.db2totd_0_1.DB2TOTD.runJobInTOS(DB2TOTD.java:540)
at sakthi.db2totd_0_1.DB2TOTD.main(DB2TOTD.java:405)
Caused by: java.util.zip.ZipException: invalid LOC header (bad signature)
at java.util.zip.ZipFile.read(Native Method)
at java.util.zip.ZipFile.access$1200(Unknown Source)
at java.util.zip.ZipFile$ZipFileInputStream.read(Unknown Source)
at java.util.zip.ZipFile$1.fill(Unknown Source)
at java.util.zip.InflaterInputStream.read(Unknown Source)
at sun.misc.Resource.getBytes(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$000(Unknown Source)
disconnected
Thanks,
Sakthi

Re: Connection Error while connecting to DB2 from Talend.

Anonymous — Fri, 05 Sep 2014 07:52:29 GMT

Hi,
Did you install required external jar into tDB2Input component? Have you checked document TalendHelpCenter:Identify required external modules and TalendHelpCenter:Install external modules?
Best regards
Sabrina

Re: Connection Error while connecting to DB2 from Talend.

Anonymous — Fri, 05 Sep 2014 08:01:54 GMT

Hi,
I had downloaded those 3 jars externally and installed it but not able to connect

Thanks,
Kaarthik

Re: Connection Error while connecting to DB2 from Talend.

Anonymous — Fri, 05 Sep 2014 08:29:40 GMT

Hi
Could you please place them into path StudioPath>/lib/java to see if it is Ok with you?
Best regards
Sabrina

Re: Connection Error while connecting to DB2 from Talend.

Anonymous — Fri, 05 Sep 2014 08:46:51 GMT

Hi,
I have put it in the the mentioned path but still getting the same error. I just googled and downloaded those jars. Will there be any problem in those Jar files can you please provide some link to download those files.
Thanks in Advance

Re: Connection Error while connecting to DB2 from Talend.

Anonymous — Fri, 05 Sep 2014 08:54:39 GMT

Hi,
What's your OS and JDK? Did you use 32 bit OS and JDK?]
Best regards
Sabrina

Re: Connection Error while connecting to DB2 from Talend.

Anonymous — Fri, 05 Sep 2014 09:11:09 GMT

Hi,
OS is Windows 7 and 32 bit jdk1.8.0_20
Am able to connect to ORACLE and TERADATA but not to DB2
Thannks,
Sakthi

Re: Connection Error while connecting to DB2 from Talend.

Anonymous — Tue, 15 Dec 2015 05:44:48 GMT

Did it work for anybody?
I also have connectivity issue with Db2 connecting to Talend, but i'm able to connect to Oracle, i have installed 3 jar files and i have Java 1.7. The error i'm getting is, but i'm able to connect to the same DB2 Database in command editor and through other applications.
Exception in component tDB2Input_1
com.ibm.db2.jcc.a.en: The application server rejected establishment of the connection.
An attempt was made to access a database, DPPSAH1, which was either not found or does not support transactions. ERRORCODE=-4499, SQLSTATE=08004
Thanks & Regards
Venkat

Re: Connection Error while connecting to DB2 from Talend.

Anonymous — Tue, 15 Dec 2015 12:43:29 GMT

The issue is resolved, it was due to one of the bad parameters.
Thanks & Regards
Venkat