It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes jdbc 2 pool size Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc 2 pool size" Watch "jdbc 2 pool size" New topic

jdbc 2 pool size

Dave Liu

Joined: Mar 06, 2001
Posts: 2
Back in the JDBC 1.0 days, you write your own pool and you can do what ever you want. With the JDBC2.0 everything is done for you, but I can't see to find any methods on setting pool size.
BTW. My current project dose not deal with J2EE, so all the EJB stuff doesn't really apply.
For example here is a code segment. What do I do if I want the max pool size to be 30?
import oracle.jdbc.driver.*;
import oracle.jdbc.pool.*;
* Makes a connection to the database
public class ConnectionManager {
private static ConnectionManager instance = new ConnectionManager();
Connection connection = null;
OracleConnectionPoolDataSource ocpds = null;
PooledConnection pc = null;
String tdbStr = "jdbcracle:thin:@myServer:1973:blah1";
private ConnectionManager()
try {
// Create a OracleConnectionPoolDataSource instance
ocpds = new OracleConnectionPoolDataSource();
ocpds.setURL( tdbStr ); // Set connection parameters

pc = ocpds.getPooledConnection(); // Create a pooled connection

connection = pc.getConnection(); // Get a Logical connection
catch (java.sql.SQLException e) {
System.exit (-1) ;
public static ConnectionManager getInstance() {
return instance;
public Connection getConnection() {
return connection;

I agree. Here's the link:
subject: jdbc 2 pool size
It's not a secret anymore!