Hi.
Am 21.06.2010 15:46, schrieb Rafal Rusin:
On Mon, Jun 21, 2010 at 3:36 PM, Christian Bruckhoff
<[email protected]> wrote:
Am 21.06.2010 15:29, schrieb Rafal Rusin:
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
But I can only read them? That's how I understand this guide.
You can write too, but apparently there's no guide for this. You can
check out ExtVar* test processes to grab some info:
http://svn.apache.org/repos/asf/ode/trunk/bpel-test/src/test/resources/bpel/2.0/
Finally I got some time so check the examples out, but I need to know,
how to configure the database for trying them. Can you help me wth this?
Greetings
Christian
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
