Part of JBoss Messaging TS fails on Oracle 11g R1 with JDBC driver version 11.1.0.7.0. TS receives SQL Exception ,,Bigger type length than Maximum". This is probably caused by issue in JDBC driver which should be fixed in JDBC drivers version 10.2.x.x.x but it seems that JDBC driver version 11.1.0.7.0 contains this issue again.

The Oracle JDBC driver (11.2.0.1.0) solves this issue.

04:43:13,562 DEBUG @Finalizer [ServerInvoker] SocketServerInvoker[10.16.88.154:1719348729] stopped
04:43:13,562 DEBUG @main [logger] BaseTransaction.setRollbackOnly
04:43:13,563 DEBUG @main [logger] TransactionImple.setRollbackOnly
04:43:13,563 DEBUG @Finalizer [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_8] - BasicAction::removeChildThread () action a10589a:e2a1:4b9a0ca7:f5 removing TSThread:2
04:43:13,563 DEBUG @main [arjLogger] BasicAction::preventCommit( BasicAction: a10589a:e2a1:4b9a0ca7:14f status: ActionStatus.RUNNING)
04:43:13,563 DEBUG @Finalizer [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_9] - BasicAction::removeChildThread () action a10589a:e2a1:4b9a0ca7:f5 removing TSThread:2 result = true
04:43:13,563 DEBUG @main [logger] BaseTransaction.getStatus
04:43:13,563 DEBUG @Finalizer [arjLogger] BasicAction::finalize()
04:43:13,563 DEBUG @main [logger] TransactionImple.getStatus
04:43:13,563 TRACE @main [JDBCSupport] Rolling back tx
04:43:13,563 DEBUG @Finalizer [arjLogger] StateManager.finalize() for object-id a10589a:e2a1:4b9a0ca7:fa type /StateManager/AbstractRecord/XAResourceRecord
04:43:13,563 DEBUG @main [logger] BaseTransaction.rollback
04:43:13,564 DEBUG @main [logger] TransactionImple.rollbackAndDisassociate
04:43:13,564 DEBUG @main [arjLogger] BasicAction::Abort() for action-id a10589a:e2a1:4b9a0ca7:14f
04:43:13,564 DEBUG @main [arjLogger] BasicAction::doAbort (com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord@5fb7565)
04:43:13,564 DEBUG @Finalizer [ServerInvoker] SocketServerInvoker[10.16.88.154:1721269818] stopped
04:43:13,564 DEBUG @main [logger] XAResourceRecord.topLevelAbort for < 131075, 49, 25, 97494853565797581015097495852985797489997555849459749485356579758101509749585298579748999755584952102974948535657975810150974958529857974899975558495350 >
04:43:13,564 DEBUG @Finalizer [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_8] - BasicAction::removeChildThread () action a10589a:e2a1:4b9a0ca7:fb removing TSThread:2
04:43:13,564 DEBUG @Finalizer [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_9] - BasicAction::removeChildThread () action a10589a:e2a1:4b9a0ca7:fb removing TSThread:2 result = true
04:43:13,565 DEBUG @Finalizer [arjLogger] BasicAction::finalize()
04:43:13,565 DEBUG @Finalizer [arjLogger] StateManager.finalize() for object-id a10589a:e2a1:4b9a0ca7:100 type /StateManager/AbstractRecord/XAResourceRecord
04:43:13,565 DEBUG @Finalizer [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_8] - BasicAction::removeChildThread () action a10589a:e2a1:4b9a0ca7:101 removing TSThread:2
04:43:13,565 DEBUG @main [logger] SynchronizationImple.afterCompletion
04:43:13,565 DEBUG @Finalizer [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_9] - BasicAction::removeChildThread () action a10589a:e2a1:4b9a0ca7:101 removing TSThread:2 result = true
04:43:13,565 DEBUG @main [logger] SynchronizationImple.afterCompletion
04:43:13,565 DEBUG @Finalizer [arjLogger] BasicAction::finalize()
04:43:13,566 DEBUG @main [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_8] - BasicAction::removeChildThread () action a10589a:e2a1:4b9a0ca7:14f removing TSThread:1
04:43:13,566 DEBUG @Finalizer [arjLogger] StateManager.finalize() for object-id a10589a:e2a1:4b9a0ca7:106 type /StateManager/AbstractRecord/XAResourceRecord
04:43:13,566 DEBUG @main [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_9] - BasicAction::removeChildThread () action a10589a:e2a1:4b9a0ca7:14f removing TSThread:1 result = true
04:43:13,566 DEBUG @main [arjLogger] TransactionReaper::create ( 120000 )
04:43:13,566 DEBUG @main [arjLogger] TransactionReaper::remove ( BasicAction: a10589a:e2a1:4b9a0ca7:14f status: ActionStatus.ABORTED )
04:43:13,566 DEBUG @Finalizer [ServerInvoker] SocketServerInvoker[10.16.88.154:1722076107] stopped
04:43:13,566 ERROR @main [ExceptionUtil] Topic[null, name=TopicToBeRedeployed] startService
java.sql.SQLException: Bigger type length than Maximum
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:445)
at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2253)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1101)
at oracle.jdbc.driver.T4C8TTIrxh.unmarshalV10(T4C8TTIrxh.java:115)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:654)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at org.jboss.messaging.core.impl.JDBCPersistenceManager.loadFromStart(JDBCPersistenceManager.java:991)
at org.jboss.messaging.core.impl.PagingChannelSupport.load(PagingChannelSupport.java:211)