ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Kulkarni <ashish.kulkarn...@gmail.com>
Subject Re: connection link failure issue
Date Fri, 24 Apr 2009 15:41:55 GMT
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.briggs@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-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