Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Configure JDBC Connection Pool size

Author  Topic 

geossl
Yak Posting Veteran

85 Posts

Posted - 2004-08-06 : 03:10:21
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");

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2004-08-06 : 05:01:42
I'm no expert in the area but I was *pretty* sure that connection-pooling was an automatic process and nothing one would want to mess with...?

--
Lumbago
"Real programmers don't document, if it was hard to write it should be hard to understand"
Go to Top of Page
   

- Advertisement -