78899

choose a db connection pool

Question:

we want to use a db connection pool in our applicationl,however thear are so many open soure pools,like dbcp,c3p0,proxool and etc.

I have no idea which is better,any one have some experience about them?

Answer1:

I'd recommend using the one that is built into your Java EE app server if you're using one. That's should be sufficient. Why add another dependency?

I'd recommend using DBCP from Apache. It'll work just fine for your purposes.

Answer2:

As author of BoneCP (http://jolbox.com), I invite you to have a look at the benchmark section on that site and judge for yourself.

W

Recommend

  • SocketException in tomcat7 error log
  • Runtime dependency (e.g. connection pooling) and classpath?
  • transaction timeout not working on hibernate with oracle
  • Neo4j Configuration
  • Fork/Join kill siblings/branches
  • Locking an ASP.NET application variable
  • Trying to understand SetRecycledViewPool method in RecyclerView
  • Allocation and Free in Micriμm μC/OS-III RTOS
  • How do I fix my application from leaking when using Qt 4.5?
  • apt-get install fails with Not Found error because package removed from repository
  • How Can I Prevent Recurring Automatic Connections to Oracle Database?
  • How to use connection pooling for Monetdb?
  • ASP.NET Web App using the wrong (2.0) CLR version (instead of 4.0)
  • What's wrong when I try to install ADT on Eclipse?
  • How do I check assembly output of Java code?
  • How to remove default command line arguments provided by Eclipse?
  • EJB @Schedule issue
  • How to best manage SMTP clients
  • Detect language of Word document
  • Unicorn and Rails eat up 2x MySQL connections
  • Swift iOS don't recognize GCM library imports?
  • Distributed JMS based logging .. falling flat?
  • Can long-polling be achieved in Restlet by just making the thread sleep?
  • Sensibility of combined Maven/Ant+Ivy build management for dual platform Desktop/Android deployment?
  • How do I display a dialog that asks the user multi-choice questıon using tkInter?
  • Declaring variable dynamically in VB.net
  • Exchange data b/w iOS devices using Bluetooth 4.0
  • Read text file and split every line in MSBuild
  • C# - Serializing and deserializing static member
  • Java applet as stand-alone Windows application?
  • Symfony2: How to get request parameter
  • Akka Routing: Reply's send to router ends up as dead letters
  • Is there a mandatory requirement to switch app.yaml?
  • How to format a variable of double type
  • Proper folder structure for lots of source files
  • Error creating VM instance in Google Compute Engine
  • coudnt use logback because of log4j
  • JaxB to read class hierarchy
  • Why do underscore prefixed variables exist?
  • Net Present Value in Excel for Grouped Recurring CF