topic Re: DB2: DRDA Data Stream Syntax Error was detected. in Talend Studio

DB2: DRDA Data Stream Syntax Error was detected.

JDansena1661944160 — Fri, 15 Nov 2024 22:36:17 GMT

I am to connect db while creating connection.

when trying to execute job then connection is failed not able to connect to IBM db2 not sure

Database connection is failed.

java.lang.RuntimeException: com.ibm.db2.jcc.am.DisconnectNonTransientException: [jcc][t4][2034][11148][4.9.78] Execution failed due to a distribution protocol error that caused deallocation of the conversation.

A DRDA Data Stream Syntax Error was detected. Reason: 0x3. ERRORCODE=-4499, SQLSTATE=58009

at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:208)

at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1170)

Re: DB2: DRDA Data Stream Syntax Error was detected.

Tins1980 — Thu, 01 Sep 2022 07:18:04 GMT

I faced similar kind of issue last time, I am still searching for some proper solution.

Re: DB2: DRDA Data Stream Syntax Error was detected.

JDansena1661944160 — Fri, 02 Sep 2022 06:40:38 GMT

Fixed above issue, problems was while connecting through connection then connection was success but while execute with component time it not going to connect to DB that is the problems.

Solution: try to create JDBC connection and add jar after that we can use that connection on component.

Component level