Re: connection pool problem using in Tomcat

grantmitchell7_at_yahoo.com
Date: 09/01/04 

Date: 1 Sep 2004 09:56:21 -0700

CarbinoS@online.microsoft.com ("Carb Simien [MSFT]") wrote in message news:<zzuzMF7jEHA.2516@cpmsftngxa10.phx.gbl>...
>
> If you are using SelectMethod=direct, then it is possible that you are
> seeing an increase in connections due to the creation of cloned
> connections. These additional connections are necessary because each
> statement requires its own connection. Your Tomcat settings have no
> bearing on this particular behavior, as it is inherent in the JDBC driver
> itself.
>
> Are you using transactions in your code? Can you provide code that
> reproduces the problem behavior?
>
> Carb Simien, MCSE MCDBA MCAD
> Microsoft Developer Support - Web Data
>
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Are you secure? For information about the Strategic Technology Protection
> Program and to order your FREE Security Tool Kit, please visit
> http://www.microsoft.com/security.

This is a little scary isn't it? If I have a J2EE app that starts out
pre-preparing (for subsequent re-use) N prepared statements per
connection and I have M concurrent clients using the app then we'll
require N*M physical database connections. Is that correct? That
number could be pretty huge for even a mid size app..

Is there any plans to address this in any future driver?

Grant M

Relevant Pages

  • Re: ADO Connections - close them or keep them open?
    ... N-Tier Applications. ... VB - global to all the forms that the user might call up in the app - I ... you likely will run out of connections quickly and requests will start ... Yes Access connectivity to a SQL Server DB can be downright crippling. ...
    (microsoft.public.sqlserver.server)
  • Re: .net IDE Shuts Down during a build
    ... I did not get to try your solution coz .. ... Shut down the IDE ... Then envoke the web app from the browser, then open the IDE, then ... > which you can re-enable the network connections and the IDE seems to be OK ...
    (microsoft.public.vsnet.ide)
  • Re: Tomcat cant connect to MySQL
    ... rarely, the app is able to recover, and if all connections have leaked, ... MySQL is still running because other apps can hit the same ... Tomcat & Apache are both still running ...
    (comp.lang.java.programmer)
  • Re: Created on Access 2003, but.......................
    ... The database is read by the users of it via ASP web pages. ... host allows for both types of connections. ... The app just has to make sure that it doesn't bring over any extraneous data, as any client-server app should do. ...
    (comp.databases.ms-access)
  • Re: High CPU usage
    ... There were about 4 app servers connecting to database in 9i. ... more connections. ... servers which is around 160 but still we are facing high cpu usage. ...
    (comp.databases.oracle.server)
Loading