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)
