4 Replies Latest reply on Jun 29, 2012 4:17 AM by muza71

Question about JDBC connections across transaction boundaries

markus78 Feb 15, 2012 1:29 PM

Hi,

I have an cituation where a bean ("outer transaction") invokes on another bean which has "requiresnew" set thus I get a new transaction "inside" my current one, this works fine on our old WebSphere appserver but I'm running into problems trying to migrate this to JBoss AS 7

I get the following WARN and after that my JDBC (xa-datasource) connection pool starts to starve itself and using up connections without releasing them.

13:20:48,062 WARN [org.jboss.tm.usertx.UserTransactionRegistry] (http-executor-threads - 13)

Error notifying listener

org.jboss.jca.core.tx.jbossts.UserTransactionListenerImpl@19302fb of userTransactionStarted:

java.lang.IllegalStateException: Trying to change transaction TransactionImple < ac, BasicAction: 0:ffff82ef5b1d:6868fe66:4f3b9daa:1488

status: ActionStatus.RUNNING > in enlist!

at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:218)

Googling the problem I find some old posts that claim that JBoss does not support keeping jdbc connections open across transaction boundaries, is this the case? Do I need to modify my code and make sure that I close my connections before

invoking on the "requiresnew" bean?

We are also using Spring...

/Markus

1. Re: Question about JDBC connections across transaction boundaries

jesper.pedersen Feb 16, 2012 8:37 AM (in response to markus78)

Are you using AS 7.1.0.Final ?
Actions
2. Re: Question about JDBC connections across transaction boundaries

markus78 Feb 16, 2012 8:39 AM (in response to jesper.pedersen)

Yes I am, I have currently resolved the issue by using a "org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy" Bean with reobtainTransactionalConnections set to true in my spring configuration.
Actions
3. Re: Question about JDBC connections across transaction boundaries

bjorn.palmqvist Apr 11, 2012 11:05 AM (in response to markus78)

I having the same problem, when having an aspect transaction running and creating new transactions with requiersnew.

I got the same WARN message in the log as markus.

It's only show up in some of our larger tests, and we fail to recreate it in a small isolated test.

We are trying to understand why we seeing this and how to recreate so that we later on can avoid it.

The TransactionAwareDataSourceProxy fix works for this, but we don't want to us that if there is a another way of doing this.

And btw, we are using JBoss 7.1.1 at moment.

/Björn
Actions
4. Re: Question about JDBC connections across transaction boundaries

muza71 Jun 29, 2012 4:17 AM (in response to bjorn.palmqvist)

Hi Björn,
did you find a solution for you're problem ? We've the same problem and the same exception (JBoss 7.1.1.Final). We don't want to use Spring...

Jürgen
Actions

Go to original post