Two configurations lead to eight pools

[jwyseu]

I have configured the following two connection pools in tomcat6:

<Resource auth="Container" connection_pool_timeout="200" driverClassName="oracle.jdbc.driver.OracleDriver" logAbandoned="true"
maxActive="10" maxIdle="5" minIdle="1" initialSize="1"
name="jdbc/qe" password="QE_UAT2" username="QE_UAT2"
removeAbandonedTimeout="60" removeAbdoned="true" testOnBorrow="true" testWhileIdle="true"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.Connection State;org.apache.tomcat.jdbc.pool.interceptor.Stat ementFinalizer;org.apache.tomcat.jdbc.pool.interce ptor.SlowQueryReportJmx(threshold=10000)"
type="javax.sql.DataSource" url="jdbc:oracle:thin:@ldap://nlbpns01.inf.dc.root.local:389/ACC_SWB,cn=OracleContext,dc=nuon,dc=local"
validationQuery="SELECT 1 FROM dual" />

<Resource auth="Container" driverClassName="net.sourceforge.jtds.jdbc.Driver"
maxActive="5" maxIdle="2" minIdle="1" initialSize="1" name="jdbc/siebel" password="QERO2"
servername="SBRS01AP012" type="javax.sql.DataSource" url="jdbc:jtds:sqlserver://SBRS01AP012:1433/N_BE_TST81;SelectMethod=Cursor;instance=BE_SBL_TST"
username="QERO1" />


In the monitoring I see the following connection pools:
10% jdbc/qe
0% jdbc/siebel
0% jdbc/siebel
0% jdbc/siebel
0% jdbc/qe
0% jdbc/siebel
0% jdbc/qe
0% jdbc/qe

How come I see 8 connection pools when I have only defined 2?

[jwyseu]

It seems that the connection pools are created for each web application (also / and ROOT, next to other web apps I deployed) but I would like a shared connection pool (and definitely not one for / and ROOT) how should I configure that?

[jwyseu]

Ok found it in the following blog post (http://mytechscratchpad.blogspot.com/2011/07/shared-connection-pool-between-multiple_15.html). I had to define in server.xml underneath GlobalNamingResources.

Don't forget to add also the resourcelink in context.xml otherwise you get a strange nullpointerexception.