[
https://jira.jboss.org/jira/browse/JBPM-2088?page=com.atlassian.jira.plug...
]
Heiko Braun commented on JBPM-2088:
-----------------------------------
The actual SQL is this:
"2009-03-06 11:51:16,892 DEBUG [org.hibernate.SQL]
/* select
ti
from
org.jbpm.taskmgmt.exe.TaskInstance ti
join
ti.processInstance pi
where
pi.processDefinition = ? */ 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_
inner join
JBPM_PROCESSINSTANCE processins1_
on taskinstan0_.PROCINST_=processins1_.ID_
where
processins1_.PROCESSDEFINITION_=?
"
NOTE: See the comment section
According to [1] it's know bug with special characters in SQL comments.
[1]
http://markmail.org/message/zxeubyqn27xkm7p5#query:%22PSQLException%3A%20...
The list of tasks for process cannot be obtained
------------------------------------------------
Key: JBPM-2088
URL:
https://jira.jboss.org/jira/browse/JBPM-2088
Project: JBoss jBPM
Issue Type: Bug
Security Level: Public(Everyone can see)
Components: Console
Affects Versions: jBPM-3.2.5.SP2
Environment: SOA-P 4.3 CP01 CR3
Reporter: Jiri Pechanec
Assignee: Jiri Pechanec
Priority: Blocker
Fix For: jBPM-3.2.5.SP3
Attachments: jbpm-console-process-tasks.png, tasks.log.gz
Select the process and click on tasks (URL
http://localhost:8080/jbpm-console/app/procdef.jsf?id=1&view=task)
The result is an exception
Error loading task list: An exception of type
"org.hibernate.exception.DataException" was thrown. The message is: could not
execute query
From log
Error loading task list: An exception of type
"org.hibernate.exception.DataException" was thrown. The message is: could not
execute query
Will reproduce with higher log level
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira