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";
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
