[jboss-user] [JBoss Seam] - Re: Transaction Exception with Seam and EJB3

[nloomis]

Thanks!  I took your advice and researched the forums and tried handling the transaction several different ways to see if I could find the error behind the error.  I see this one debug statement about 1000 times in my debugger.  It starts during the JBpm deploy and seems directly related to my problem.  Any help with this??

Here's where the message starts in my log...
-------------------------------------------------------------------------------

2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.AST] --- SQL AST ---
 \-[DELETE] DeleteStatement: 'delete'  querySpaces (JBPM_MESSAGE)
    +-[FROM] FromClause: 'FROM' FromClause{level=1, fromElementCounter=1, fromElements=1, fromElementByClassAlias=[m], fromElementByTableAlias=[message0_], fromElementsByPath=[], collectionJoinFromElementsByPath=[], impliedElements=[]}
    |  \-[FROM_FRAGMENT] FromElement: 'JBPM_MESSAGE' FromElement{explicit,not a collection join,not a fetch join,fetch non-lazy properties,classAlias=m,role=null,tableName=JBPM_MESSAGE,tableAlias=message0_,origin=null,colums={,className=org.jbpm.msg.Message}}
    \-[WHERE] SqlNode: 'where'
       \-[EQ] BinaryLogicOperatorNode: '='
          +-[DOT] DotNode: 'TOKEN_' {propertyName=token,dereferenceType=ROOT_LEVEL,propertyPath=token,path=m.token,tableAlias=message0_,className=org.jbpm.msg.Message,classAlias=m}
          |  +-[ALIAS_REF] IdentNode: 'ID_' {alias=m, className=org.jbpm.msg.Message, tableAlias=message0_}
          |  \-[IDENT] IdentNode: 'token' {originalText=token}
          \-[NAMED_PARAM] ParameterNode: '?' {name=token, expectedType=org.hibernate.type.ManyToOneType(org.jbpm.graph.exe.Token)}

2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2007-02-06 16:29:10,102 DEBUG [org.hibernate.hql.ast.ErrorCounter] throwQueryException() : no errors
2007-02-06 16:29:10,102 DEBUG [org.hibernate.impl.SessionFactoryImpl] Checking 0 named SQL queries
2007-02-06 16:29:10,102 DEBUG [org.jbpm.persistence.db.DbPersistenceService] creating hibernate session
2007-02-06 16:29:10,790 DEBUG [org.hibernate.impl.SessionImpl] opened session at timestamp: 4795585946083328
2007-02-06 16:29:10,790 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3 at a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader at 395626{ url=null ,addedOrder=0}
2007-02-06 16:29:10,790 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3 at a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader at 46f28c{ url=null ,addedOrder=0}
2007-02-06 16:29:10,837 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,837 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,852 DEBUG [org.jboss.mx.loading.RepositoryClassLoader] setRepository, repository=org.jboss.mx.loading.HeirarchicalLoaderRepository3 at a1ee92, cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader at 7958ef{ url=null ,addedOrder=0}
2007-02-06 16:29:10,852 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
2007-02-06 16:29:10,868 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
2007-02-06 16:29:10,915 DEBUG [org.hibernate.SQL] select * from ( select processdef0_.ID_ as ID1_31_, processdef0_.NAME_ as NAME2_31_, processdef0_.VERSION_ as VERSION3_31_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN4_31_, processdef0_.STARTSTATE_ as STARTSTATE5_31_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc ) where rownum <= ?
2007-02-06 16:29:11,227 DEBUG [org.hibernate.loader.hql.QueryLoader] bindNamedParameters() RequestNewAccess -> name [1]
2007-02-06 16:29:11,243 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,321 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open ResultSet (open ResultSets: 0, globally: 0)
2007-02-06 16:29:11,321 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,337 DEBUG [org.hibernate.loader.Loader] result row: EntityKey[org.jbpm.graph.def.ProcessDefinition#24811]
2007-02-06 16:29:11,337 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,337 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,352 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
2007-02-06 16:29:11,352 DEBUG [org.hibernate.jdbc.JDBCContext] TransactionFactory reported no active transaction; Synchronization not registered
...


I'm curious whether we have the right properties set in the jbm-hibernate.cfg.xml.  I don't have the following properties set for the JTATransaction,    

hibernate.jndi.url	JNDI initial context URL
hibernate.jndi.class	JNDI provider class
jta.UserTransaction	JNDI name

I plan to plug these in and try it.  I might also try the CMTTransactionFactory insteand of the JTATransactionFactory.  Again, I have checked the forums and can't find any advice so help is definitely appreciated.  

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

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