I guess you would need to test it out. Make a program which in a loop uses JNDI to get a connection, but doesn't close it.
I guess you would need to set removeAbandoned to false though, if your test program doesn't hold a reference to every connection that it obtains. Hope that helps, Tarun On Sat, 2003-03-08 at 17:34, =?us-ascii?Q?=22Sebasti=E3o_Carlos_Santos=22?= wrote: > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
