Tomcat Connection Pooling

Mon, 29 Nov 2004 02:21:14 -0800 

Hey

I have within my server.xml the following:

    <Resource name="jdbc/postgres" auth="Container"
              type="javax.sql.DataSource"/>

    <ResourceParams name="jdbc/postgres">
      <parameter>
        <name>factory</name>
        <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
      </parameter>

      <parameter>
        <name>driverClassName</name>
        <value>org.postgresql.Driver</value>
      </parameter>

      <parameter>
        <name>url</name>
        <value>jdbc:postgresql://penguin.kent.ac.uk:5432/rms_dev</value>
      </parameter>

      <parameter>
        <name>username</name>
        <value>rms_dev</value>
      </parameter>

      <parameter>
        <name>password</name>
        <value>isi5gi</value>
      </parameter>

      <parameter>
        <name>maxActive</name>
        <value>20</value>
      </parameter>

      <parameter>
        <name>maxIdle</name>
        <value>10</value>
      </parameter>

      <parameter>
        <name>maxWait</name>
        <value>-1</value>
      </parameter>

    </ResourceParams>

And I also have the relevant ResourceLink information to get this working. And it does work within my web application.

However I want to ensure that this is actually a connection pool. I want to test to see how many connections are in the pool, is there a way? Or can someone tell me for sure if I have set connection pooling up?

Thanks

Rich

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to