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 [EMAIL PROTECTED]
| 10:31:21,890 DEBUG [CommandServiceBean] executing [EMAIL PROTECTED]
| 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_TASKINSTAN!
CE 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': [EMAIL
PROTECTED]
| 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': [EMAIL PROTECTED]
| 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#4047171
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4047171
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
