Connections and Connection Pools

From: flarosa (frank_at_franklarosa.com)
Date: 01/05/05

  • Next message: Joe Weinstein: "Re: Connections and Connection Pools" 
    Date: 5 Jan 2005 14:36:02 -0800

    Suppose I get a connection from a connection pool, and during my use of
    the connection it goes bad (say, the socket it's using to talk to the
    database breaks). When I return that connection to the connection pool,
    will the pool realize it's bad and not reuse it?

    Similarly, what if I return a connection with an open transaction? Will
    the pool roll back or commit the transaction before giving it out to
    someone else?

    I realize that the answer depends on the connection pool
    implementation, I'm just looking for what I can generally expect with a
    modern commercial implementation (say, JBoss and Oracle using Oracle's
    JDBC drivers). Thanks.

    Frank

  • Next message: Joe Weinstein: "Re: Connections and Connection Pools"

    Relevant Pages

    • RE: Connection pooling
      ... Connection Pooling with SQL Server 2000 Analysis Services ... the Microsoft XML for Analysis Provider to develop scalable client and Web ... applications for Microsoft SQL Server 2000 Analysis Services. ... Balancing and Shrinking the Connection Pool ...
      (microsoft.public.sqlserver.programming)
    • Re: SQL Compact Edition - Connection Pool --> Slow!
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ... about the connection pool for Compact Edition 3.1. ...
      (microsoft.public.sqlserver.ce)
    • Re: SQL Compact Edition - Connection Pool --> Slow!
      ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ... about the connection pool for Compact Edition 3.1. ...
      (microsoft.public.sqlserver.ce)
    • Re: ASP.NET SQL Processes
      ... Microsoft Online Support ... when we use the ADO.NET's connection ... | connection pool, when we create SqlConnections, the ADO.NET will retrieve ... | | SQL server doesn't keep any processes attached to the application. ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Db connexion mode ???
      ... the Connection pool is created ... Hitchhiker's Guide to Visual Studio and SQL Server ... create 5 different connection string that will be aplce in the pool ( ...
      (microsoft.public.sqlserver.connect)