java.sql.SQLRecoverableException: Io exception: Connection reset

One Star

java.sql.SQLRecoverableException: Io exception: Connection reset

Hi,
I have some jobs chain run very well for a couple of month. yesterday jobs failed due to this connection reset error. I have no idea why it is not working suddenly? anyone has any idea? this is error stack:
Exception in component tOracleInput_6
java.sql.SQLRecoverableException: Io exception: Connection reset
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja
va:101)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1
33)
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
:521)
at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1013)
at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(Oracl
eResultSetImpl.java:314)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:
228).....
Thanks!
One Star

Re: java.sql.SQLRecoverableException: Io exception: Connection reset

No one replay? I gave more detail information.
I googled some site, it might relate with jdbc connection. if open too many connections at short period, or open connection longer time, connection will be blocked by firewall. is that true?
someone post this solution:
--------------------------------------
Users upgrading to 11g can encounter this issue if the underlying OS is Linux which is running on a faulty hardware.
Cause
The cause of this has not yet been determined exactly. It could either be a problem in
your hardware or the fact
that for some reason the software cannot read from dev/random
Solution
Change the setup for your application, so you add the next parameter to the java command:
-Djava.security.egd=file:/dev/../dev/urandom
http://kr.forums.oracle.com/forums/thread.jspa?messageID=3699989
I tried it, doesn't help.
We made this change in our java.security file and it has gotten rid of the error.
-----------------------------------------------------
My jobs ran very well for a couple of months so far. I guess that growing data size probably cause this connection issue. anyone encounter this problems before? need help! Thanks!