ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mario Ds Briggs <mario.bri...@in.ibm.com>
Subject Re: connection link failure issue
Date Fri, 24 Apr 2009 14:42:48 GMT
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-java@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)


Mime
View raw message