https://community.qlik.com/t5/Talend-Studio/java-sql-SQLRecoverableException-Io-exception-Connection-reset/m-p/2269872#M47965 No one replay? I gave more detail information. <BR />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? <BR />someone post this solution: <BR />-------------------------------------- <BR />Users upgrading to 11g can encounter this issue if the underlying OS is Linux which is running on a faulty hardware. <BR />Cause <BR />The cause of this has not yet been determined exactly. It could either be a problem in <BR />your hardware or the fact <BR />that for some reason the software cannot read from dev/random <BR />Solution <BR />Change the setup for your application, so you add the next parameter to the java command: <BR />-Djava.security.egd=file:/dev/../dev/urandom <BR /> <A href="http://kr.forums.oracle.com/forums/thread.jspa?messageID=3699989" rel="nofollow noopener noreferrer">http://kr.forums.oracle.com/forums/thread.jspa?messageID=3699989</A> <BR />I tried it, doesn't help. <BR />We made this change in our java.security file and it has gotten rid of the error. <BR />----------------------------------------------------- <BR />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! Tue, 03 May 2011 22:39:58 GMT _AnonymousUser 2011-05-03T22:39:58Z https://community.qlik.com/t5/Talend-Studio/java-sql-SQLRecoverableException-Io-exception-Connection-reset/m-p/2269871#M47964 Hi, <BR />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: <BR />Exception in component tOracleInput_6 <BR />java.sql.SQLRecoverableException: Io exception: Connection reset <BR /> at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.ja <BR />va:101) <BR /> at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:1 <BR />33) <BR /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java <BR />:199) <BR /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java <BR />:263) <BR /> at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java <BR />:521) <BR /> at oracle.jdbc.driver.T4CStatement.fetch(T4CStatement.java:1013) <BR /> at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(Oracl <BR />eResultSetImpl.java:314) <BR /> at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java: <BR />228)..... <BR />Thanks! Sat, 16 Nov 2024 12:56:40 GMT https://community.qlik.com/t5/Talend-Studio/java-sql-SQLRecoverableException-Io-exception-Connection-reset/m-p/2269871#M47964 _AnonymousUser 2024-11-16T12:56:40Z https://community.qlik.com/t5/Talend-Studio/java-sql-SQLRecoverableException-Io-exception-Connection-reset/m-p/2269872#M47965 No one replay? I gave more detail information. <BR />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? <BR />someone post this solution: <BR />-------------------------------------- <BR />Users upgrading to 11g can encounter this issue if the underlying OS is Linux which is running on a faulty hardware. <BR />Cause <BR />The cause of this has not yet been determined exactly. It could either be a problem in <BR />your hardware or the fact <BR />that for some reason the software cannot read from dev/random <BR />Solution <BR />Change the setup for your application, so you add the next parameter to the java command: <BR />-Djava.security.egd=file:/dev/../dev/urandom <BR /> <A href="http://kr.forums.oracle.com/forums/thread.jspa?messageID=3699989" rel="nofollow noopener noreferrer">http://kr.forums.oracle.com/forums/thread.jspa?messageID=3699989</A> <BR />I tried it, doesn't help. <BR />We made this change in our java.security file and it has gotten rid of the error. <BR />----------------------------------------------------- <BR />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! Tue, 03 May 2011 22:39:58 GMT https://community.qlik.com/t5/Talend-Studio/java-sql-SQLRecoverableException-Io-exception-Connection-reset/m-p/2269872#M47965 _AnonymousUser 2011-05-03T22:39:58Z