No more data to read from socket Error in Exception in component tOracleInput component

[Gagan1]

Hi Team ,

Could you help me resolve error , facing in

Exception in component tOracleInputtOracleInput when i define cursor size however without cursor size , no error throw.

Error :

Exception in component tOracleInput_2 (GXHI_PROD)

java.sql.SQLRecoverableException: No more data to read from socket

at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:453)

at 

[gjeremy1617088143]

Hi @Not defined Not defined​ , wich version of JDBC driver are you using ?

Send me love and kudos

[Gagan1]

Thanks For response ..!!

In system : Oracle folder

"MANIFEST.MF" file.

Manifest-Version: 1.0

Built-By: klrice

Created-By: Apache Maven 3.5.2

Build-Jdk: 1.8.0_102

--ojdbc7.jar

also I am using TOS version : 6.4

Please provide solution as i am still facing same error .

Thanks

[tornilleiro]

Hi @Not defined Not defined​ 

You are not specifing the DB 0Oracle version that you are trying to connect. Anyway I could suggest you two options

• Option 1: You could try using the ojdbc8.jar instead of the ojdbc7.jar.
• Option 2: You could try different DB versions using the combo box selector in the component (see screenshot below)

Regards

[Gagan1]

Thanks for response ..

I am still facing same issue even after download ojdbc8.jar however option above oracle 12 above is not available in version 6.4 .

Please suggest .

Thanks in advance .