Ok here's the log:
| 10:31:20,953 DEBUG [CommandServiceBean] getting jbpm configuration resource from the
environment properties
| 10:31:21,390 DEBUG [UIComponentTag] Exited encodeEnd for client-Id: _idJsp0
| 10:31:21,390 DEBUG [CommandServiceBean] couldn't find configuration property
JbpmCfgResource through JNDI
| 10:31:21,390 DEBUG [CommandServiceBean] getting default jbpm configuration resource
(jbpm.cfg.xml)
| 10:31:21,390 DEBUG [CommandServiceBean] handing over the command execution to the
command service
| 10:31:21,390 DEBUG [JbpmContextInfo] creating jbpm context with service factories
'[tx, message, scheduler, logging, persistence, authentication]'
| 10:31:21,390 DEBUG [FacesServlet] service end
| 10:31:21,890 DEBUG [JbpmContext] creating org.jbpm.JbpmContext@37c7ee
| 10:31:21,890 DEBUG [CommandServiceBean] executing
org.jbpm.command.GetTaskListCommand@26fb32
| 10:31:21,890 DEBUG [DbPersistenceServiceFactory] creating persistence service
| 10:31:21,890 DEBUG [DbPersistenceService] creating hibernate session
| 10:31:21,890 DEBUG [SessionImpl] opened session at timestamp: 4832214556221440
| 10:31:21,890 DEBUG [DbPersistenceService] beginning hibernate transaction
| 10:31:21,890 DEBUG [JDBCTransaction] begin
| 10:31:21,890 DEBUG [ConnectionManager] opening JDBC connection
| 10:31:21,890 DEBUG [DriverManagerConnectionProvider] total checked-out connections: 1
| 10:31:21,890 DEBUG [DriverManagerConnectionProvider] opening new JDBC connection
| 10:31:21,906 DEBUG [DriverManagerConnectionProvider] created connection to:
jdbc:mysql://localhost:3306/workflow-server, Isolation Level: 4
| 10:31:21,906 DEBUG [JDBCTransaction] current autocommit status: false
| 10:31:21,906 DEBUG [JDBCContext] after transaction begin
| 10:31:21,937 DEBUG [QueryPlanCache] located HQL query plan in cache (
|
| select ti
| from org.jbpm.taskmgmt.exe.TaskInstance as ti
| where ti.actorId = :actorId
| and ti.isSuspended != true
| and ti.isOpen = true
|
| )
| 10:31:22,390 DEBUG [QueryPlanCache] located HQL query plan in cache (
|
| select ti
| from org.jbpm.taskmgmt.exe.TaskInstance as ti
| where ti.actorId = :actorId
| and ti.isSuspended != true
| and ti.isOpen = true
|
| )
| 10:31:22,390 DEBUG [HQLQueryPlan] find:
|
| select ti
| from org.jbpm.taskmgmt.exe.TaskInstance as ti
| where ti.actorId = :actorId
| and ti.isSuspended != true
| and ti.isOpen = true
|
|
| 10:31:22,390 DEBUG [QueryParameters] named parameters: {actorId=grover}
| 10:31:22,890 DEBUG [AbstractBatcher] about to open PreparedStatement (open
PreparedStatements: 0, globally: 0)
| 10:31:22,890 DEBUG [SQL] select taskinstan0_.ID_ as ID1_27_, taskinstan0_.VERSION_ as
VERSION3_27_, taskinstan0_.NAME_ as NAME4_27_, taskinstan0_.DESCRIPTION_ as DESCRIPT5_27_,
taskinstan0_.ACTORID_ as ACTORID6_27_, taskinstan0_.CREATE_ as CREATE7_27_,
taskinstan0_.START_ as START8_27_, taskinstan0_.END_ as END9_27_, taskinstan0_.DUEDATE_ as
DUEDATE10_27_, taskinstan0_.PRIORITY_ as PRIORITY11_27_, taskinstan0_.ISCANCELLED_ as
ISCANCE12_27_, taskinstan0_.ISSUSPENDED_ as ISSUSPE13_27_, taskinstan0_.ISOPEN_ as
ISOPEN14_27_, taskinstan0_.ISSIGNALLING_ as ISSIGNA15_27_, taskinstan0_.ISBLOCKING_ as
ISBLOCKING16_27_, taskinstan0_.TASK_ as TASK17_27_, taskinstan0_.TOKEN_ as TOKEN18_27_,
taskinstan0_.PROCINST_ as PROCINST19_27_, taskinstan0_.SWIMLANINSTANCE_ as SWIMLAN20_27_,
taskinstan0_.TASKMGMTINSTANCE_ as TASKMGM21_27_ from JBPM_TASKINSTANCE taskinstan0_ where
taskinstan0_.ACTORID_=? and taskinstan0_.ISSUSPENDED_<>1 and taskinstan0_.ISOPEN_=1
| 10:31:23,390 DEBUG [AbstractBatcher] preparing statement
| 10:31:23,390 DEBUG [StringType] binding 'grover' to parameter: 1
| 10:31:23,390 DEBUG [AbstractBatcher] about to open ResultSet (open ResultSets: 0,
globally: 0)
| 10:31:23,390 DEBUG [Loader] processing result set
| 10:31:23,390 DEBUG [Loader] done processing result set (0 rows)
| 10:31:23,390 DEBUG [AbstractBatcher] about to close ResultSet (open ResultSets: 1,
globally: 1)
| 10:31:23,390 DEBUG [AbstractBatcher] about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
| 10:31:23,390 DEBUG [AbstractBatcher] closing statement
| 10:31:23,890 DEBUG [Loader] total objects hydrated: 0
| 10:31:23,890 DEBUG [StatefulPersistenceContext] initializing non-lazy collections
| 10:31:23,890 DEBUG [QueryPlanCache] located HQL query plan in cache (
|
| select distinct ti
| from org.jbpm.taskmgmt.exe.PooledActor pooledActor
| join pooledActor.taskInstances ti
| where pooledActor.actorId in ( :actorIds )
| and ti.actorId is null
| and ti.isSuspended != true
| and ti.isOpen = true
|
| )
| 10:31:23,890 DEBUG [QueryPlanCache] located HQL query plan in cache (
|
| select distinct ti
| from org.jbpm.taskmgmt.exe.PooledActor pooledActor
| join pooledActor.taskInstances ti
| where pooledActor.actorId in ( :actorIds )
| and ti.actorId is null
| and ti.isSuspended != true
| and ti.isOpen = true
|
| )
| 10:31:24,390 DEBUG [HQLQueryPlan] find:
|
| select distinct ti
| from org.jbpm.taskmgmt.exe.PooledActor pooledActor
| join pooledActor.taskInstances ti
| where pooledActor.actorId in ( :actorIds )
| and ti.actorId is null
| and ti.isSuspended != true
| and ti.isOpen = true
|
|
| 10:31:24,390 DEBUG [QueryParameters] named parameters: {actorIds=grover}
| 10:31:24,390 DEBUG [AbstractBatcher] about to open PreparedStatement (open
PreparedStatements: 0, globally: 0)
| 10:31:24,390 DEBUG [SQL] select distinct taskinstan2_.ID_ as ID1_27_,
taskinstan2_.VERSION_ as VERSION3_27_, taskinstan2_.NAME_ as NAME4_27_,
taskinstan2_.DESCRIPTION_ as DESCRIPT5_27_, taskinstan2_.ACTORID_ as ACTORID6_27_,
taskinstan2_.CREATE_ as CREATE7_27_, taskinstan2_.START_ as START8_27_, taskinstan2_.END_
as END9_27_, taskinstan2_.DUEDATE_ as DUEDATE10_27_, taskinstan2_.PRIORITY_ as
PRIORITY11_27_, taskinstan2_.ISCANCELLED_ as ISCANCE12_27_, taskinstan2_.ISSUSPENDED_ as
ISSUSPE13_27_, taskinstan2_.ISOPEN_ as ISOPEN14_27_, taskinstan2_.ISSIGNALLING_ as
ISSIGNA15_27_, taskinstan2_.ISBLOCKING_ as ISBLOCKING16_27_, taskinstan2_.TASK_ as
TASK17_27_, taskinstan2_.TOKEN_ as TOKEN18_27_, taskinstan2_.PROCINST_ as PROCINST19_27_,
taskinstan2_.SWIMLANINSTANCE_ as SWIMLAN20_27_, taskinstan2_.TASKMGMTINSTANCE_ as
TASKMGM21_27_ from JBPM_POOLEDACTOR pooledacto0_ inner join JBPM_TASKACTORPOOL
taskinstan1_ on pooledacto0_.ID_=taskinstan1_.POOLEDACTOR_ inner join JBPM_TASKINSTANCE
taskinstan2_ on taskinstan1_.TASKINSTANCE_=taskinstan2_.ID_ where (pooledacto0_.ACTORID_
in (?)) and (taskinstan2_.ACTORID_ is null) and taskinstan2_.ISSUSPENDED_<>1 and
taskinstan2_.ISOPEN_=1
| 10:31:24,890 DEBUG [AbstractBatcher] preparing statement
| 10:31:24,890 DEBUG [StringType] binding 'grover' to parameter: 1
| 10:31:24,906 DEBUG [AbstractBatcher] about to open ResultSet (open ResultSets: 0,
globally: 0)
| 10:31:24,906 DEBUG [Loader] processing result set
| 10:31:24,906 DEBUG [Loader] done processing result set (0 rows)
| 10:31:24,906 DEBUG [AbstractBatcher] about to close ResultSet (open ResultSets: 1,
globally: 1)
| 10:31:24,906 DEBUG [AbstractBatcher] about to close PreparedStatement (open
PreparedStatements: 1, globally: 1)
| 10:31:25,390 DEBUG [AbstractBatcher] closing statement
| 10:31:25,390 DEBUG [Loader] total objects hydrated: 0
| 10:31:25,390 DEBUG [StatefulPersistenceContext] initializing non-lazy collections
| 10:31:25,390 DEBUG [JbpmContext] closing JbpmContext
| 10:31:25,390 DEBUG [Services] closing service 'persistence':
org.jbpm.persistence.db.DbPersistenceService@1e775bc
| 10:31:25,390 DEBUG [DbPersistenceService] committing hibernate transaction
| 10:31:25,390 DEBUG [JDBCTransaction] commit
| 10:31:25,390 DEBUG [SessionImpl] automatically flushing session
| 10:31:25,390 DEBUG [JDBCContext] before transaction completion
| 10:31:25,890 DEBUG [SessionImpl] before transaction completion
| 10:31:25,890 DEBUG [JDBCTransaction] committed JDBC Connection
| 10:31:25,890 DEBUG [JDBCContext] after transaction completion
| 10:31:25,890 DEBUG [ConnectionManager] aggressively releasing JDBC connection
| 10:31:25,890 DEBUG [ConnectionManager] releasing JDBC connection [ (open
PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
| 10:31:25,890 DEBUG [DriverManagerConnectionProvider] returning connection to pool,
pool size: 1
| 10:31:25,890 DEBUG [SessionImpl] after transaction completion
| 10:31:25,890 DEBUG [DbPersistenceService] closing hibernate session
| 10:31:25,890 DEBUG [SessionImpl] closing session
| 10:31:25,890 DEBUG [ConnectionManager] connection already null in cleanup : no action
| 10:31:25,890 DEBUG [Services] closing service 'tx':
org.jbpm.tx.TxService@15080e5
| 10:31:25,890 DEBUG [UIComponentTag] Exited encodeChildren for client-Id: taskList
| 10:31:26,390 DEBUG [UIComponentTag] Entered encodeEnd for client-Id: taskList
| 10:31:26,390 DEBUG [UIComponentTag] Exited encodeEnd for client-Id: taskList
| 10:31:26,390 DEBUG [FacesServlet] service end
|
|
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4047171#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...