You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ode.apache.org by Christian Bruckhoff <Ch...@gmx.de> on 2010/06/21 14:31:28 UTC
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
Re: ODE and MySQL database
Posted by Milinda Pathirage <mi...@gmail.com>.
Sorry, forgot the link.
[1]
http://blog.mpathirage.com/2009/10/04/data-services-or-external-variables-with-jdbc-mapping/
<http://blog.mpathirage.com/2009/10/04/data-services-or-external-variables-with-jdbc-mapping/>
Thanks
Milinda
On Wed, Jul 14, 2010 at 5:06 PM, Milinda Pathirage <
milinda.pathirage@gmail.com> wrote:
> Hi Christian,
>
> I think it's best to use some kind of a tool which provides support for
> exposing data in a database as a web service in your situation. Because you
> want be able to do advance database operations using external variables and
> you can get more features than that if you use external data services tool.
> I have discuss this issue here[1]. Please refer it if you need more
> information. I may be wrong, but it's better if you can separate out
> database querying logic from the BPEL process.
>
> Thanks
> Milinda
>
>
> On Tue, Jul 13, 2010 at 2:21 PM, Tammo van Lessen <tv...@gmail.com>wrote:
>
>> In the bpel-runtime package? In Derby? But I don't think there is a need
>> to compile this class.
>>
>> If you're looking for an example schema for extvars, then look at the
>> SQL statements in this class.
>>
>> Tammo
>>
>> On 13.07.2010 10:39, Christian Bruckhoff wrote:
>> > Hi.
>> >
>> > Am 12.07.2010 16:43, schrieb Tammo van Lessen:
>> >> Hi,
>> >>
>> >> please see here:
>> >>
>> http://svn.apache.org/repos/asf/ode/trunk/bpel-test/src/test/java/org/apache/ode/test/ExternalVariableTest.java
>> >>
>> >>
>> >> It creates the schema for the testrun.
>> >>
>> >> Tammo
>> >
>> > Where do I find the other classes needed:
>> >
>> > import org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource;
>> > import org.apache.ode.bpel.extvar.jdbc.JdbcExternalVariableModule;
>> >
>> > Greetings
>> > Christian
>> >
>> >> On 12.07.2010 12:00, Christian Bruckhoff wrote:
>> >>> Hi.
>> >>>
>> >>> Am 21.06.2010 15:46, schrieb Rafal Rusin:
>> >>>> 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/
>> >>>>
>> >>>>
>> >>>
>> >>> Is there a sql schema for the testdb of the ExtVar examples?
>> >>>
>> >>> Greeting
>> >>> Christian
>> >>
>>
>> --
>> Tammo van Lessen - http://www.taval.de
>>
>
>
>
> --
> Milinda Pathirage
> Technical Lead & Product Manager WSO2 BPS; http://wso2.org/bps
> WSO2 Inc.; http://wso2.com
> E-mail: milinda@wso2.com, milinda.pathirage@gmail.com
> Web: http://mpathirage.com
> Blog: http://blog.mpathirage.com
>
--
Milinda Pathirage
Technical Lead & Product Manager WSO2 BPS; http://wso2.org/bps
WSO2 Inc.; http://wso2.com
E-mail: milinda@wso2.com, milinda.pathirage@gmail.com
Web: http://mpathirage.com
Blog: http://blog.mpathirage.com
Re: ODE and MySQL database
Posted by Milinda Pathirage <mi...@gmail.com>.
Hi Christian,
I think it's best to use some kind of a tool which provides support for
exposing data in a database as a web service in your situation. Because you
want be able to do advance database operations using external variables and
you can get more features than that if you use external data services tool.
I have discuss this issue here[1]. Please refer it if you need more
information. I may be wrong, but it's better if you can separate out
database querying logic from the BPEL process.
Thanks
Milinda
On Tue, Jul 13, 2010 at 2:21 PM, Tammo van Lessen <tv...@gmail.com>wrote:
> In the bpel-runtime package? In Derby? But I don't think there is a need
> to compile this class.
>
> If you're looking for an example schema for extvars, then look at the
> SQL statements in this class.
>
> Tammo
>
> On 13.07.2010 10:39, Christian Bruckhoff wrote:
> > Hi.
> >
> > Am 12.07.2010 16:43, schrieb Tammo van Lessen:
> >> Hi,
> >>
> >> please see here:
> >>
> http://svn.apache.org/repos/asf/ode/trunk/bpel-test/src/test/java/org/apache/ode/test/ExternalVariableTest.java
> >>
> >>
> >> It creates the schema for the testrun.
> >>
> >> Tammo
> >
> > Where do I find the other classes needed:
> >
> > import org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource;
> > import org.apache.ode.bpel.extvar.jdbc.JdbcExternalVariableModule;
> >
> > Greetings
> > Christian
> >
> >> On 12.07.2010 12:00, Christian Bruckhoff wrote:
> >>> Hi.
> >>>
> >>> Am 21.06.2010 15:46, schrieb Rafal Rusin:
> >>>> 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/
> >>>>
> >>>>
> >>>
> >>> Is there a sql schema for the testdb of the ExtVar examples?
> >>>
> >>> Greeting
> >>> Christian
> >>
>
> --
> Tammo van Lessen - http://www.taval.de
>
--
Milinda Pathirage
Technical Lead & Product Manager WSO2 BPS; http://wso2.org/bps
WSO2 Inc.; http://wso2.com
E-mail: milinda@wso2.com, milinda.pathirage@gmail.com
Web: http://mpathirage.com
Blog: http://blog.mpathirage.com
Re: ODE and MySQL database
Posted by Tammo van Lessen <tv...@gmail.com>.
In the bpel-runtime package? In Derby? But I don't think there is a need
to compile this class.
If you're looking for an example schema for extvars, then look at the
SQL statements in this class.
Tammo
On 13.07.2010 10:39, Christian Bruckhoff wrote:
> Hi.
>
> Am 12.07.2010 16:43, schrieb Tammo van Lessen:
>> Hi,
>>
>> please see here:
>> http://svn.apache.org/repos/asf/ode/trunk/bpel-test/src/test/java/org/apache/ode/test/ExternalVariableTest.java
>>
>>
>> It creates the schema for the testrun.
>>
>> Tammo
>
> Where do I find the other classes needed:
>
> import org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource;
> import org.apache.ode.bpel.extvar.jdbc.JdbcExternalVariableModule;
>
> Greetings
> Christian
>
>> On 12.07.2010 12:00, Christian Bruckhoff wrote:
>>> Hi.
>>>
>>> Am 21.06.2010 15:46, schrieb Rafal Rusin:
>>>> 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/
>>>>
>>>>
>>>
>>> Is there a sql schema for the testdb of the ExtVar examples?
>>>
>>> Greeting
>>> Christian
>>
--
Tammo van Lessen - http://www.taval.de
Re: ODE and MySQL database
Posted by Christian Bruckhoff <Ch...@gmx.de>.
Hi.
Am 12.07.2010 16:43, schrieb Tammo van Lessen:
> Hi,
>
> please see here:
> http://svn.apache.org/repos/asf/ode/trunk/bpel-test/src/test/java/org/apache/ode/test/ExternalVariableTest.java
>
> It creates the schema for the testrun.
>
> Tammo
Where do I find the other classes needed:
import org.apache.derby.jdbc.EmbeddedConnectionPoolDataSource;
import org.apache.ode.bpel.extvar.jdbc.JdbcExternalVariableModule;
Greetings
Christian
> On 12.07.2010 12:00, Christian Bruckhoff wrote:
>> Hi.
>>
>> Am 21.06.2010 15:46, schrieb Rafal Rusin:
>>> 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/
>>>
>>
>> Is there a sql schema for the testdb of the ExtVar examples?
>>
>> Greeting
>> Christian
>
Re: ODE and MySQL database
Posted by Tammo van Lessen <tv...@gmail.com>.
Hi,
please see here:
http://svn.apache.org/repos/asf/ode/trunk/bpel-test/src/test/java/org/apache/ode/test/ExternalVariableTest.java
It creates the schema for the testrun.
Tammo
On 12.07.2010 12:00, Christian Bruckhoff wrote:
> Hi.
>
> Am 21.06.2010 15:46, schrieb Rafal Rusin:
>> 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/
>>
>
> Is there a sql schema for the testdb of the ExtVar examples?
>
> Greeting
> Christian
--
Tammo van Lessen - http://www.taval.de
Re: ODE and MySQL database
Posted by Christian Bruckhoff <Ch...@gmx.de>.
Hi.
Am 21.06.2010 15:46, schrieb Rafal Rusin:
> 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/
Is there a sql schema for the testdb of the ExtVar examples?
Greeting
Christian
Re: ODE and MySQL database
Posted by 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
>
Re: ODE and MySQL database
Posted by Christian Bruckhoff <Ch...@gmx.de>.
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.
>> 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
>>>>>>>
>>>>>
>>>>
>>>
>>>
>>>
>>
>
>
>
Re: ODE and MySQL database
Posted by Rafal Rusin <ra...@intalio.com>.
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
> 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
>>>>>>
>>>>
>>>
>>
>>
>>
>
--
Regards,
Rafał Rusin
http://rrusin.blogspot.com
Re: ODE and MySQL database
Posted by Christian Bruckhoff <Ch...@gmx.de>.
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
> <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
>>>>>
>>>
>>
>
>
>
Re: ODE and MySQL database
Posted by Rafal Rusin <ra...@intalio.com>.
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
>>>>
>>
>
--
Regards,
Rafał Rusin
http://rrusin.blogspot.com
Re: ODE and MySQL database
Posted by Christian Bruckhoff <Ch...@gmx.de>.
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
>>>
>
Re: ODE and MySQL database
Posted by Tammo van Lessen <tv...@gmail.com>.
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
>>
--
Tammo van Lessen - http://www.taval.de
RE: ODE and MySQL database
Posted by Dhanush Gopinath <dh...@altair.com>.
What do you mean by accessing it?
Once you configure it ODE will be able to access MySQL DB
-----Original Message-----
From: Christian Bruckhoff [mailto:Christian.Bruckhoff@gmx.de]
Sent: Monday, June 21, 2010 6:09 PM
To: user@ode.apache.org
Cc: Dhanush Gopinath
Subject: Re: ODE and MySQL database
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
>
Re: ODE and MySQL database
Posted by Christian Bruckhoff <Ch...@gmx.de>.
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
>
RE: ODE and MySQL database
Posted by Dhanush Gopinath <dh...@altair.com>.
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