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