New pool programmatically or only through container  
Sean Harrison Thu Nov 08 17:55:36 GMT 2007
 
I have Primrose running with Tomcat 5.5. Works great!

Now I'd like to test an application using a more "portable" or "standalone" config. In other words, I'd like to distribute my war file and be able to deploy it, hook into Primrose, and create a new pool on-the-fly at deployment time. The benefit I'm looking for here is to be free of reconfiguring Tomcat if i want to adjust the parameters of my connection pool.

Is something like this possible? Am I way off track?

Thx!
 
sedj Tue Nov 13 18:31:33 GMT 2007
 
Tomcat won't allow you to bind a global JNDI resource on the fly - which means you can't configure primrose to either. It all must be set up in server.xml before startup.
Ningappa Mon Feb 04 09:45:24 GMT 2008
 
Hi...

can we use the PoolLoader class for creating the new pool programmatically ?

It is possible to do it using standalone PoolLoader... but is there any performance issues when v use this technique under tomcat ?


Thanks

sedj Mon Feb 04 19:09:05 GMT 2008
 
You can ... as per the docs here http://www.primrose.org.uk/primrose3/installTomcatNoJNDI.html ... but its a bit more of a pain to actually get a connection. There is no performance impact worth noting.