Configure JDBC Connection Pool size

From: geossl (geossl_at_discussions.microsoft.com)
Date: 08/09/04


Date: Sun, 8 Aug 2004 20:51:02 -0700

Dear All,
Using Microsoft JDBC driver, is there any way to set the min, max and
increment number of the connection in the connection pool?

Thanks.

          ds = new SQLServerDataSource();
            ds.setServerName("TestingServer");
            ds.setDatabaseName("Inventory");

            Hashtable env = new Hashtable();
            env.put(Context.INITIAL_CONTEXT_FACTORY,
               "com.sun.jndi.fscontext.RefFSContextFactory");
            env.put(Context.PROVIDER_URL, "file:C:/Java/Jdni/");

            Context ctx = new InitialContext(env);
            ctx.bind("jdbc/Inventory", ds);
            ConnectionPoolDataSource pds =
(SQLServerDataSource)ctx.lookup("jdbc/Inventory");
            PooledConnection pcon = pds.getPooledConnection("user", "passwd");


Loading