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]
