Dynamic multiple connection pools using Java

[basu_sh]

As we can create multiple data sources for multiple connection pools dynamically using <db2>-ds.xml configuration file. Similarly we require to create multiple data sources dynamically in Java.

So let me know can we do it from Java side or not. Is there any other approaches for dynamic connection pooling in JBoss.

[wdfink]

What did you mean?

Create and destroy connections pools from a Java application?

In that case you might use the management API introduced with AS7 to create it

[basu_sh]

Thanks for your answer. You are right, I need to create and destroy connection pools from Java application and also we need to assign maximum connections, minimum connections, idle timeout, etc. so it would be great if you share some examples for using management API.