hi,

i am getting the following error:- Internal.XA.Error. we are running our application on web sphere and our database is oracle 9i.

thanks

paul

error message
-----------------
from resource jdbc/pooled was used within a local transaction containment boundary.
[9/18/03 13:10:04:545 IST] 42bae0fc LocalTransact E WLTC0033E: Resource jdbc/pooled rolled back in cleanup of unresolved LocalTransactionContainment.
[9/18/03 13:10:04:545 IST] 42bae0fc LocalTransact E WLTC0033E: Resource jdbc/pooled rolled back in cleanup of unresolved LocalTransactionContainment.
[9/18/03 13:10:04:545 IST] 42bae0fc LocalTransact E WLTC0032E: One or more resources rolled back. An unresolved LocalTransactionContainment had an unresolved action of rollback.
[9/18/03 13:10:04:561 IST] 42bae0fc WebAppTransac E SRVE0183E: LocalTransaction rolled-back due to setRollbackOnly
[9/18/03 13:10:04:561 IST] 42bae0fc WebGroup E SRVE0026E: [Servlet Error]-[LocalTransaction rolled-back due to setRollbackOnly]: com.ibm.ws.LocalTransaction.RolledbackException
at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java:967)
at com.ibm.ws.webcontainer.webapp.WebAppTransactionCollaborator.postInvoke(WebAppTransactionCollaborato r.java:208)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:673)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:176)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:79)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:201)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContex t.java:114)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:610)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:435)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)

[9/18/03 13:10:12:452 IST] 42bae0fc TraceNLS u No message text associated with key
The.XA.Error.is............:.-3
The.XA.Error.message.is....:.A.resource.manager.error.has.occured.in.the.transaction.branch.
The.Oracle.Error.code.is...:.65535
The.Oracle.Error.message.is:.Internal.XA.Error
in bundle IBMDataStoreAdapterNLS
[9/18/03 13:10:12:436 IST] 42bae0fc WSRdbXaResour I
The XA Error is : -3
The XA Error message is : A resource manager error has occured in the transaction branch.
The Oracle Error code is : 65535
The Oracle Error message is: Internal XA Error

[9/18/03 13:10:12:452 IST] 42bae0fc WSRdbXaResour W DSRA0302E: XAException occurred. Error code is: XAER_RMERR. Exception is:
[9/18/03 13:10:14:796 IST] 42bae0fc SharedPool I J2CA0086W: Shareable connection MCWrapper id 6bac60f8 Managed connection com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl@6d3260f8 State:STATE_TRAN_WRAPPER_INUSE
from resource jdbc/pooled was used within a local transaction containment boundary.
----------------------------------------------------------------------