HiThere is no SQL error code in log file, and this is all in intranet so there is no firewall in between. i believe this happens for first transaction in a day, when no one has used the application for about 10 hours and starting to use it again
On Fri, Apr 24, 2009 at 10:42 AM, Mario Ds Briggs <mario.bri...@in.ibm.com>wrote: > What's SQL ERROR CODE in the exception. You want to look it up the DB2 on > AS400 docs > > > > > Ashish Kulkarni > <ashish.kulkarni1 > 3...@gmail.com> To > user-java@ibatis.apache.org > 24/04/2009 19:39 cc > > Subject > Please respond to connection link failure issue > user-j...@ibatis. > apache.org > > > > > > > > > Hi > I 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) > >
