TransactionRolledbackLocalException

Discussions

EJB programming & troubleshooting: TransactionRolledbackLocalException

  1. TransactionRolledbackLocalException (1 messages)

    Hi,

    from EJB A in application x I call a method in EJB V in application Y.
    The application use different databases in the same Cloudscape server.
    Both beans have container managed transaction.
    I'm getting the following exception:

    javax.ejb.TransactionRolledbackLocalException: Exception thrown from bean;
    nested exception is: javax.ejb.EJBException: nested exception is:
    java.sql.SQLException: java.lang.IllegalStateException: Local transaction
    already ha
    javax.ejb.EJBException: nested exception is: java.sql.SQLException:
    java.lang.IllegalStateException: Local transaction already has 1 non-XA
    Resource: cannot add more resources
    java.sql.SQLException: java.lang.IllegalStateException: Local transaction
    already has 1 non-XA Resource: cannot add more resources

    If I set the trans attribute of the calling method to 'Never' it works fine but
    then I do not have transactions any more. Does cloudscape only allow on
    transaction running? What's the problem here?

    TIA
    Frank
  2. TransactionRolledbackLocalException[ Go to top ]

    Are you using two different connection caches to connect to the two different databases?

    Dave Wolf
    The Scupper Group
    dave at scuppergroup dot com