[jboss-user] [jBPM] - Re: Problem with Human Task query TasksAssignedAsPotentialOwnerByStatus
Fred DERNBACH
do-not-reply at jboss.com
Thu Jan 17 07:42:41 EST 2013
Fred DERNBACH [https://community.jboss.org/people/fdernb] created the discussion
"Re: Problem with Human Task query TasksAssignedAsPotentialOwnerByStatus"
To view the discussion, visit: https://community.jboss.org/message/792579#792579
--------------------------------------------------------------
I confirm the issue. Oracle does not receive proper binding variable for status list. below is the Oracle trace of the hibernate query. See in *bold*.
SQL_ID 1fnn7qr6kqp5y, child number 1
-------------------------------------
select user2_.id as id175_0_, user1_.id as id175_1_, task0_.id as col_0_0_,
task0_.processInstanceId as col_1_0_, names5_.text as col_2_0_, subjects3_.text as col_3_0_,
descriptio4_.text as col_4_0_, task0_.status as col_5_0_, task0_.priority as col_6_0_,
task0_.skipable as col_7_0_, user2_.id as col_8_0_, user1_.id as col_9_0_, task0_.createdOn as
col_10_0_, task0_.activationTime as col_11_0_, task0_.expirationTime as col_12_0_,
task0_.processId as col_13_0_, task0_.processSessionId as col_14_0_ from Task task0_ left outer
join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join
OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText
subjects3_ on task0_.id=subjects3_.Task_Subjects_Id left outer join I18NText descriptio4_ on
task0_.id=descriptio4_.Task_Descriptions_Id left outer join I18NText names5_ on
task0_.id=names5_.Task_Names_Id, OrganizationalEntity organizati6_ where (task0_.archived=0
)and((organizati6_.id=:1 )or(organi
Plan hash value: 2720357931
---------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
---------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 40 (100)| |
|* 1 | FILTER | | | | | |
|* 2 | HASH JOIN OUTER | | 1 | 7594 | 40 (5)| 00:00:04 |
|* 3 | HASH JOIN OUTER | | 1 | 5450 | 33 (7)| 00:00:04 |
|* 4 | HASH JOIN OUTER | | 1 | 3306 | 25 (4)| 00:00:03 |
| 5 | NESTED LOOPS | | 1 | 1162 | 18 (6)| 00:00:02 |
|* 6 | HASH JOIN | | 1 | 1033 | 17 (6)| 00:00:02 |
| 7 | NESTED LOOPS OUTER | | 1 | 891 | 9 (0)| 00:00:01 |
| 8 | NESTED LOOPS OUTER| | 1 | 762 | 8 (0)| 00:00:01 |
|* 9 | TABLE ACCESS FULL| TASK | 1 | 633 | 7 (0)| 00:00:01 |
|* 10 | INDEX UNIQUE SCAN| SYS_C00144479 | 1 | 129 | 1 (0)| 00:00:01 |
|* 11 | INDEX UNIQUE SCAN | SYS_C00144479 | 1 | 129 | 1 (0)| 00:00:01 |
| 12 | SORT UNIQUE | | 10 | 1420 | 7 (0)| 00:00:01 |
|* 13 | TABLE ACCESS FULL | PEOPLEASSIGNMENTS_POTOWNERS | 10 | 1420 | 7 (0)| 00:00:01 |
|* 14 | INDEX UNIQUE SCAN | SYS_C00144479 | 1 | 129 | 1 (0)| 00:00:01 |
| 15 | TABLE ACCESS FULL | I18NTEXT | 30 | 64320 | 7 (0)| 00:00:01 |
| 16 | TABLE ACCESS FULL | I18NTEXT | 30 | 64320 | 7 (0)| 00:00:01 |
| 17 | TABLE ACCESS FULL | I18NTEXT | 30 | 64320 | 7 (0)| 00:00:01 |
| 18 | SORT AGGREGATE | | 1 | 13 | | |
|* 19 | TABLE ACCESS FULL | I18NTEXT | 1 | 13 | 7 (0)| 00:00:01 |
| 20 | SORT AGGREGATE | | 1 | 13 | | |
|* 21 | TABLE ACCESS FULL | I18NTEXT | 1 | 13 | 7 (0)| 00:00:01 |
| 22 | SORT AGGREGATE | | 1 | 13 | | |
|* 23 | TABLE ACCESS FULL | I18NTEXT | 1 | 13 | 7 (0)| 00:00:01 |
---------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1B69B172
9 - SEL$1B69B172 / TASK0_ at SEL$2
10 - SEL$1B69B172 / USER2_ at SEL$3
11 - SEL$1B69B172 / USER1_ at SEL$1
13 - SEL$1B69B172 / POTENTIALO7_ at SEL$12
14 - SEL$1B69B172 / ORGANIZATI6_ at SEL$11
15 - SEL$1B69B172 / NAMES5_ at SEL$9
16 - SEL$1B69B172 / DESCRIPTIO4_ at SEL$7
17 - SEL$1B69B172 / SUBJECTS3_ at SEL$5
18 - SEL$13
19 - SEL$13 / NAMES8_ at SEL$13
20 - SEL$14
21 - SEL$14 / SUBJECTS9_ at SEL$14
22 - SEL$15
23 - SEL$15 / DESCRIPTIO10_ at SEL$15
Outline Data
-------------
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.4')
OPT_PARAM('_optimizer_connect_by_cost_based' 'false')
OPT_PARAM('star_transformation_enabled' 'temp_disable')
OPT_PARAM('optimizer_index_caching' 50)
ALL_ROWS
OUTLINE_LEAF(@"SEL$13")
OUTLINE_LEAF(@"SEL$14")
OUTLINE_LEAF(@"SEL$15")
OUTLINE_LEAF(@"SEL$1B69B172")
UNNEST(@"SEL$12")
OUTLINE(@"SEL$13")
OUTLINE(@"SEL$14")
OUTLINE(@"SEL$15")
OUTLINE(@"SEL$48266A83")
MERGE(@"SEL$B97648DD")
OUTLINE(@"SEL$12")
OUTLINE(@"SEL$11")
OUTLINE(@"SEL$B97648DD")
MERGE(@"SEL$096E5AED")
MERGE(@"SEL$9")
OUTLINE(@"SEL$10")
OUTLINE(@"SEL$096E5AED")
MERGE(@"SEL$15E987C1")
MERGE(@"SEL$7")
OUTLINE(@"SEL$9")
OUTLINE(@"SEL$8")
OUTLINE(@"SEL$15E987C1")
MERGE(@"SEL$5")
MERGE(@"SEL$7237DA6D")
OUTLINE(@"SEL$7")
OUTLINE(@"SEL$6")
OUTLINE(@"SEL$5")
OUTLINE(@"SEL$7237DA6D")
MERGE(@"SEL$3")
MERGE(@"SEL$58A6D7F6")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$58A6D7F6")
MERGE(@"SEL$1")
OUTLINE(@"SEL$2")
OUTLINE(@"SEL$1")
FULL(@"SEL$1B69B172" "TASK0_"@"SEL$2")
INDEX(@"SEL$1B69B172" "USER2_"@"SEL$3" ("ORGANIZATIONALENTITY"."ID"))
INDEX(@"SEL$1B69B172" "USER1_"@"SEL$1" ("ORGANIZATIONALENTITY"."ID"))
FULL(@"SEL$1B69B172" "POTENTIALO7_"@"SEL$12")
INDEX(@"SEL$1B69B172" "ORGANIZATI6_"@"SEL$11" ("ORGANIZATIONALENTITY"."ID"))
FULL(@"SEL$1B69B172" "NAMES5_"@"SEL$9")
FULL(@"SEL$1B69B172" "DESCRIPTIO4_"@"SEL$7")
FULL(@"SEL$1B69B172" "SUBJECTS3_"@"SEL$5")
LEADING(@"SEL$1B69B172" "TASK0_"@"SEL$2" "USER2_"@"SEL$3" "USER1_"@"SEL$1"
"POTENTIALO7_"@"SEL$12" "ORGANIZATI6_"@"SEL$11" "NAMES5_"@"SEL$9" "DESCRIPTIO4_"@"SEL$7"
"SUBJECTS3_"@"SEL$5")
USE_NL(@"SEL$1B69B172" "USER2_"@"SEL$3")
USE_NL(@"SEL$1B69B172" "USER1_"@"SEL$1")
USE_HASH(@"SEL$1B69B172" "POTENTIALO7_"@"SEL$12")
USE_NL(@"SEL$1B69B172" "ORGANIZATI6_"@"SEL$11")
USE_HASH(@"SEL$1B69B172" "NAMES5_"@"SEL$9")
USE_HASH(@"SEL$1B69B172" "DESCRIPTIO4_"@"SEL$7")
USE_HASH(@"SEL$1B69B172" "SUBJECTS3_"@"SEL$5")
FULL(@"SEL$15" "DESCRIPTIO10_"@"SEL$15")
FULL(@"SEL$14" "SUBJECTS9_"@"SEL$14")
FULL(@"SEL$13" "NAMES8_"@"SEL$13")
END_OUTLINE_DATA
*/
Peeked Binds (identified by position):
--------------------------------------
1 - :1 (VARCHAR2(30), CSID=46): 'ITCH'
2 - :2 (VARCHAR2(30), CSID=46): 'SECURITY_GLOBAL'
3 - :3 (VARCHAR2(30), CSID=46): 'SECURITY_AUTHORITY'
* 7 - :7 (RAW(30)): aced00057e7200146f72672e6a62706d2e7461736b2e537461747573000000000000000012000078720*
* 00e6a6176612e6c616e672e456e756d000000000000000012000078707400055265616479*
Predicate Information (identified by operation id):
---------------------------------------------------
1 - filter((("NAMES5_"."LANGUAGE"=:4 OR =0) AND ("SUBJECTS3_"."LANGUAGE"=:5 OR =0) AND
("DESCRIPTIO4_"."LANGUAGE"=:6 OR =0)))
2 - access("TASK0_"."ID"="SUBJECTS3_"."TASK_SUBJECTS_ID")
3 - access("TASK0_"."ID"="DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID")
4 - access("TASK0_"."ID"="NAMES5_"."TASK_NAMES_ID")
6 - access("TASK0_"."ID"="POTENTIALO7_"."TASK_ID")
9 - filter(("TASK0_"."EXPIRATIONTIME" IS NULL AND "TASK0_"."ARCHIVED"=0 AND
"TASK0_"."STATUS"=RAWTOHEX(:7)))
10 - access("TASK0_"."ACTUALOWNER_ID"="USER2_"."ID")
11 - access("TASK0_"."CREATEDBY_ID"="USER1_"."ID")
13 - filter(("POTENTIALO7_"."ENTITY_ID"=:1 OR "POTENTIALO7_"."ENTITY_ID"=:2 OR
"POTENTIALO7_"."ENTITY_ID"=:3))
14 - access("ORGANIZATI6_"."ID"="POTENTIALO7_"."ENTITY_ID")
filter(("ORGANIZATI6_"."ID"=:1 OR "ORGANIZATI6_"."ID"=:2 OR "ORGANIZATI6_"."ID"=:3))
19 - filter("NAMES8_"."TASK_NAMES_ID"=:B1)
21 - filter("SUBJECTS9_"."TASK_SUBJECTS_ID"=:B1)
23 - filter("DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID"=:B1)
Column Projection Information (identified by operation id):
-----------------------------------------------------------
1 - "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TEXT"[LOB,4000], "NAMES5_"."TEXT"[LOB,4000],
"USER1_"."ID"[VARCHAR2,255], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], "USER2_"."ID"[VARCHAR2,255],
"SUBJECTS3_"."TEXT"[LOB,4000]
2 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TEXT"[LOB,4000],
"NAMES5_"."TEXT"[LOB,4000], "USER1_"."ID"[VARCHAR2,255], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255], "USER2_"."ID"[VARCHAR2,255],
"NAMES5_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255],
"SUBJECTS3_"."LANGUAGE"[VARCHAR2,255], "SUBJECTS3_"."TEXT"[LOB,4000]
3 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID"[NUMBER,22],
"NAMES5_"."TEXT"[LOB,4000], "NAMES5_"."TASK_NAMES_ID"[NUMBER,22],
"ORGANIZATI6_"."ID"[VARCHAR2,255], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
"USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
"TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
"USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
"POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
"NAMES5_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255],
"DESCRIPTIO4_"."TEXT"[LOB,4000]
4 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "NAMES5_"."TASK_NAMES_ID"[NUMBER,22],
"ORGANIZATI6_"."ID"[VARCHAR2,255], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
"USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
"TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
"USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
"POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
"NAMES5_"."LANGUAGE"[VARCHAR2,255], "NAMES5_"."TEXT"[LOB,4000]
5 - "TASK0_"."ID"[NUMBER,22], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
"USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
"TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
"USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
"POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255], "ORGANIZATI6_".ROWID[ROWID,10],
"ORGANIZATI6_"."ID"[VARCHAR2,255]
6 - (#keys=1) "TASK0_"."ID"[NUMBER,22], "POTENTIALO7_"."TASK_ID"[NUMBER,22],
"USER1_"."ID"[VARCHAR2,255], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
"TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
"USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
"POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
7 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
"TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
"USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255], "USER1_".ROWID[ROWID,10],
"USER1_"."ID"[VARCHAR2,255]
8 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
"TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255],
"USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255]
9 - "TASK0_"."ID"[NUMBER,22], "TASK0_"."ARCHIVED"[NUMBER,22], "TASK0_"."PRIORITY"[NUMBER,22],
"TASK0_"."ACTIVATIONTIME"[TIMESTAMP,11], "TASK0_"."CREATEDON"[TIMESTAMP,11],
"TASK0_"."EXPIRATIONTIME"[TIMESTAMP,11], "TASK0_"."PROCESSID"[VARCHAR2,255],
"TASK0_"."PROCESSINSTANCEID"[NUMBER,22], "TASK0_"."PROCESSSESSIONID"[NUMBER,22],
"TASK0_"."SKIPABLE"[NUMBER,22], "TASK0_"."STATUS"[VARCHAR2,255],
"TASK0_"."ACTUALOWNER_ID"[VARCHAR2,255], "TASK0_"."CREATEDBY_ID"[VARCHAR2,255]
10 - "USER2_".ROWID[ROWID,10], "USER2_"."ID"[VARCHAR2,255]
11 - "USER1_".ROWID[ROWID,10], "USER1_"."ID"[VARCHAR2,255]
12 - (#keys=2) "POTENTIALO7_"."TASK_ID"[NUMBER,22], "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
13 - "POTENTIALO7_"."TASK_ID"[NUMBER,22], "POTENTIALO7_"."ENTITY_ID"[VARCHAR2,255]
14 - "ORGANIZATI6_".ROWID[ROWID,10], "ORGANIZATI6_"."ID"[VARCHAR2,255]
15 - "NAMES5_"."LANGUAGE"[VARCHAR2,255], "NAMES5_"."TEXT"[LOB,4000],
"NAMES5_"."TASK_NAMES_ID"[NUMBER,22]
16 - "DESCRIPTIO4_"."LANGUAGE"[VARCHAR2,255], "DESCRIPTIO4_"."TEXT"[LOB,4000],
"DESCRIPTIO4_"."TASK_DESCRIPTIONS_ID"[NUMBER,22]
17 - "SUBJECTS3_"."LANGUAGE"[VARCHAR2,255], "SUBJECTS3_"."TEXT"[LOB,4000],
"SUBJECTS3_"."TASK_SUBJECTS_ID"[NUMBER,22]
18 - (#keys=0) COUNT("NAMES8_"."TASK_NAMES_ID")[22]
19 - "NAMES8_"."TASK_NAMES_ID"[NUMBER,22]
20 - (#keys=0) COUNT("SUBJECTS9_"."TASK_SUBJECTS_ID")[22]
21 - "SUBJECTS9_"."TASK_SUBJECTS_ID"[NUMBER,22]
22 - (#keys=0) COUNT("DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID")[22]
23 - "DESCRIPTIO10_"."TASK_DESCRIPTIONS_ID"[NUMBER,22]
Note
-----
- dynamic sampling used for this statement
Subject
Requete Task
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/792579#792579]
Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130117/b0d9e323/attachment-0001.html
More information about the jboss-user
mailing list