Do I need to use C3P0 pooling library in my (grails) web application?

Posted by fabien7474 on Stack Overflow See other posts from Stack Overflow or by fabien7474
Published on 2010-05-10T14:52:22Z Indexed on 2010/05/10 15:04 UTC
Read the original article Hit count: 343

Filed under:

grails

|

c3p0

|

connection-pooling

|

mysql

|

hibernate

Hi,

I am not familiar at all with connection pooling library. I've just discovered it through this blog article) and I am not sure that I should use one in my web application based on grails/hibernate/mysql.

So my question is simple : in which situations would you suggest to integrate a connection pooling library into a grails application? Always, Never or only over some connections threshold?

P.S. : If you have ever used successfully C3P0 in your web application, I will greatly appreciate to hear your feedback (in terms of visible positive effects).

© Stack Overflow or respective owner

Related posts about grails

Grails, app-engine, jpa - beginner having trouble with grails generate-all

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to learn about grails with Google App Engine and JPA by following a few tutorials: http://www.morkeleb.com/2009/08/12/grails-and-google-appengine-beginners-guide/ http://inhouse32.appspot.com/index.html http://grails.org/plugin/app-engine I've got grails 1.3.0 RC 2, and App Engine SDK… >>> More
Grails Warnings/Errors during run-app

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently seeing the warnings below when trying to run my Google App Engine/Grails test app in Eclipse. Warning, target causing name overwriting of name startLogging Warning: C:\Users\Some Person.grails\1.2.0\projects\test-grails\plugins\app-engine-0.8.8\grails-app\conf\spring not found. Warning:… >>> More
Grails, app-engine, jpa - TargetInvocationException

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to learn about grails with Google App Engine and JPA by following a few tutorials: http://www.morkeleb.com/2009/08/12/grails-and-google-appengine-beginners-guide/ http://inhouse32.appspot.com/index.html http://grails.org/plugin/app-engine I've got grails 1.3.0 RC 2, and App Engine SDK… >>> More
Inject log object in Grails class outside of grails-app

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a class in src/groovy in my grails project. How do i make a log field that gets injected with the correct logger for that class ? Is there a commons logging or just log4j in grails ? >>> More
grails run-war connects to mysql but grails run-war doesn't

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a unexpected problem. I had create a war with grails war. Then I had deployed in Tomcat. For my surprise the crud works fine but I don't know what persistence is using. So I did this test: Compare grails prod run-app with grails prod run-war. The first works fine, and does conect with… >>> More

Related posts about c3p0

Connection drop problem with Hibernate-mysql-c3p0

as seen on Stack Overflow - Search for 'Stack Overflow'
hi all, This is an issue which I have seen all across the web. I will bring it up again as till now I don't have a fix for the same. I am using hibernate 3. mysql 5 and latest c3p0 jar. I am getting a broken pipe exception. Following is my hibernate.cfg file. com.mysql.jdbc… >>> More
Connection pooling options with JDBC: DBCP vs C3P0

as seen on Stack Overflow - Search for 'Stack Overflow'
What is the best connection pooling library available for Java/JDBC? I'm considering the 2 main candidates (free / open-source): Apache DBCB - http://commons.apache.org/dbcp/ C3P0 - http://sourceforge.net/projects/c3p0 I've read a lot about them in blogs and other forums but could not reach… >>> More
Create 2 connection pools using c3p0 in Jetty

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I'm trying to set up a maven web project that runs Jetty. In this project, I need 2 JNDIs... my plan is to configure 2 connection pools using c3p0 in Jetty. So, I created WEB-INF/jetty-env.xml, and I have the following:- <Configure class="org.mortbay.jetty.webapp.WebAppContext"> … >>> More
c3p0 acronym origin - jdbc connection pool name

as seen on Stack Overflow - Search for 'Stack Overflow'
Can anyone share the origin and meaning of the jdbc connection pool named c3p0. Was it inspired from star wars?. >>> More
Spring configuration of C3P0 with Hibernate?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Spring/JPA application with Hibernate as the JPA provider. I've configured a C3P0 data source in Spring via: <bean id="myJdbcDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">  <property name="driverClass"… >>> More