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, [EMAIL PROTECTED], [EMAIL PROTECTED] url=null ,addedOrder=0}
2007-02-06 16:29:10,790 DEBUG [org.jboss.mx.loading.RepositoryClassLoader]
setRepository, [EMAIL PROTECTED], [EMAIL PROTECTED] 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, [EMAIL PROTECTED], [EMAIL PROTECTED] 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#4012435
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4012435
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
