java.sql.SQLException: Protocol violation with tOracleInput component

Santosh2 — Sat, 16 Nov 2024 01:52:32 GMT

We are migrating OSGI Bundle created in open source to Enterprise 7.2.1
We are using component tOracleInput component to query large amounts of data from oracle tables. The component is using ojdbc6 in open source
When we migrated the job to enterprise version and ran the job in the karaf runtime in our UAT environment, we ran into the following error with the tOracleInput component. “
java.sql.SQLException: Protocol violation
”
We created this ticket [
Case: 00175835]
for the issue and talend support suggested to use ojdbc7 instead of ojdbc6 for the database connection.
As suggested by support, Linkedin upgraded the job to use ojdbc7. This solution worked in our UAT environment.
We moved the code that was tested in UAT to Production environment. But in Production the component tOracleInput is still failing with “
java.sql.SQLException: Protocol violation” even after upgrading the ojbc jar to version 7 as suggested by talend support

Re: java.sql.SQLException: Protocol violation with tOracleInput component

Anonymous — Sun, 19 Jul 2020 08:36:19 GMT

Basically, this issue is caused by JDBC driver, can you check and let me know which version of Oracle database you are using? and the version of ojdbc7? take a look at the related issue:

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

Regards

Shong

topic Re: java.sql.SQLException: Protocol violation with tOracleInput component in Talend Studio

java.sql.SQLException: Protocol violation with tOracleInput component

Re: java.sql.SQLException: Protocol violation with tOracleInput component