This week's book giveaway is in the Agile and other Processes forum. We're giving away four copies of The Mikado Method and have Ola Ellnestam and Daniel Brolund on-line! See this thread for details.
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; } }