Dynamic-Datasource

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Dynamic-Datasource

karthik Jayaraman
Hi,

I am using MySQL to store the Orbeon form and data.  I also have a requirement to switch my database as per the user logged in.  I have seen Orbeon provides dynamic-datasource from the following link,

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/mysql-persistence-layer

I am using Action and Services of Orbeon to pre-populate some of the data from a DB to the form.  How can I pass this dynamically.


Thanks & Regards
Reply | Threaded
Open this post in threaded view
|

Re: Dynamic-Datasource

Alessandro  Vernet
Administrator
Would the dynamic datasource system implemented by the MySQL
persistence layer help? See:

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/mysql-persistence-layer#TOC-Dynamic-datasource

Alex

On Mon, Apr 19, 2010 at 11:55 PM, karthik Jayraman <[hidden email]> wrote:

>
> Hi,
>
> I am using MySQL to store the Orbeon form and data.  I also have a
> requirement to switch my database as per the user logged in.  I have seen
> Orbeon provides dynamic-datasource from the following link,
>
> http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/mysql-persistence-layer
>
> I am using Action and Services of Orbeon to pre-populate some of the data
> from a DB to the form.  How can I pass this dynamically.
>
>
> Thanks & Regards
> --
> View this message in context: http://n4.nabble.com/Dynamic-Datasource-tp2016973p2016973.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> 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
>
>


--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
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
Reply | Threaded
Open this post in threaded view
|

Re: Dynamic-Datasource

karthik Jayaraman

Hi Alex,

Thanks for your information.
I gone through the link provided by you.
I am using Tomcat as container for Orbeon.  I created more datasource in context.xml available under <<tomcat_home>>\apache-tomcat-6.0.18\conf folder.  I tried to switch between the 2 datasources, but I am not able to achieve this.
Can you please provide me some more details or an example to achieve this, will be very useful for me.

Thanks & Regards
Reply | Threaded
Open this post in threaded view
|

Re: Re: Dynamic-Datasource

Alessandro  Vernet
Administrator
Karthik,

You'll need to have some sort of proxy that adds the header before
forwarding the request to Orbeon Forms. That proxy sets the value of
the Orbeon-Datasource header to a different value depending on the
criteria you choose to use to pick a datasource. If you just want to
test this out, you can set the header manually to different values
issuing queries from Firefox and setting the header with the Modify
Headers extension.

Alex

On Wed, Apr 21, 2010 at 1:22 AM, karthik Jayraman <[hidden email]> wrote:

>
>
> Hi Alex,
>
> Thanks for your information.
> I gone through the link provided by you.
> I am using Tomcat as container for Orbeon.  I created more datasource in
> context.xml available under <<tomcat_home>>\apache-tomcat-6.0.18\conf
> folder.  I tried to switch between the 2 datasources, but I am not able to
> achieve this.
> Can you please provide me some more details or an example to achieve this,
> will be very useful for me.
>
> Thanks & Regards
> --
> View this message in context: http://n4.nabble.com/Dynamic-Datasource-tp2016973p2018573.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> 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
>
>


--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
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
Reply | Threaded
Open this post in threaded view
|

Re: Re: Dynamic-Datasource

karthik Jayaraman
Could you be more explanatory ? I cant figure out your reply !!! Please help !
Reply | Threaded
Open this post in threaded view
|

Re: Re: Re: Dynamic-Datasource

Alessandro  Vernet
Administrator
Karthik,

Is there something specific in the section linked below which is not
clear, and that I could clarify here?

http://wiki.orbeon.com/forms/doc/developer-guide/form-runner/mysql-persistence-layer#TOC-Dynamic-datasource

Alex

On Wed, May 12, 2010 at 9:43 PM, karthik Jayaraman <[hidden email]> wrote:

>
> Could you be more explanatory ? I cant figure out your reply !!! Please help
> !
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Dynamic-Datasource-tp2016973p2197134.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> 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
>
>


--
Orbeon Forms - Web forms, open-source, for the Enterprise -
http://www.orbeon.com/
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