Re: ODE and MySQL database

[Christian Bruckhoff <Ch...@gmx.de>]

Hi.

Am 21.06.2010 15:46, schrieb Rafal Rusin:
> On Mon, Jun 21, 2010 at 3:36 PM, Christian Bruckhoff
> <Ch...@gmx.de>  wrote:
>> Am 21.06.2010 15:29, schrieb Rafal Rusin:
>>>
>>> On Mon, Jun 21, 2010 at 3:17 PM, Christian Bruckhoff
>>> <Ch...@gmx.de>    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
>>>>> <Ch...@gmx.de>      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:Christian.Bruckhoff@gmx.de]
>>>>>>>>> Sent: Monday, June 21, 2010 6:01 PM
>>>>>>>>> To: user@ode.apache.org
>>>>>>>>> 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
>