0 Replies Latest reply on Nov 28, 2001 6:00 AM by konrad.kaminski

    Rollback on connection close when done without a transaction

    konrad.kaminski

      Hi!

      I was wondering if this is the right behaviour. During the invocation of a connection close () method when there is no transaction associated the org.jboss.pool.jdbc.xa.XAConnectionFactory in a listener calls a rollback () on the connection. But since the connection is not by default in auto-commit mode (this is done in org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl in getXAConnection () method) everything that has been done from acquiring the connection from datasource till the end (the calling of close () method) is being rolled back. This has an affect i.e. on an EJB method with CMT and transaction attribute set to NEVER.

      I'm using JBoss 2.4.3 with datasources defined via rg.jboss.jdbc.XADataSourceLoader MBean.