Posted on 2004-11-28
I can't describe situation for now.( because I don't know the system very well.)
For short, in Weblogic,
if i use datasource in the pool with oracle.jdbc.driver.OracleDriver, it works well.
if i use datasource in the pool with oracle.jdbc.xa.client.OracleXADataSource, it complains as follows;
SQL operations are not allowed with no global transaction by default for XA drivers. If the XA driver
supports performing SQL operations with no global transaction, explicitly allow
it by setting "SupportsLocalTransaction" JDBC connection pool property to true.
In this case, also remember to complete the local transaction before using the connection
again for global transaction, else a XAER_OUTSIDE XAException may result.
To complete a local transaction, you can either set auto commit to true or call Connection.commit() or Connection.rollback().
Give the above, I know the answer is hard to given.
What is the checkpoint I have to check?