topic Re: Issue connecting to db2 database using secure connection from talend in Talend Studio

Issue connecting to db2 database using secure connection from talend

Anonymous — Wed, 27 Jul 2016 09:18:26 GMT

Hi,
I need to make a secure connection to the db2 database. Following is the connection string.
jdbc:db2://10.106.178.39:50100/testdb:sslConnection=true
I tried giving the above connection string , it gives me a syntax incorrect error

If I try to give the connection stream jdbc:db2://10.106.178.39:50100/testdb it gives the below error.
Can someone please help on this?

Re: Issue connecting to db2 database using secure connection from talend

Anonymous — Thu, 28 Jul 2016 09:18:52 GMT

Hi,
Did you add sslConnection=true or secure=true in "Additional JDBC parameters" field?
Best regards
Sabrina

Re: Issue connecting to db2 database using secure connection from talend

Anonymous — Thu, 28 Jul 2016 10:31:30 GMT

I do not have 'Addittional JDBC parameters' in the Talend version that I am using .
I use version 6.2.1.
But yes, I tried giving the parameters in the connection string
jdbc:db2://10.106.178.39:50100/testDb?secure=true
However I still get a DisconnectNonTransientConnectionException while I try to connect.
Connection failure. You must change the Database Settings.
java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: A communication error occurred during operations on the connection's underlying socket, socket input stream,
or socket output stream. Error location: Reply.fill() - socketInputStream.read (-1). Message: Connection reset. ERRORCODE=-4499, SQLSTATE=08001
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)

Is there something that I am missing?

Re: Issue connecting to db2 database using secure connection from talend

Anonymous — Fri, 29 Jul 2016 08:55:08 GMT

Hi,
Here is an option ' Addittional JDBC parameters' in advanced settings of tdb2input component. Could you please try to use tdb2input to connect your DB directly to see if it works?
Best regards
Sabrina