Configure JDBC Connection Pool size
From: geossl (geossl_at_discussions.microsoft.com)
Date: 08/09/04
- Next message: sheongperk: "Re: Parameterized query ( with bind parameters ) running much slower than non-parameterized"
- Previous message: Pete Loveall: "Re: updateRow() Fails"
- Next in thread: Carb Simien [MSFT]: "RE: Configure JDBC Connection Pool size"
- Reply: Carb Simien [MSFT]: "RE: Configure JDBC Connection Pool size"
- Messages sorted by: [ date ] [ thread ]
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");
- Next message: sheongperk: "Re: Parameterized query ( with bind parameters ) running much slower than non-parameterized"
- Previous message: Pete Loveall: "Re: updateRow() Fails"
- Next in thread: Carb Simien [MSFT]: "RE: Configure JDBC Connection Pool size"
- Reply: Carb Simien [MSFT]: "RE: Configure JDBC Connection Pool size"
- Messages sorted by: [ date ] [ thread ]