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]
