Hello All,
I managed to use DBCP with SQL Server and am able to get connections from
the pool. After i execute my query, i close the connection also, but it is
going back to my pool and i have verified that. However, what I do not
understand is this : Why does the pool go on increasing and never decreasing
in size. 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>url</name>
<value>jdbc:microsoft:sqlserver://dnas07:1113;DatabaseName=NorthWind</value>
</parameter>
<parameter>
<name>password</name>
<value>sa</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>3</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>120</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>5</value>
</parameter>
</ResourceParams>
If i understand the parameters correctly, then
maxActive --> Maximum number of connections allowed to the database (What
happens when this number is reached? For me i get a new connection and the
pool increases. Is this the expected behavior? Can i change it to fail or
block instead?)
maxidle --> Maximum number of idle connections that the pool should hold
(For me my pool never goes down to this limit)
maxWait --> Maximum time to wait for a dB connection to become available in
ms.
removeAbandoned --> recycle connections if the removeAbandonedTimeout is
reached and the connection is idle. in our case it is true.
removeAbandonedTimeout --> 5
If i am correct, why is my pool growing forever and not reducing in size?
Any ideas?
Amitabh
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
