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

[jowizzle]

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#4089398

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4089398