[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - problems with jdbc / datasource

[seahawk@volny.cz]

Hi, 

I'm trying to do some tests here - and I'm facing the following problem:

Scenario:
I do several db calls through normal JDBC - simply - each time I: 
1) open connection
2) prepare statement 
3) execute it
4) parse output
5) close connection 

this is done from stateful session bean using JDBC calling stored procedures. 

this I do 4x100.000 times but after 4x12000 times the process terminates with following exception:

1:12:04,100 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_58] - Abort of action id a00051a:369b:47971163:31 invoked while multiple threads active within it.
11:12:04,100 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.CheckedAction_2] - CheckedAction::check - atomic action a00051a:369b:47971163:31 aborting with 1 threads active!
11:12:04,131 INFO [STDOUT] Unable to get user: Transaction is not active: tx=TransactionImple < ac, BasicAction: a00051a:369b:47971163:31 status: ActionStatus.ABORTING >; - nested throwable: (javax.resou
ce.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a00051a:369b:47971163:31 status: ActionStatus.ABORTING >)
11:12:04,131 INFO [STDOUT] Unable to update user: Transaction is not active: tx=TransactionImple < ac, BasicAction: a00051a:369b:47971163:31 status: ActionStatus.ABORTED >; - nested throwable: (javax.res
urce.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a00051a:369b:47971163:31 status: ActionStatus.ABORTED >)

I'll be grateful for any advice.

Thanks 
Y


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4122549#4122549

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4122549