Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc 2 pool size

 
Dave Liu
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Greetings,
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
ocpds.setUser("myUserName");
ocpds.setPassword("myPassword");

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

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

Thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic