Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Connection Error while connecting to DB2 from Talend.

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
Labels (3)
8 Replies
Anonymous
Not applicable
Author

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
0683p000009MEcM.png 0683p000009MEqq.png
Anonymous
Not applicable
Author

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

Thanks,
Kaarthik
0683p000009MEqv.png
Anonymous
Not applicable
Author

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

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
0683p000009MEqX.png
Anonymous
Not applicable
Author

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

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
Anonymous
Not applicable
Author

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
Anonymous
Not applicable
Author

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