How to establish a connection pool in JDBC?

by

If you need a standalone connection pool, my preference goes to C3P0 over DBCP (that I’ve mentioned in this previous answer), I just had too much problems with DBCP under heavy load. Using C3P0 is dead simple. From the documentation:

ComboPooledDataSource cpds = new ComboPooledDataSource();
cpds.setDriverClass( "org.postgresql.Driver" ); //loads the jdbc driver
cpds.setJdbcUrl( "jdbc:postgresql://localhost/testdb" );
cpds.setUser("swaldman");
cpds.setPassword("test-password");

// the settings below are optional -- c3p0 can work with defaults
cpds.setMinPoolSize(5);
cpds.setAcquireIncrement(5);
cpds.setMaxPoolSize(20);

// The DataSource cpds is now a fully configured and usable pooled DataSource

But if you are running inside an application server, I would recommend to use the built-in connection pool it provides. In that case, you’ll need to configure it (refer to the documentation of your application server) and to retrieve a DataSource via JNDI:

DataSource ds = (DataSource) new InitialContext().lookup("jdbc/myDS");

More Related Contents:

  1. Connection pooling options with JDBC: DBCP vs C3P0 [closed]
  2. JDBC MySql connection pooling practices to avoid exhausted connection pool
  3. Closing JDBC Connections in Pool
  4. Where do I have to place the JDBC driver for Tomcat’s connection pool?
  5. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  6. Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern
  7. PreparedStatement with list of parameters in a IN clause [duplicate]
  8. Using setDate in PreparedStatement
  9. java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?
  10. java.lang.ClassNotFoundException: com.mysql.jdbc.Driver in Eclipse
  11. ResultSet exception – before start of result set
  12. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  13. Why do I get java.lang.AbstractMethodError when trying to load a blob in the db?
  14. java.sql.SQLException: Column count doesn’t match value count at row 1
  15. How often should Connection, Statement and ResultSet be closed in JDBC?
  16. How is driver class located in JDBC4
  17. Getting output from dbms_output.get_lines using JDBC
  18. JDBC ODBC Driver Connection
  19. Java – Can’t use ResultSet after connection close
  20. Timezones in SQL DATE vs java.sql.Date
  21. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  22. How do I use PostgreSQL JSON(B) operators containing a question mark “?” via JDBC
  23. MySQL connector error “The server time zone value Central European Time” [duplicate]
  24. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  25. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  26. Connection cannot be cast to oracle.jdbc.OracleConnection
  27. NoClassDefFoundError sun/io/ByteToCharConverter with InterBase JDBC driver
  28. How to connect to a remote MySQL database with Java?
  29. Postgres UUID JDBC not working
  30. How to get jdbc connection from hibernate session? [duplicate]

Leave a Comment