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

[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 (JOB_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​ ,

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]

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:

http://www.dba-oracle.com/t_no_more_data_to_read_from_socket.htm 

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

Best regards

Sabrina