Hello - hoping to get some help.

We are using tcserver 7 using oracle database for our backend. I have the following configured in the context.xml for the datasource connections. Problem is, on the oracle side, we are seeing 240 idle connections, when I have it configured to only 3. Is there something I may be missing that is allowing so many connections on the tcserver side in the configuration? Thanks for any help.


<Resource driverClassName="oracle.jdbc.OracleDriver" name="jdbc/pool" type="javax.sql.DataSource" username="XXXXX" password="XXXXX" url="jdbc:oracle:thin:@l4sidd03:1526:dbprtl04" maxActive="20" maxIdle="3" maxWait="10000"/>
<Resource driverClassName="oracle.jdbc.OracleDriver" name="jdbc/base_pool" type="javax.sql.DataSource" username="XXXXX" password="XXXXX" url="jdbc:oracle:thin:@l4sidd03:1526:dbprtl04" maxActive="20" maxIdle="3" maxWait="10000"/>
<Resource driverClassName="oracle.jdbc.OracleDriver" name="jdbc/client_poot" type="javax.sql.DataSource" username="XXXXX" password="XXXXX" url="jdbc:oracle:thin:@l4sidd03:1526:dbprtl04" maxActive="20" maxIdle="3" maxWait="10000"/>
<Resource driverClassName="oracle.jdbc.OracleDriver" name="jdbc/GMC_pool" type="javax.sql.DataSource" username="XXXXX" password="XXXXX" url="jdbc:oracle:thin:@l4sidd03:1526:dbprtl04" maxActive="20" maxIdle="3" maxWait="10000"/>