[jboss-user] [JCA/JBoss] - Can I share connection pool among applications?

I have 5 different instances of the same web application (to provide the service to 5 different clients). They all connect to the same oracle database, but they should each connect to a different schema. Currently I use a different datasource for each application, so my deployments look something like this: app1.war, app1-ds.xml app2.war, app2-ds.xml ... app5.war, app5-ds.xml I have a total of 550 allowable connections to oracle database, so I allow each to make up to 100 connections via the MaxSize attribute on the ManagedConnectionPool. The problem is that app1 gets far more usage, and sometimes has surpasses that 100-connection limit, while the others rarely see more than 30 concurrent connections. Can I set up a single shared pool that has 550 max connections that all 5 applications can draw from? I know that I can supply credentials to getConnection(..), but that would require a code change to my application. I read something very brief that I interpreted be a method for piggy-backing credentials from the app's login module. Or perhaps it was a misinterpretation. In any case, I appreciate your suggestions and advice. Thanks! View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4089398#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...