Access multiple external databases from BPEL process

[Hoang Phung <Mi...@uts.edu.au>]

Hello everyone,

I need to set up BPEL processes that interact with multiple external 
databases using ODE. However, when searching the mailing list and other 
sources, I only saw references to using a single database for ODE 
itself, not for BPEL processes running on ODE. I've also looked at the 
test examples for external variables in svn, but they don't include the 
proper configuration for Tomcat, etc. Hence, I'm stuck with the error 
"Data source reference not found". Can someone help or point me to some 
examples that have the Tomcat config included? Thanks in advance.

Hoang

UTS CRICOS Provider Code:  00099F
DISCLAIMER: This email message and any accompanying attachments may contain confidential information.  If you are not the intended recipient, do not
read, use, disseminate, distribute or copy this message or attachments.  If
you have received this message in error, please notify the sender immediately
and delete this message. Any views expressed in this message are those of the individual sender, except where the sender expressly, and with authority,
states them to be the views of the University of Technology Sydney. Before
opening any attachments, please check them for viruses and defects.

Think. Green. Do.

Please consider the environment before printing this email.

Re: Access multiple external databases from BPEL process

[Milinda Pathirage <mi...@gmail.com>]

Hi Hoang,

IMHO, you must use some thing like WSO2 Data Services[1], to expose your DBs
as web services and then call the services from your BPEL processes. I have
discussed this issue here[2]. If you need help on WSO2 Data Services you can
use forums on wso2.org.

Thanks
Milinda

[1] http://wso2.org/downloads/data-services-server
<http://wso2.org/downloads/data-services-server>[2]
http://blog.mpathirage.com/2009/10/04/data-services-or-external-variables-with-jdbc-mapping/

On Tue, May 4, 2010 at 1:56 PM, Hoang Phung <Mi...@uts.edu.au>wrote:

> Hello everyone,
>
> I need to set up BPEL processes that interact with multiple external
> databases using ODE. However, when searching the mailing list and other
> sources, I only saw references to using a single database for ODE itself,
> not for BPEL processes running on ODE. I've also looked at the test examples
> for external variables in svn, but they don't include the proper
> configuration for Tomcat, etc. Hence, I'm stuck with the error "Data source
> reference not found". Can someone help or point me to some examples that
> have the Tomcat config included? Thanks in advance.
>
> Hoang
>
> UTS CRICOS Provider Code:  00099F
> DISCLAIMER: This email message and any accompanying attachments may contain
> confidential information.  If you are not the intended recipient, do not
> read, use, disseminate, distribute or copy this message or attachments.  If
> you have received this message in error, please notify the sender
> immediately
> and delete this message. Any views expressed in this message are those of
> the individual sender, except where the sender expressly, and with
> authority,
> states them to be the views of the University of Technology Sydney. Before
> opening any attachments, please check them for viruses and defects.
>
> Think. Green. Do.
>
> Please consider the environment before printing this email.
>



-- 
Milinda Pathirage
Senior Software Engineer & 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