weblogic.transaction.RollbackException:Could not prepareresource oraclepool

[Sanjeev Srivastava]

Hi I am trying to read message asyncronously from the weblogic queue using MDB and trying to update database using CMP i am getting the following exception. I am using the following
Weblogic 8.1.3 service-pack 3 with oracle thin XA driver oracle.jdbc.xa.client.OracleXADataSource
oracle 9.0.2

at oracle.jdbc.xa.OracleXAResource.disallowLocalTxnMode(I)V(Optimized Me
thod)
at oracle.jdbc.xa.OracleXAResource.suspendStacked(Ljavax.transaction.xa.
Xid;)Ljavax.transaction.xa.Xid;(OracleXAResource.java:229)
at oracle.jdbc.xa.client.OracleXAResource.prepare(Ljavax.transaction.xa.
Xid;)I(OracleXAResource.java:540)
at weblogic.jdbc.wrapper.VendorXAResource.prepare(Ljavax.transaction.xa.
Xid;)I(VendorXAResource.java:70)
at weblogic.jdbc.jta.DataSource.prepare(Ljavax.transaction.xa.Xid;)I(Opt
imized Method)
at weblogic.transaction.internal.XAServerResourceInfo.prepare(Lweblogic.
transaction.internal.ServerTransactionImpl;Ljavax.transaction.xa.Xid;)I(Optimize
d Method)
at weblogic.transaction.internal.XAServerResourceInfo.prepare(Lweblogic.
transaction.internal.ServerTransactionImpl;)I(XAServerResourceInfo.java:411)
at weblogic.transaction.internal.ServerSCInfo$1.execute(Lweblogic.kernel
ExecuteThread;)V(ServerSCInfo.java:253)
at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest
;)V(Optimized Method)
at weblogic.kernel.Kernel.executeIfIdle(Lweblogic.kernel.ExecuteRequest;
I)V(Kernel.java:378)
at weblogic.transaction.internal.ServerSCInfo.startPrepare(Lweblogic.tra
nsaction.internal.ServerTransactionImpl;)V(ServerSCInfo.java:244)
at weblogic.transaction.internal.ServerTransactionImpl.globalPrepare()V(
Optimized Method)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit()V
(Optimized Method)
at weblogic.transaction.internal.ServerTransactionImpl.commit()V(Optimiz
ed Method)
at weblogic.ejb20.internal.MDListener.execute(Lweblogic.kernel.ExecuteTh
read;)V(Optimized Method)
at weblogic.ejb20.internal.MDListener.onMessage(Ljavax.jms.Message;)V(Op
timized Method)
at weblogic.jms.client.JMSSession.onMessage(Ljavax.jms.MessageListener;L
weblogic.jms.common.MessageImpl;)V(Optimized Method)
at weblogic.jms.client.JMSSession.execute(Lweblogic.kernel.ExecuteThread
;)V(Optimized Method)
at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest
;)V(Optimized Method)
at weblogic.kernel.ExecuteThread.run()V(ExecuteThread.java:178)
at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Sourc
e)
--------------- nested within: ------------------
weblogic.transaction.RollbackException: Could not prepare resource 'nsppool - wi
th nested exception:
[javax.transaction.xa.XAException]
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(
)V(TransactionImpl.java:1644)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit()V
(Optimized Method)
at weblogic.transaction.internal.ServerTransactionImpl.commit()V(Optimiz
ed Method)
at weblogic.ejb20.internal.MDListener.execute(Lweblogic.kernel.ExecuteTh
read;)V(Optimized Method)
at weblogic.ejb20.internal.MDListener.onMessage(Ljavax.jms.Message;)V(Op
timized Method)
at weblogic.jms.client.JMSSession.onMessage(Ljavax.jms.MessageListener;L
weblogic.jms.common.MessageImpl;)V(Optimized Method)
at weblogic.jms.client.JMSSession.execute(Lweblogic.kernel.ExecuteThread
;)V(Optimized Method)
at weblogic.kernel.ExecuteThread.execute(Lweblogic.kernel.ExecuteRequest
;)V(Optimized Method)
at weblogic.kernel.ExecuteThread.run()V(ExecuteThread.java:178)
at java.lang.Thread.startThreadFromVM(Ljava.lang.Thread;)V(Unknown Sourc
e)

[pradeep tiwari]

