Re: Configure JDBC Connection Pool size

From: Ryan (rkennel_at_veng.com)
Date: 09/07/04

  • Next message: SqlJunkies User: "Re: Issue connecting through firewall using jdbc connector." 
    Date: 6 Sep 2004 19:11:34 -0700

    > The Microsoft JDBC driver doesn't implement connection pooling itself. It
    > does implement the appropriate classes to allow it to be pooled by a
    > third-party pool manager (or via your own custom connection pooling code).
    > For more information, consult the "Microsoft SQL Server 2000 Driver for
    > JDBC DataSource Implementation" section of the Knowledge Base article below:
    >
    > 313173 Sample Connection Pool Manager for Use with Microsoft SQL Server
    > http://support.microsoft.com/?id=313173
    >
    > Ultimately, you will have to control the connection pool behavior in the
    > pool manager and not in the JDBC driver itself.

    I have run into this problem also. I implemented SQL Server pooling
    using Jakarta Commons DBCP.

    http://jakarta.apache.org/commons/dbcp/

  • Next message: SqlJunkies User: "Re: Issue connecting through firewall using jdbc connector."

    Relevant Pages

    • Re: Is Connection Pool management provided?
      ... The SQL Server 2005 JDBC Driver provides support for connection pooling ... Microsoft Developer Support - Webdata ... | Subject: Re: Is Connection Pool management provided? ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Simple Connection Pooling Example from JAVA needed
      ... from what I've gathered from the jdbc driver books online sql server driver doesnt support connection pooling hence I am supposed to use javax.connectionpooling to do the pooling. ... Can anyone provide me with a clear example of the use of connection pooling with the jdbc driver, I'm sure it will help others also. ...
      (microsoft.public.sqlserver.jdbcdriver)
    Loading