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).
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]