Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-3904

Part of JBM TS fails on Oracle 11g R1 and JDBC driver version 11.1.0.7.0

    XMLWordPrintable

Details

    • Release Notes
    • Hide

      Use Oracle JDBC driver (11.2.0.1.0)

      Show
      Use Oracle JDBC driver (11.2.0.1.0)
    • Not Required
    • ON_QA

    Description

      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)

      Attachments

        Activity

          People

            mnovak1@redhat.com Miroslav Novak
            pslavice@redhat.com Pavel Slavicek
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: