connection pool problem using in Tomcat

From: kaicall (kaicall_at_discussions.microsoft.com)
Date: 08/28/04 

Date: Fri, 27 Aug 2004 21:55:03 -0700

I use "SQL Server 2000 Driver for JDBC SP3" to connect SQLServer2000 under
Tomcat App server.
 
I wish to control the number of physical connections made to the database to
50. Can somebody guide me about this.

At the moment even with as low as 30 concurrent hits we see a very high
number of phyiscal connection to the database as high as 200.
I am using the following settings in SERVER.XML
<Resource name="jdbc/ECTDB" auth="Container"
        type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"/>
<ResourceParams name="jdbc/ECTDB">
<parameter><name>maxActive</name><value>30</value></parameter>
<parameter><name>maxIdle</name><value>20</value></parameter>
<parameter><name>maxWait</name><value>10000</value></parameter>
<parameter><name>factory</name><value>com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory</value></parameter>
<parameter><name>driverClassName</name><value>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</value></parameter>
<parameter><name>user</name><value>..</value></parameter>
<parameter><name>password</name><value>..</value></parameter>
<parameter><name>driverName</name><value>SQLServer</value></parameter>
<parameter><name>serverName</name><value>127.0.0.1</value></parameter>
<parameter><name>portNumber</name><value>1433</value></parameter>
<parameter><name>databaseName</name><value>..</value></parameter>
<parameter><name>selectMethod</name><value>cursor</value></parameter>
<parameter><name>loginTimeout</name><value>60</value></parameter>
</ResourceParams>

Thanks a lot

Relevant Pages

  • Re: Global datasets
    ... Sticking with the first method again. ... Populate my DataSet from the Database ... Create another control object instance ... re-instantiating it. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: instant Lisp web application publishing
    ... flow of control (e,g. first log in the user, then show page x, than ... of Lisp if they want) ... flexible database that can be easily mapped into OOP terminology (so you ... Also I don't have a good candidate server to deploy it too. ...
    (comp.lang.lisp)
  • RE: 438 - Object doesnt support this property or method
    ... I created a new database and imported everything from the original. ... Missing is the Reference to the EzFTP control. ... Set con = Application.CurrentProject.Connection ...
    (microsoft.public.access.formscoding)
  • Re: Communication Log
    ... May I send you copy of the database that I made? ... a communication log in the database so that it will store the Date, ... ContactMethodID ... The above controls are set up in a page using te tab control. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Communication Log
    ... May I send you copy of the database that I made? ... a communication log in the database so that it will store the Date, ... ContactMethodID ... The above controls are set up in a page using te tab control. ...
    (microsoft.public.access.tablesdbdesign)
Loading