This content has been marked as final.
Show 3 replies
-
1. Re: How to Declaratively set autoCommit to false
adrian.brock Apr 22, 2004 7:44 AM (in response to ritukedia)1 of 1 people found this helpfulThere is no current way to do this.
JBoss assumes auto commit is true when the connection is first created,
as per spec.
Maybe you could provide a patch, with code similar to the transaction isolation
override? -
2. Re: How to Declaratively set autoCommit to false
joergvf Feb 23, 2006 3:55 PM (in response to ritukedia)"adrian@jboss.org" wrote:
I searched the JCA and J2EE specs for this, but couldn't find anything backing this assumption. Do you per chance have some concrete reference for this?
JBoss assumes auto commit is true when the connection is first created,
as per spec.
Thanks,
Jörg -
3. Re: How to Declaratively set autoCommit to false
starksm64 Feb 24, 2006 2:13 AM (in response to ritukedia)
15.5.3.1 Auto Commit
When a Connection is in an auto-commit mode, an Interaction, associated with the Connection, automatically commits after it has been executed. The auto-commit mode must be turned off if multiple interactions have to be grouped in a single transaction and committed or rolled back as a unit.
CCI does not provide explicit set/getAutoCommit methods in the Connection interface. This simplifies the application programming model for the transaction management.
A resource adapter must manage the auto-commit mode as follows:
A transactional resource adapter either at the XATransaction or
LocalTransaction level must set the auto-commit mode of Connection
instances participating in a transaction to off within the transaction. This
requirement holds for true both container-managed and bean-managed
transaction demarcation.
A transactional resource adapter must set the auto-commit mode of Connection instances to on when used outside a transaction.
These requirements are independent of whether a transaction is managed as a local or XA transaction. A transactional resource adapter should implement this requirement in an implementation-specific manner.
A non-transactional resource adapter at the NoTransaction level, is not required to support the auto-commit mode for Connection.