Is there a firewall between the application server and the database server?
On Fri, Apr 24, 2009 at 9:09 AM, Ashish Kulkarni < ashish.kulkarn...@gmail.com> wrote: > HiI am having some issue with connection dropping, i am using > ibatis ibatis-2.3.4.726.jar and creating connection to AS400 using JDBC, > but i am seeing these errors in log file, for some reason connection is > getting dropped, what may be the reason, the issue is this a high > availability system and we cannot let any single transaction fell because of > this issue, when we try second time the transaction works, so what should i > do, > > java.sql.SQLException: Communication link failure. (Connection reset) > at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528) > at > com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2668) > at > com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2581) > at > com.ibm.as400.access.JDTransactionManager.rollback(JDTransactionManager.java:440) > at > com.ibm.as400.access.AS400JDBCConnection.rollback(AS400JDBCConnection.java:2252) > at > com.ibatis.common.jdbc.SimpleDataSource.popConnection(SimpleDataSource.java:629) > at > com.ibatis.common.jdbc.SimpleDataSource.getConnection(SimpleDataSource.java:222) > at > com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.init(JdbcTransaction.java:48) > at > com.ibatis.sqlmap.engine.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:89) > at > com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567) > at > com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541) > at > com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118) > at > com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.queryForList(SqlMapClientImpl.java:94) > -- -- Chris O'Connell Application Developer Gorilla 312.243.8777 x19
