topic Re: No more data to read from socket Error in Exception in component tOracleInput component in Talend Studio

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

Gagan1 — Fri, 03 Sep 2021 07:26:59 GMT

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)

gjeremy1617088143 — Tue, 07 Sep 2021 09:44:34 GMT

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

Send me love and kudos

Gagan1 — Fri, 10 Sep 2021 03:17:15 GMT

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 — Fri, 10 Sep 2021 20:19:44 GMT

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 — Tue, 14 Sep 2021 14:48:01 GMT

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 .