Orbeon Forms community mailing list

Configure Orbeon to Connect to Different Database Dynamically - Reg

Classic

List

Threaded

4 messages Options

Bala

Configure Orbeon to Connect to Different Database Dynamically - Reg

Hi,

Is it possible to configure Orbeon to point to more than one database instance and choose any one based on some input chosen by the user who is submitting the form?

i.e, My Current application design requires to associate one database instance for each country, so currently I have around 10 database and I am using the Orbeon form to generate different feedback forms based on country and if required add some fields to the design. So I want orbeon to persist the submitted feedback details to any one of the country database based on the Country the user selected in the UI.

Its a common feature now to point a application to more than one database. Since I am new to orbeon I am not sure about how to configure this.

Please Help!

Thanks,

BalamuruganS

KumaranSystems Private Limited, Chennai

Ph: +91-44-42273100 Ext:3136

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Alessandro Vernet

Re: Configure Orbeon to Connect to Different Database Dynamically - Reg

Administrator

On Thu, Nov 5, 2009 at 11:22 AM, Balamurugan Sathanantham
<[hidden email]> wrote:
> Is it possible to configure Orbeon to point to more than one database
> instance and choose any one based on some input chosen by the user who
> is submitting the form?

Are you referring to relational databases, for which you would have a
different data source defined in your application server, or to
something else?

Alex
--
Orbeon Forms - Web forms, open-source, for the Enterprise
Orbeon's Blog: http://www.orbeon.com/blog/
My Twitter: http://twitter.com/avernet

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

Bala

RE: Re: Configure Orbeon to Connect to Different Database Dynamically - Reg

Yes. I have configured Orbeon to query and store data from MySQL. So for each country I have created a new database instance for each country.

Thanks
Bala Murugan S

-----Original Message-----
From: Alessandro Vernet [mailto:[hidden email]]
Sent: Friday, November 06, 2009 5:02 AM
To: [hidden email]
Subject: [ops-users] Re: Configure Orbeon to Connect to Different
Database Dynamically - Reg

On Thu, Nov 5, 2009 at 11:22 AM, Balamurugan Sathanantham
<[hidden email]> wrote:
> Is it possible to configure Orbeon to point to more than one database
> instance and choose any one based on some input chosen by the user who
> is submitting the form?

Are you referring to relational databases, for which you would have a
different data source defined in your application server, or to
something else?

Alex
--
Orbeon Forms - Web forms, open-source, for the Enterprise
Orbeon's Blog: http://www.orbeon.com/blog/
My Twitter: http://twitter.com/avernet

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

Alessandro Vernet

Re: RE: Re: Configure Orbeon to Connect to Different Database Dynamically - Reg

Administrator

Bala,

On Thu, Nov 5, 2009 at 11:58 PM, Balamurugan Sathanantham
<[hidden email]> wrote:
> Yes. I have configured Orbeon to query and store data from MySQL. So for each country I have created a new database instance for each country.

And are you using the SQL processor from a pipeline to query the
database? If you do, then the SQL processor takes that the name of the
data source as a configuration in input, so you can, even dynamically
if needed, select what data source you want to use. Does this make
sense?

http://www.orbeon.com/ops/doc/processors-sql#d24e126

Alex
--
Orbeon Forms - Web forms, open-source, for the Enterprise
Orbeon's Blog: http://www.orbeon.com/blog/
My Twitter: http://twitter.com/avernet

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet