XA and Oracle with WebSphere

I've seen some customers having trouble with Oracle XA and WAS 5.0. The problem manifests when a WAS server restarts and then the recovery of any inflight transactions appears to fail.

The problem (assuming you're using the right versions of Oracle etc) is usually that the users used by the Oracle XA DataSources don't have the necessary permissions. You need to do the following for each Oracle user id that can be used by WebSphere:

grant select on DBA_PENDING_TRANSACTIONS to JOE

Then the JDBC driver at recovery time has the correct permissions to access the Oracle XA system tables with the information.

This isn't actually WebSphere specific, it applies to any JTA provider (other vendors app servers etc).

Comments

[wassim]

I'm using wsad5.0 with db2!I'm a biginner in this envirement!I'm developing a small transaction with 2 table master/detail!I generate the entity Bean of these tables!I build a session bean which refer to these entities!in the sessionbean i have method for inserting and searching master and detail!this is the remote:
public interface Depot_CreditSB extends EJBObject {

public Credit_fondsLocal getCredit(String numseq, String numdep) throws java.rmi.RemoteException,CreateException,DepotDoesNotExistException,CreditDoesNotExistException;

public Depot_fondsLocal getDepot(String numdep) throws java.rmi.RemoteException,CreateException,DepotDoesNotExistException,CreditDoesNotExistException;

public void setCredit(String numdep, String numseq, String nom, String numcpt) throws java.rmi.RemoteException,CreateException,DepotDoesNotExistException,CreditDoesNotExistException;

public void setDepot(String numdep, String Type_depot) throws java.rmi.RemoteException,CreateException,DepotDoesNotExistException,CreditDoesNotExistException;

I have an indication of Serialisable with the method who return an object!
the insert of master is success!not for the detail!
please can you help me for the first error!and tell me if I can precise the second error with the message of client server!