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: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>