Hi Geert, & firstly many thanks for your comments - much appreciated. After posting I thought my description may be a little vague...
To clarify, by dynamic I need to be able to read from the database (I originally connect with an external manual single connection) to read the available environments and I then need to provide as many datasources/connection pools as needed. These datasources need to be available to both Tomcat (i.e. normal java classes) and Cocoon (xsp & esql). I'm very interested in your Oracle solution (reverse engineering and all that) while struggling to understand JNDI under both Tomcat & Cocoon (these two are lovers and I don't want to separate them by going OC4J) Any keywords for Google or code samples are more than welcome in my pursuit to get this working... Again thanks in advance. Rob -----Original Message----- From: Geert Josten [mailto:[EMAIL PROTECTED] Sent: 17 January 2006 20:08 To: users@cocoon.apache.org Subject: Re: Dyamic datasource configuration (2.1.7) is this possible? Errr, how dynamic is dynamic? I have worked on an implementation that uses JNDI internally and configures datasources in the webapp server (Oracle in this case.. :-P) In Oracle webserver you have the opportunity to define datasources on a maintenance webinterface. I'm not sure you can do that with Tomcat. What we more or less did in Tomcat for testing is define a Resource (with Params) and pointed to it with a ResourceLink in Host/Context. web.xml contains a resource-ref as well and some env-entry elements with additional information... By the way: the database management doesn't hook into any of the Cocoon's objects/lifecycle management parts in this case. It could have, but configuration would have been totally different, I guess.. HTH, Geert Rob Gregory wrote: > Hello People, & thanks in advance for any assistance. > > > > I am running Cocoon 2.1.7 under Tomcat 5.5.9 and have a desperate > requirement to provide the database (datasources/connection pools) > dynamically aka 'on-the-fly'. > > > > After 'Googling' for about six months now and getting as far as Cocoon > using the same connections provided to Tomcat by using the format:- > > > > <j2ee name="logindb"> > > <dbname>logindb</dbname> > > </j2ee> > > > > Over my previous attempt of:- > > > > <jdbc name="MyConnectionName"> > > > > <pool-controller min="5" max="10"/> > > <dburl>jdbc:oracle:thin:@localhost:1521:mydatabase</dburl> > > <user>mylogin</user> > > <password>myPassword</password> > > </jdbc> > > > > Any pointers towards creating or configuring the datasources available > to actions & esql would be great. > > > > Thanks Again. > > Rob > -- Drs. G.P.H. Josten Consultant Daidalos BV Source of Innovation Hoekeindsehof 1-4 2665 JZ Bleiswijk Tel: +31 (0) 10 850 1200 Fax: +31 (0) 10 850 1199 www.daidalos.nl De informatie - verzonden in of met dit emailbericht - is afkomstig van Daidalos BV en is uitsluitend bestemd voor de geadresseerde. Indien u dit bericht onbedoeld hebt ontvangen, verzoeken wij u het te verwijderen. Aan dit bericht kunnen geen rechten worden ontleend. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]