0 Replies Latest reply on Jan 23, 2008 5:21 AM by Yan Falken

    problems with jdbc / datasource

    Yan Falken Newbie

      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