hey all, I'm just getting started with c3p0 for database connection pooling. It's attaching itself to my log4j output currently. How do I set logging off or at least to SEVERE level only for c3p0? ...

Here is exception I am getting This is the configuration I am using in my c3p0 <property name="acquireIncrement">5</property> <property name="preferredTestQuery">SELECT 1<...

I have a model that has a pretty large graph of sub entities and hibernate ends up making around 9 statements to lazily fetch all of the data needed but about 4 levels deep I get a "could not initi...

I have the follow code in my JAVA program that allows me to copy data from a file into my Postgres database: Connection con = DriverManager.getConnection("jdbc:postgresql://localhost:####/myDb", ...

We had an outage event recently where the application threads got stuck while retrieving connections from c3p0. The configuration set is the following: Version of c3p0 used: 0.9.1.2 c3p0.acquir...

We have a [Hibernate + c3p0 + MySQL] config for our project. We are hitting the following exception: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a r...

I have console application that hangs during execution. Here is my configuration: cfg.setProperty("hibernate.connection.driver_class", "com.mysql.jdbc.Driver"); cfg.setProperty("hibernate.connec...

I use c3p0-0.9.5.2.jar and mchange-commons-java-0.2.11.jar to manage the pool connection, And I use postgreSql 9.3. I get these messages at least once a day in my Prod environment : Caused by: ja...

I am using Hibernate 4.3.11.Final and H2 1.3.172 database and I was profiling my application on a slow linux box and finding it was spending more time on a particular SQL INSERT then anything else....

I'm using Hibernate's c3p0 connection pooling and standard Java 1.4 java.util.logging. Upon startup, my app sets up it's logging properties (including formatter and log levels) in static block. Eve...

According to http://sourceforge.net/projects/c3p0/files/bin/ it seems that the last stable version of c3p0 was released in 2007. Isn't it abandoned project? We use it heavily and it works fine, ...

I am using Hibernate 4, PostgreSQL and C3P0. In my web application, after sometime I am getting multiple SHOW TRANSACTION ISOLATION LEVEL queries in database due to which my server gets hang. In ...

I want to configure my c3p0 connection pool so that at least 2 connections are always active, at most 5, and idle connections past the first 2 will expire in a reasonable amount of time (say an hou...

I have MySQL under my Hibernate and I am also using c3p0-0.9.1 for connection pool. When running on my laptop (I mean locally) I have no errors. But when I deploy it on the server, I get this exce...

I am using JPA and c3p0 and attempting to query a table and getting back a stack trace claiming that the table doesn't exist. I can open a connection to the db in, for example, DbVisualizer, and se...

What is the best connection pooling library available for Java/JDBC? I'm considering the 2 main candidates (free / open-source): Apache DBCP - http://commons.apache.org/dbcp/ C3P0 - http:...

I am connecting to MySQL over SSL from my Java application. I have configured MYSQL to support SSL and generated client certificates. I have imported server CA certificate and client certificate in...

Within our project, we have updated Spring to 4.3.14.RELEASE and Hibernate to 4.3.11.Final and since we have started seeing two warnings: WARN JDBC Connection to reset not identical to original...

In my project I started to use c3p0 with hibernate for reconnecting to database as hibernate won't restore connection on db failure. <dependency> <groupId>org.hibernate</groupId&gt...

I'm using C3P0 as a connection pool in Tomcat, and I'm seeing very worrying errors: 2010-09-16 13:25:00,160 [Timer-0] WARN com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async....

I have a basic Spring JDBC application with a pretty basic configuration: <bean id="myDataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> <property name="dri...

I'm using C3P0 connection pool and PostgreSQL(10.3) in AWS RDS. I did a load test at low TPS (1 TPS) for 2 minutes, after load test finished, the number of connections were not dropped according t...

I'm creating an application with Hibernate JPA and I use c3p0 for connection pooling with MySQL. I have an issue with the number of connections to the MySQL database as it hits the 152 opened conne...

I've using Hibernate ORM for a year now and c3p0 about a couple of months. I've read on web, c3p0 is a JDBC connection and statement pooling library, that enhances JDBC drivers. But, I wants to kn...

I need to establish DB connectionfailover in SpringBoot application(embedded tomcat) for ibatis with jdbctemplate which uses c3p0 for connection pooling.Below is the applicaiton.properties of my ap...