No more data to read from socket

No more data to read from socket

Hi,
I developed a job that reads one table from one Oracle server and writes to other table in another Oracle server. The table has more than one milion records.
The job wors well if I run it with for instance only 100 records, but when I force to use the complete table, i.e. more than one milion records, it crash with the error:
No more data to read from socket
Exception in component tOracleOutput_1
java.sql.SQLRecoverableException: No more data to read from socket
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:101)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1053)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1010)
at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:97)
at oracle.jdbc.driver.T4CConnection.doCommit(T4CConnection.java:539)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3432)
at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:3438)
at ssn_dw.tables_5_with_facts_0_1.Tables_5_with_Facts.tOracleInput_1Process(Tables_5_with_Facts.java:2131)
at ssn_dw.tables_5_with_facts_0_1.Tables_5_with_Facts.runJobInTOS(Tables_5_with_Facts.java:2364)
at ssn_dw.tables_5_with_facts_0_1.Tables_5_with_Facts.main(Tables_5_with_Facts.java:2262)
Any ideas, or is this a known talend error?
Sérgio Fernandes

Re: No more data to read from socket

This is an Oracle 10g bug. to verify, execute your query in a database client (toad, SQL Developer) and observe the same error.

Re: No more data to read from socket

Hi John,
Actually I have 11g.
I try to run the query using dblink and insert into clause and works fine.
Any ideas?
Best regards
Sérgio Fernandes
Seventeen Stars

Re: No more data to read from socket

hi all,
here some solution find on the web about similar problems :
Change the setup for your application, so you add the next parameter to the java command:
-Djava.security.egd=file:///dev/urandom

or set it in System properties :
System.setProperty("java.security.egd", "file:///dev/urandom");

... before connection (use Talend component for that)
Here 2 posts talking about that :
forums.oracle.com
Usn?s IT Blog
hope it help
regards
laurent