DBCP Question

[Amitabh Dubey <du...@petris.com>]

Hello all,
   if i do not specify any factory in my server.xml, i believe that tomcat
uses DBCP by default. This is fine, but I have a few questions.

This is what my server.xml looks like

  <ResourceParams name="SQLServerDS">
      <parameter>
        <name>validationQuery</name>
        <value></value>
      </parameter>
      <parameter>
        <name>user</name>
        <value>sa</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>5000</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>5</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>sa</value>
      </parameter>
      <parameter>
        <name>url</name>

<value>jdbc:microsoft:sqlserver://dnas07:1113;DatabaseName=Northwind</value>
      </parameter>
      <parameter>
        <name>driverClassName</name>
        <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>10</value>
      </parameter>
    </ResourceParams>

If this file is correct, then why do i see the number of connections to the
database go more than 10, when maxActive is 10?

Does the driverClassName have to be a DataSource or is the above correct?

In my client code, after i lookup the name, do i have to cast my DataSource
to a ConnectionPoolDataSource?

Any kind of help would be great.

Thanks
Amitabh


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>