aspose file tools*
The moose likes JDBC and the fly likes Setting Pool Size in Oracle Connection Pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Setting Pool Size in Oracle Connection Pool" Watch "Setting Pool Size in Oracle Connection Pool" New topic
Author

Setting Pool Size in Oracle Connection Pool

Sameer Amte
Ranch Hand

Joined: Oct 22, 2002
Posts: 38
Hi,
I am using JDBC 2.0 and Oracle Thin driver.
I have successfully used the Oracle Connection
Pooling API to set up Pooled connection.
However,I there does not seem to be any API to
set the Pool size.
Does anyone have any idea.
Kevin Mukhar
Ranch Hand

Joined: Nov 28, 2000
Posts: 83
Is this what you are looking for?
http://download-west.oracle.com/docs/cd/B10501_01/java.920/a96654/connpoca.htm#1065200
Chiang Guo
Greenhorn

Joined: Aug 06, 2002
Posts: 7
you may use setMaxLimit() method on
oracle.jdbc.pool.OracleConnectionCacheImpl
class
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"cguo",
thanks for your help, we appreciate it!
But...
we have few rules at the JavaRanch, but the one that we enforce is the Naming Policy. Please change your display name to comply, since accounts with invalid display names get deleted.
thanks,
Dave
[ February 05, 2003: Message edited by: David O'Meara ]
 
jQuery in Action, 2nd edition
 
subject: Setting Pool Size in Oracle Connection Pool