I need to be able to connect to multiple databases on the fly in my app. I'm using esql. I'd also like to use connection pooling.
I tried creating a new Component on the fly (DynamicJdbcDataSource which extends JdbcDataSource), thinking that I could grab the ComponentManager, and add my new component to it, so that my esql sheet could continue to use <esql:pool>, and have it use my component. The problem is that I guess I can't add a new component to an already initialized component manager. So, I guess you are supposed to create a fixed number of (pooled) components at startup time, and that number can't change while the app is running? If that is the case, I guess what I need to do is use org.apache.avalon.excalibur.datasource.JdbcConnectionPool, and hack esql to use that instead of the component selector? Thanks, Steve --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>