Message Persistence Error

[aq12ws]

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)))

[aq12ws]

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

[genman]

Oracle driver issue? Thin/OCI?

[aq12ws]

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.