I am using the Connection pool through JNDI Datasource to connect me to the database Oracle, however as I can be sure that the pool is working correctly. Below it is the configuration of my server.xml for the pool through JNDI datasource.
<Resource name="jdbc/ged" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/ged"> <parameter><name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter> <parameter><name>username</name><value>scott</value></parameter> <parameter><name>password</name><value>aaaa</value></parameter> <parameter><name>driverClassName</name> <value>oracle.jdbc.driver.OracleDriver</value></parameter> <parameter><name>url</name> <value>jdbc:oracle:thin:@xxx.yyy.zz:1521:AEI</value></parameter> <parameter><name>maxActive</name><value>3</value></parameter> <parameter><name>maxIdle</name><value>2</value></parameter> <parameter><name>maxWait</name><value>10000</value></parameter> <parameter><name>removeAbandoned</name><value>true</value></parameter> <parameter><name>removeAbandonedTimeout</name><value>60</value></parameter> </ResourceParams> How can I be tested the pool of connections is working correctly, in other words, if my new requests of connections are being assisted by the pool instead of happening the creation of new connections? Sebastião Carlos Santos Oracle Database Administrator - OCP DBA 8i Universidade Federal de Uberlândia - UFU Gratificação de Estímulo à Docência - GED --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]