JBoss: Find failed org.jboss.util.NestedSQLException: Transaction is not active: - JDBC JAVA

This is a discussion on JBoss: Find failed org.jboss.util.NestedSQLException: Transaction is not active: - JDBC JAVA ; We have been Jboss 3.2.3 and Postgres 7.4.2 for sometime and have recently been going through an upgrade to Jboss 4.0.3SP1 and Postgres 8.1.2, using Postgres JDBC driver postgresql-8.1-404.jdbc3.jar. Under the old environment, we have a very solid deployment, with ...

+ Reply to Thread
Results 1 to 2 of 2

JBoss: Find failed org.jboss.util.NestedSQLException: Transaction is not active:

  1. Default JBoss: Find failed org.jboss.util.NestedSQLException: Transaction is not active:

    We have been Jboss 3.2.3 and Postgres 7.4.2 for sometime and have
    recently been going through an upgrade to Jboss 4.0.3SP1 and Postgres
    8.1.2, using Postgres JDBC driver postgresql-8.1-404.jdbc3.jar.

    Under the old environment, we have a very solid deployment, with no
    downtime (other than for regular updates to code) for about 1 year. We
    have just got through this upgrade and are now getting two or three
    very strange, and fatal errors.

    Below is an example of one of them - It is thrown from both CMP Entity
    Bean Finder methods as well as from DAO lookups, but it is not a
    consistent error, i.e. at some points the same code succeeds or fails
    withi this error, which makes me think that there is some wrong with
    the connection pool/driver/transactions settings for Jboss. So I
    wanting to get some help to know to where to being looking for the
    issue:

    [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.SystemMessage#findCurrentForUserByType]
    Find failed
    org.jboss.util.NestedSQLException: Transaction is not active:
    tx=TransactionImpl:XidImpl[FormatId=257,
    GlobalId=demo.scheduleexpress.com/9552, BranchQual=, localId=9552]; -
    nested throwable: (javax.resource.ResourceException: Transaction is not
    active: tx=TransactionImpl:XidImpl[FormatId=257,
    GlobalId=demo.scheduleexpress.com/9552, BranchQual=, localId=9552])
    at
    org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:79)
    at
    org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:210)
    at
    org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:128)
    at
    org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntitiesCommand.execute(JDBCFindEntitiesCommand.java:40)
    at
    org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntities(JDBCStoreManager.java:598)
    at
    org.jboss.ejb.plugins.CMPPersistenceManager.findEntities(CMPPersistenceManager.java:322)
    at
    org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntities(CachedConnectionInterceptor.java:245)
    at
    org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:649)

    I have no idea why this would occurr,

    We are running Jboss 4.0.3 SP1 and Postgres 8.1.2

  2. Default Re: JBoss: Find failed org.jboss.util.NestedSQLException: Transaction is not active:

    I also have this same problem using JBoss 4.2.2 GA.

    I've a client app that lookups a Stateless Session Bean which has defined BMT through @TransactionManagement with type BEAN.
    This session bean has only one public method which gets UserTransaction through session context and begins & commits the transaction.

    This method makes one access to the DB, another access through another session bean and in the tirdy access it raises the same exception:

    org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 7f000101:9dcd:4a8850db:31 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: 7f000101:9dcd:4a8850db:31 status: ActionStatus.ABORT_ONLY >)
    15:36:07,149 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
    15:36:07,149 ERROR [STDERR] at

    com.ibatis.sqlmap.engine.transaction.jta.JtaTransaction.init(JtaTransaction.java:68)


    I've been searching in many posts and have no answers, i appreciate if someone could give some idea to deal with this problem.

    Thanks,
    Denis
+ Reply to Thread
« Optimization | Hibernate Configuration: NoClassDefFoundError »

Similar Threads

  1. [JBOSS] Can't connect Client to remote JBoss 3.2.2 server
    By Application Development in forum Java
    Replies: 9
    Last Post: 04-22-2005, 06:21 AM
  2. Hibernate in JBoss: You cannot commit during a managed transaction!
    By Application Development in forum JDBC JAVA
    Replies: 1
    Last Post: 12-27-2004, 07:13 AM
  3. Hibernate in JBoss: You cannot commit during a managed transaction!
    By Application Development in forum JDBC JAVA
    Replies: 1
    Last Post: 12-17-2004, 02:54 PM
  4. JBOSS: TCP connect failed in tcp_connect()
    By Application Development in forum Java
    Replies: 2
    Last Post: 06-07-2004, 11:26 PM
  5. JBoss ignoring override of max-bean-age in jboss.xml
    By Application Development in forum Java
    Replies: 0
    Last Post: 12-15-2003, 05:02 AM