HI,
If you are using a single database for transaction don't use XA thin driver because itis used in distribted transaction.So if you are using transaction in single database use the oracle thin driver(non XA).
Pradeep

[Sanjeev Srivastava]

Hi
Thanks for your answer but using oracle thin non-XA driver during single database transcation doesnt help as when we use non-XA driver in our application having MDB ->SESSION BEAN-> and CMP starts throwing excetion .

*************************************************************************
<Oct 8, 2004 1:44:42 PM IST> <Error> <EJB> <BEA-010026> <Exception occurred duri
ng commit of transaction Xid=BEA1-00C42986A05F3F2B21D0(32944130),Status=Rolled b
ack. [Reason=javax.transaction.xa.XAException: JDBC driver does not support XA,
hence cannot be a participant in two-phase commit. To force this participation,
set the EnableTwoPhaseCommit property on the corresponding JDBCTxDataSource prop
erty, to true. Pool = proAlarmpool, TxDataSource = nspdatasource],numRepliesOwed
Me=0,numRepliesOwedOthers=0,seconds since begin=0,seconds left=30,XAServerResour
ceInfo[JMS_proAlarmJMSServer_NotDurable]=(ServerResourceInfo[JMS_proAlarmJMSServ
er_NotDurable]=(state=rolledback,assigned=nsp),xar=JMS_proAlarmJMSServer_NotDura
ble),XAServerResourceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(ServerResour
ceInfo[weblogic.jdbc.wrapper.JTSXAResourceImpl]=(state=rolledback,assigned=nsp),
xar=weblogic.jdbc.wrapper.JTSXAResourceImpl@9d7837),SCInfo[steleus+nsp]=(state=r
olledback),properties=({weblogic.jdbc=t3://192.9.203.83:7001}),local properties=
({modifiedListeners=[]}),OwnerTransactionManager=ServerTM[ServerCoordinatorDescr
iptor=(CoordinatorURL=nsp+192.9.203.83:7001+steleus+t3+, XAResources={weblogic.j
dbc.wrapper.JTSXAResourceImpl, JMS_proAlarmJMSServer_NotDurable},NonXAResources=
{})],CoordinatorURL=nsp+192.9.203.83:7001+steleus+t3+): javax.transaction.xa.XAE
xception: JDBC driver does not support XA, hence cannot be a participant in two-
phase commit. To force this participation, set the EnableTwoPhaseCommit property
on the corresponding JDBCTxDataSource property, to true. Pool = proAlarmpool, T
xDataSource = nspdatasource
at weblogic.jdbc.wrapper.JTSXAResourceImpl.prepare(JTSXAResourceImpl.jav
a:87)
at weblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerRe
sourceInfo.java:1167)
at weblogic.transaction.internal.XAServerResourceInfo.prepare(XAServerRe
sourceInfo.java:401)
at weblogic.transaction.internal.ServerSCInfo$1.execute(ServerSCInfo.jav
a:253)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
--------------- nested within: ------------------
weblogic.transaction.RollbackException: Could not prepare resource 'weblogic.jdb
c.wrapper.JTSXAResourceImpl
JDBC driver does not support XA, hence cannot be a participant in two-phase comm
it. To force this participation, set the EnableTwoPhaseCommit property on the co
rresponding JDBCTxDataSource property, to true. Pool = proAlarmpool, TxDataSourc
e = nspdatasource - with nested exception:
[javax.transaction.xa.XAException: JDBC driver does not support XA, hence cannot
be a participant in two-phase commit. To force this participation, set the Enab
leTwoPhaseCommit property on the corresponding JDBCTxDataSource property, to tru
e. Pool = proAlarmpool, TxDataSource = nspdatasource]
at weblogic.transaction.internal.TransactionImpl.throwRollbackException(
TransactionImpl.java:1644)
at weblogic.transaction.internal.ServerTransactionImpl.internalCommit(Se
rverTransactionImpl.java:300)
at weblogic.transaction.internal.ServerTransactionImpl.commit(ServerTran
sactionImpl.java:221)
at weblogic.ejb20.internal.MDListener.execute(MDListener.java:412)
at weblogic.ejb20.internal.MDListener.transactionalOnMessage(MDListener.
java:316)
at weblogic.ejb20.internal.MDListener.onMessage(MDListener.java:281)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:2596)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:2516)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:197)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:170)
>