On Mon, Jun 21, 2010 at 3:17 PM, Christian Bruckhoff <[email protected]> wrote: > Looks like the database is only for ODE internal data. Or can I also use it > for external data like > > SELECT * > FROM watergauge > Where parameter="W";
Yes, it's for internals. However sometimes it's useful to grab some data from it using SQL (for example to monitor activities states, variables, correlations, message exchanges, etc.) You can connect to external tables (from bpels) using extvars: http://ode.apache.org/external-variables.html > Am 21.06.2010 15:11, schrieb Rafal Rusin: >> >> 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
