topic Re: Exception in component tOracleInputtOracleInput when i define cursor size however without cursor size , no error in Talend Studio

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

Gagan1 — Fri, 15 Nov 2024 23:42:28 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 (JOB_PROD)

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

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

gjeremy1617088143 — Fri, 24 Sep 2021 07:40:55 GMT

Hi @Not defined Not defined ,

this article is a little bit old but maybe it can help you :

https://community.talend.com/s/question/0D53p00007vCkX0CAK/no-more-data-to-read-from-socket

Send me love and kudos

Anonymous — Sun, 26 Sep 2021 07:22:02 GMT

Hello,

The "no more data from socket" error is sometimes caused by a bug and it is related to the client software (JDBC driver) and not a database problem.

Please try to download the the latest oracle jdbc driver.

In the studio, import the new jar file by Talend Modules view (open Window->show view->Talend/Modules) and restart your studio.

Here is the related reference:

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina