topic [resolved] No more data to read from socket - TOS 5.3.1 - Oracle in Talend Studio

[resolved] No more data to read from socket - TOS 5.3.1 - Oracle

_AnonymousUser — Tue, 21 Oct 2014 09:11:47 GMT

Hi,
I've got some trouble with a job using a ToracleInput (TOS 5.3.1, On AIX using an oracle 11.2 database).
An error is throw at the first query:

Exception in component tOracleInput_1
java.sql.SQLException: No more data to read from socket
This job have been use on several other server (With same configuration a first view), without any trouble.
Does someone know where to investigate to solve this trouble (Just a clue, please ) ?
thanks a lot

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Anonymous — Tue, 21 Oct 2014 09:25:07 GMT

Hi,
This issue is probably caused by oracle server.
Please see this article: http://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error
Best regards
Sabrina

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

_AnonymousUser — Wed, 22 Oct 2014 10:28:23 GMT

Thanks a lot !
Our oracle team solve the trouble : it was due to some error of configuration on the listener of the database.
Good day.

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Anonymous — Wed, 22 Oct 2014 10:37:33 GMT

Hi ntotor314,

Glad you could solve the issue. Could you please click the "Set this topic as resolved" link which is right underneath your initial post? This way, other users will be informed that this thread has been resolved.

Best regards
Sabrina

Re: [resolved] No more data to read from socket - TOS 5.3.1 - Oracle

Anonymous — Tue, 12 Nov 2019 17:10:01 GMT

Hi,

Could you specify what exact error of configuration on the listener of the database?

Thank you!