Hi all,

I tried a test where I added an AS400Exception to as400 datasource as described in the oracle-ds.xml.

According to the feedback I was given this exception sorter is supposed to trap major errors , ie being disconnected from the as400, and allow jboss to reconnect again.

However it is not working. I get the same error as before the Exception sorter. Any ideas?

My exception sorter is very basic in that is just returned a boolean value from the isExceptionFatal method. Returning true or false did not help.

Here is part of my trace.

2003-05-30 18:31:09,681 ERROR [STDERR] java.sql.SQLException: Communication link failure.(Connection reset)
2003-05-30 18:31:09,681 ERROR [STDERR] at com.ibm.as400.access.JDError.throwSQLException(JDError.java:459)
2003-05-30 18:31:09,681 ERROR [STDERR] at com.ibm.as400.access.JDError.throwSQLException(JDError.java:417)
2003-05-30 18:31:09,681 ERROR [STDERR] at com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2497)
2003-05-30 18:31:09,681 ERROR [STDERR] at com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2410)
2003-05-30 18:31:09,681 ERROR [STDERR] at com.ibm.as400.access.JDTransactionManager.setCommitMode(JDTransactionManager.java:558)
2003-05-30 18:31:09,681 ERROR [STDERR] at com.ibm.as400.access.JDTransactionManager.setAutoCommit(JDTransactionManager.java:509)
2003-05-30 18:31:09,681 ERROR [STDERR] at com.ibm.as400.access.AS400JDBCConnection.setAutoCommit(AS400JDBCConnection.java:2543)
2003-05-30 18:31:09,681 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalManagedConnection.begin(LocalManagedConnection.java:147)
2003-05-30 18:31:09,681 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$LocalXAResource.start(TxConnectionManager.java:725)
2003-05-30 18:31:09,681 ERROR [STDERR] at org.jboss.tm.TransactionImpl.startResource(TransactionImpl.java:1137)
2003-05-30 18:31:09,697 ERROR [STDERR] at org.jboss.tm.TransactionImpl.enlistResource(TransactionImpl.java:624)
2003-05-30 18:31:09,697 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.enlist(TxConnectionManager.java:460)
2003-05-30 18:31:09,697 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionReconnected(TxConnectionManager.java:358)
2003-05-30 18:31:09,697 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:490)
2003-05-30 18:31:09,697 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:798)
2003-05-30 18:31:09,697 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:122)