java.sql.SQLException: Protocol violation with tOracleInput component

[Santosh2]

1. We are migrating OSGI Bundle created in open source to Enterprise 7.2.1
2. We are using component tOracleInput component to query large amounts of data from oracle tables. The component is using ojdbc6 in open source
3. 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

   ”
4. We created this ticket [

   Case: 00175835]

   for the issue and talend support suggested to use ojdbc7 instead of ojdbc6 for the database connection. 
5. As suggested by support, Linkedin upgraded the job to use ojdbc7. This solution worked in our UAT environment.
6. 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

[Anonymous]

Hi

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