Dyamic datasource configuration (2.1.7) is this possible?

Tue, 17 Jan 2006 11:48:09 -0800

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