One Star

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
8 REPLIES
Moderator

Re: Connection Error while connecting to DB2 from Talend.

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Connection Error while connecting to DB2 from Talend.

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

Thanks,
Kaarthik
Moderator

Re: Connection Error while connecting to DB2 from Talend.

Hi
Could you please place them into path StudioPath>/lib/java to see if it is Ok with you?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Connection Error while connecting to DB2 from Talend.

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
Moderator

Re: Connection Error while connecting to DB2 from Talend.

Hi,
What's your OS and JDK? Did you use 32 bit OS and JDK?]
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Connection Error while connecting to DB2 from Talend.

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.

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.

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