Win a copy of Kotlin in Action this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

jdbc 2 pool size  RSS feed

Dave Liu
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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;

  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!