aspose file tools*
The moose likes JDBC 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
Bookmark "jdbc 2 pool size" Watch "jdbc 2 pool size" New topic
Author

jdbc 2 pool size

Dave Liu
Greenhorn

Joined: Mar 06, 2001
Posts: 2
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: jdbc 2 pool size