Search Results


Tuesday, August 17, 2010

BPEL Tree SQL query

How to query the BPEL tree in the dehyderation database directly?

Tree finder using SQL query.

select
lpad(' ', (level - 1) * 2) || title as padded_name, process_id, modify_date-creation_date, creation_date, modify_date, state
from cube_instance ci1
connect by prior cikey = parent_id
start with cikey = :parent_process;


TreeFinder jsp is the most resource hungry webpage in the BPEL console. This query is an alternative to the Tree Finder jsp.


Cheers,
Prasanna

2 comments :

walid said...

Hi, please I need your email address for something important, please contact me at 01walid at gmail dot com I was searching the whole internet for your emai but I couldn't find it!

Vikrant Korde said...

For a SOA 11.1.1.6.0 version use below query

select cikey,
lpad(' ', (level - 1) * 2) || CI1.COMPONENT_NAME as padded_name, modify_date-creation_date, creation_date, modify_date, state
from cube_instance ci1
connect by prior ci1.cikey = to_number(substr(ci1.parent_ref_id, 0, instr(ci1.parent_ref_id, '-')-1))
start with cikey = :StartId;