Yes, this one is missing. I have some SQLs for monitoring. I can prepare some user guide entry on how to use it. In meantime, I'm sending two useful queries.
--select correlation set values select BCS.PIID, BCP.VALUE from BPEL_CORRELATION_SET BCS JOIN BPEL_CORRELATION_PROP BCP ON BCS.ID = BCP.CORR_SET_ID WHERE BCS.CORR_SET_NAME='bpelCorrSet'; --show active instances for processes and their deployment state select bp.procid, x.active_instances, sp.state deployment_state, sp.du DU_NAME from BPEL_PROCESS bp left outer join STORE_PROCESS sp on bp.procid = sp.pid left outer join (select bi.process_id process_id, count(*) active_instances from BPEL_INSTANCE bi, BPEL_PROCESS bp where bi.process_id = bp.id and bi.state = 20 group by bi.process_id) x on x.process_id = bp.id order by bp.procid; On Mon, Jun 21, 2010 at 2:59 PM, Christian Bruckhoff <[email protected]> wrote: > storing data in it, get it out of it etc... > > Am 21.06.2010 14:53, schrieb Tammo van Lessen: >> >> Hi, >> >> What do you mean by accessing it? >> >> Tammo >> >> On 21.06.2010 14:38, Christian Bruckhoff wrote: >>> >>> That's just the configuration of it, but how can I access it? >>> >>> Am 21.06.2010 14:35, schrieb Dhanush Gopinath: >>>> >>>> Its there in the user guide >>>> http://ode.apache.org/user-guide.html#UserGuide-ConfiguringODEinTomcatwi >>>> thaMySQLdatabase >>>> >>>> >>>> -----Original Message----- >>>> From: Christian Bruckhoff [mailto:[email protected]] >>>> Sent: Monday, June 21, 2010 6:01 PM >>>> To: [email protected] >>>> Subject: ODE and MySQL database >>>> >>>> Hi. >>>> >>>> I am looking for an example/tutarial on how to use ODE together with a >>>> MySQL database. You know one? >>>> >>>> Greetz >>>> Christian >>>> >> > -- Regards, Rafał Rusin http://rrusin.blogspot.com
