No more data to read from socket

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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