topic Re: java.io.IOException: Protocol violation: [ 14, 32, ] in Talend Studio

java.io.IOException: Protocol violation: [ 14, 32, ]

ASingh1661970940 — Fri, 15 Nov 2024 22:36:09 GMT

Hi,

I am getting below java IOException in tDBinput(Oracle) component, can anyone help here.

Error: java.io.IOException: Protocol violation: [ 14, 32, ]

Thanks,

Asim

Re: java.io.IOException: Protocol violation: [ 14, 32, ]

Ruchi_27 — Wed, 31 Aug 2022 22:47:34 GMT

Hello,

I have found the following links to this problem:

http://stackoverflow.com/questions/29372626/sqlexception-protocol-violation-in-oracle

http://stackoverflow.com/questions/22785120/oracle-clob-reader-issue-protocol-violation

I hope this helps.

The problem seems to be related to CLOB. It seems that if the length of clob is 4193 characters, driver fails to retrieve and hence upgrading the driver to latest version might help resolve this issue.

Thanks!

Re: java.io.IOException: Protocol violation: [ 14, 32, ]

ASingh1661970940 — Thu, 01 Sep 2022 06:38:13 GMT

Yes you are correct, I have two CLOB field in my job, which is causing issue.

Thank you Ruchi.

Re: java.io.IOException: Protocol violation: [ 14, 32, ]

Daniel044 — Thu, 01 Sep 2022 07:31:09 GMT

I’m also having this exact issue.

Re: java.io.IOException: Protocol violation: [ 14, 32, ]

Ruchi_27 — Thu, 01 Sep 2022 07:41:30 GMT

Hello,

The problem seems to be related to CLOB. It seems that if the length of clob is 4193 characters, the driver fails to retrieve it, and hence upgrading the driver to the latest version might help resolve this issue.

http://stackoverflow.com/questions/22785120/oracle-clob-reader-issue-protocol-violation

Thanks!

Re: java.io.IOException: Protocol violation: [ 14, 32, ]

ASingh1661970940 — Thu, 01 Sep 2022 12:21:47 GMT

Thank you JFurman

Re: java.io.IOException: Protocol violation: [ 14, 32, ]

Daniel044 — Fri, 02 Sep 2022 04:35:10 GMT

I also have this same question and I cannot find any proper answers on the internet and also need a solution.