0

Currently Im looking for a library which provide connection pooling for JDBC. My application is a real-time one. So the connection pooling should support high concurrency. And I also want it to support for both MySQL and Oracle. I looked in to Apache DBCP,and Tomcat JDBC Connection Pool. But it seems they wont suit for my requirement. Is there any other options available?

nath
  • 2,848
  • 12
  • 45
  • 75
  • 3
    Please tell us which aspects of Apache DBCP and Tomcat JDBC Connection Pool make them unsuitable for your needs. – APC Sep 14 '11 at 09:03
  • Also, a jdbc connection pool is never specific to any database. They are in general for any database as long as its JBDC driver is available. – Santosh Sep 14 '11 at 10:03
  • http://vigilbose.blogspot.com/2009/03/apache-commons-dbcp-and-tomcat-jdbc.html http://stackoverflow.com/questions/520585/connection-pooling-options-with-jdbc-dbcp-vs-c3p0 – Samir Mangroliya Sep 14 '11 at 09:01
  • Here is list of available connection pool libs http://java-source.net/open-source/connection-pools – Santosh Sep 14 '11 at 10:04

1 Answers1

1

You can look at the Oracle Universal Connection Pool. It was reviewed here though: How good is Oracle Universal Connection Pool (UCP).

I've used it before connecting to both Oracle and MySQL instances on large server farms in a large scale multithreaded application and it performed okay, no different that with Apache DBCP.

Community
  • 1
  • 1
Joe
  • 1,013
  • 13
  • 20