3 Replies Latest reply on Jun 7, 2006 12:34 AM by alok jain

    Message Persistence Error

    alok jain Newbie

      Hi,
      I am getting the following error , when JBoss is trying to persist the JMS Message . I am using oracle for persistance . Basically I am getting one Warning and two errors . I am posting all three .

      14:51:50,937 WARN [JBossManagedConnectionPool] Exception destroying ManagedConnection org.jboss.resource.connectionmana
      ger.TxConnectionManager$TxConnectionEventListener@270fc4[state=DESTROYED mc=org.jboss.resource.adapter.jdbc.xa.XAManaged
      Connection@1fdb2 handles=0 lastUse=1148894510078 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.J
      BossManagedConnectionPool$OnePool@b6efb2 context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@329b
      cb]



      org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: Io exception: Conne
      ction reset by peer: socket write error)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.java
      :541)
      at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.destroy(XAManagedConnection.java:109)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool.ja
      va:539)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnection
      Pool.java:329)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.returnConnection(JBossManagedConnect
      ionPool.java:552)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2.ja
      va:407)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConnectionEventListener.connectionErrorOccurr
      ed(BaseConnectionManager2.java:768)
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionErrorOccurred(Tx
      ConnectionManager.java:550)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedConne
      ction.java:327)
      at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.broadcastConnectionError(XAManagedConnection.java:71)
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.connectionError(BaseWrapperManagedConnection.jav
      a:313)
      at org.jboss.resource.adapter.jdbc.WrappedConnection.checkException(WrappedConnection.java:757)
      at org.jboss.resource.adapter.jdbc.WrappedStatement.checkException(WrappedStatement.java:768)
      at org.jboss.resource.adapter.jdbc.WrappedStatement.internalClose(WrappedStatement.java:786)
      at org.jboss.resource.adapter.jdbc.WrappedStatement.close(WrappedStatement.java:52)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:847)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.add(PersistenceManager.java:787)
      at org.jboss.mq.server.PersistentQueue.addMessage(PersistentQueue.java:38)
      at org.jboss.mq.server.SelectorPersistentQueue.addMessage(SelectorPersistentQueue.java:69)
      at org.jboss.mq.server.JMSTopic.addMessage(JMSTopic.java:334)
      at org.jboss.mq.server.JMSDestinationManager.addMessage(JMSDestinationManager.java:414)
      at org.jboss.mq.server.JMSDestinationManager.transact(JMSDestinationManager.java:473)
      at org.jboss.mq.server.JMSServerInterceptorSupport.transact(JMSServerInterceptorSupport.java:186)
      at org.jboss.mq.security.ServerSecurityInterceptor.transact(ServerSecurityInterceptor.java:182)
      at org.jboss.mq.server.TracingInterceptor.transact(TracingInterceptor.java:438)



      14:51:51,453 WARN [TransactionImpl] XAException: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=stride/56, BranchQua
      l=, localId=56] errorCode=XAER_RMERR
      org.jboss.mq.SpyXAException: - nested throwable: (org.jboss.mq.SpyTransactionRolledBackException: Transaction was rolled
      back.; - nested throwable: (org.jboss.mq.SpyJMSException: Could not store message: 5 msg=0 hard NOT_STORED PERSISTENT q
      ueue=TOPIC.MPEventsTopic.DurableSubscription[clientId=ID:1 name=JMSEmailEventListener selector=event in ('RequisitionIte
      mCancelled','LoginNameAndPasswordAdded','DelegateAdded','DelegateDeleted','PurchaseOrderAccepted', 'PurchaseOrderCancell
      ed', 'PurchaseOrderItemCancelled','PurchaseOrderIssued','RequisitionCancelled','RequisitionRoutedToYouForApproval', 'Req
      uisitionApprovedAndPurchaseOrdersIssued','RequisitionRouted','RequisitionItemReceived','ItemShipped','PermissionGranted'
      ,'PermissionRevoked','ProductPriceAdded', 'ProductPriceDeleted','ProductAdded','ProductDeleted','RequisitionDeleted','Re
      quisitionItemDeleted','NewUserAddedToSystem', 'UserDeletedFromSystem','UserTypeChanged','CategoryAccessGranted','Categor
      yAccessRevoked','ServiceAccessGranted', 'ServiceAccessRevoked','RequisitionRejected','RequisitionItemRejected','LoginNam
      eOrPasswordChanged','RequisitionApprovalCodeChanged','RequisitionEmailNotificationFromWorkflow', 'RequestForQuotationPos
      ted','RequestForQuotationResponse','RequisitionItemAddedAfterSubmittal','TransactionFeeInvoiceIssued','MarketplaceFeeInv
      oiceIssued', 'DirectMarketplaceInvoiceIssued','IndirectMarketplaceInvoiceIssuedByMarketplaceAdministrator', 'IndirectMar
      ketplaceInvoiceIssuedBySupplier','DefaultCurrencyDeleted','CurrencyNoLongerValid','AuctionPermissionGranted','AuctionPer
      missionRevoked','AuctionLaunched','CXMLTransmissionFailure','CXMLStatusUpdateRequestFailure','CXMLOrderStatusDataRequest
      TransmissionFailure','ClientCancelledShippedError','RequisitionItemProcessedExternally','RequisitionItemProcessedExterna
      llyEmailRecipients','AccountLocked', 'AccountUnlocked','OrderDenyToBuyers','PurchaseOrderMail','AdminAccountLocked','Add
      ParallelApprover','AddParallelObserver','DeleteParallelApprover','DeleteParallelObserver','ParallelApproverAdded', 'Para
      llelApproverDelete','RequisitionExpedited','RequisitionExpediteDenied','OrderSubmittedByPreparer','ExpediteApprovedAndRo
      utedToSupplier','ExpediteDenied','BPORemainingAmountNotification', 'AlternateApprovedAndRoutedToNextApprover', 'Requisit
      ionAlternateApproved','BPOReleaseOrderSubmittal','BpoAwaitingApproval','BpoOrderDenied','BpoOrderApproved','BpoOrderDeny
      ToBuyers','BPOExpiryNotification', 'BpoAddParallelApprover','BpoAddParallelObserver','BpoDeleteParallelApprover','BpoDel
      eteParallelObserver','BpoParallelApproverAdded','BpoParallelApproverDelete','BPOLineRemainingAmountNotification', 'SomeI
      temsRejected','ShipNoticeItemShipped','CancelPurchaseOrderMail', 'PurchaseOrderCancelledByPreparer', 'PurchaseOrderCance
      lledBySupervisor', 'PurchaseOrderChangedByRequestor', 'PurchaseOrderChangedByPreparer', 'PurchaseOrderCancelledByApprove
      r', 'PurchaseOrderCancelledByRequestorToPrep','PurchaseOrderCancelledBySupervisorToPrep','ConfigUpdateFailed','SRUpdateF
      ailed','RequisitionStuckNotification','RequisitionRoutedToDApproverForApproval', 'NewSupplierAdded','TestPOEmail')] prio
      rity=4 lateClone=false hashCode=25995729; - nested throwable: (java.sql.SQLException: Io exception: Connection reset)))


        • 1. Re: Message Persistence Error
          alok jain Newbie

          I am using JBoss 4.0.1 sp1 and oracle 9i for persistence.

          • 2. Re: Message Persistence Error
            Elias Ross Master

            Oracle driver issue? Thin/OCI?

            • 3. Re: Message Persistence Error
              alok jain Newbie

              Hi ,
              Yeah I am using thin driver . I was using oracle thin driver for 9i . Now I have changed to 10g driver . I have checked the way JBoss writes a blob . It not the way oracle expects it to be :

              Oracle?s way to write a Blob through a JDBC code is a TWO Step procedure :
              Step 1) Insert a row into TABLE with LOB column values initialized to empty.
              Step 2) Retrieve the row just inserted and lock it for insertion of the LOB column. Open output stream for the Blob and then write to it.


              JBoss does not follow this two step procedure . It inserts in one shot .

              .

              Does using 10g driver solve this problem ?
              With the 9i dirver the JBoss was able to write a max of 4000 bytes . Now I am not sure with 10g driver what will be the limit .

              Thanks ,
              Alok.