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@a1ee92,
cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@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@a1ee92,
cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@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@a1ee92,
cl=org.jboss.mx.loading.HeirarchicalLoaderRepository3$CacheClassLoader@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
...
We have copied the configuration of Gavin's project exactly per his request to Brad.
However, 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=4012435#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...