I'm Using JDBC,WAS 5.0,Struts with Oracle 8i. Configured the datasource for OracleXADataSource, and given the JNDI name jdbc/dsOraXA. And set the AutoCommit to False in JDBC. For each transaction I'm explicitly giving commit() and rollback() statements.
Every thing works properly,but getting these error messages frequently in the Websphere log(SystemErr.log).
I'm getting the following error message frequently in the WAS log.
LocalTranCoor E WLTC0033E: Resource jdbc/dsOraXA rolled back in cleanup of unresolved LocalTransactionContainment
LocalTranCoor E WLTC0032E: One or more resources rolled back. An unresolved LocalTransactionContainment had an unresolved action of rollback.
WebAppTransac E WTRN0043I: LocalTransaction rolled-back due to setRollbackOnly.
This error usually happens because you have disabled autocommit (Maybe this is a default for the Oracle driver you use, I don't know), issued some queries, and closed your connection without issuing a commit.
Before closing a connection, either a rollback or commit must be issued. By default, JDBC will rollback everything that has not been committed on a close.
which is always preceeded by the following message:
ConnectionFac I J2CA0122I: Resource reference jdbc/dsOraXA could not be located, so default values of the following are used: [Resource-ref settings]