Re: Connection Pooling!!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"parez" <psawant@xxxxxxxxx> wrote in message
news:1126216419.011559.307520@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> Hi ALL!
>
> I have questions on connection pooling..
>
> 1) Is a connection pool for a DB, Application or a machine?
>
> I am using .net 1.1 and sql server 2k if that matters..
>

Each connection pool lives inside an App Domain, and in each App Domain
there is a different pool for each database (connection string).

So if you have 5 applications, each connecting to 3 different databases then
you would have 15 different connection pools.

David


.

Relevant Pages

  • Oracle Connection Pool Performance
    ... ASP.NET - DOT NET 1.1 which means a connection pool using OLEDB. ... However there are no queries ... with huge buffer gets and the oracle stats do not point to anything ... Final info Database is 8.0.5 and no not an option to upgrade that yet, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Validation query
    ... Server database and Apache Jakarta commons-dbcp ... connection pool to communicate with the database. ...
    (microsoft.public.sqlserver.programming)
  • MySQL and Cocoon
    ... I want to write some code that connects to a database from the Apache ... Cocoon servlet, to check authentication data. ... Here the problem, for me, is to write java code that reuse ... the connection pool set for other purposes. ...
    (comp.lang.java.databases)
  • Re: Generic user in web application and identification in database
    ... but we don't know wich will be the framework (struts, ADF, our own ... and as database Oracle 9i. ... I want to use an unique connection database. ... Have you thought about a connection pool per database user? ...
    (comp.databases.oracle.server)
  • Tomcat 5.5.7 - Monitoring Database Connection Pools
    ... Database: Oracle 10g ... I have set up a connection pool for my application, ... How can I monitor my database ... Can this be done by TOmcat or do I need to enable extensive ...
    (comp.lang.java.help)