In my application I an using Session EJB layer where the attribute is set to "Required".then from inside that method I am updating 3 database instances.
I have weblogic 8.1 in place so my database configurations are as follows :
1st Database connected Via a simple thin driver + Emulate 2 phase commit protocol checked
2nd is using a XADriver with Emulate 2 phase commit protocol unchecked
3rd is using a XADriver with Emulate 2 phase commit protocol unchecked
now when ever I an calling that EJB method its thowing one exception : java.sql.XADriverException.
What I want to know is that in a sigle transaction if I am operating on more that one databse then how many of them should be simple thin derver and how many of them should be XADrivers ?
Thanks and Regards