Questions tagged [c3p0]

c3p0 is a Java library for JDBC drivers with JNDI-bindable DataSources, including DataSources that implement Connection and Statement Pooling, as described by the jdbc3 spec and jdbc2 std extension.

C3p0

C3p0 is an easy-to-use library for augmenting traditional (DriverManager-based) JDBC drivers with JNDI-bindable DataSources, including DataSources that implement Connection and Statement Pooling, as described by the jdbc3 spec and jdbc2 std extension.

A common use case for c3p0 is to replace the standard DBCP connection pooling included with Apache Tomcat. Often times, a programmer will run into a situation where connections are not correctly recycled in the DBCP connection pool and c3p0 is a valuable replacement in this case.

References

1148 questions
-1
votes
1 answer

c3p0 unreturnedConnectionTimeout not throwing exception

We have a service that uses c3p0 library and we have added this property unreturnedConnectionTimeout to make sure unreturnedconnections are getting timed out but apparently c3p0 is not throwing exception but just printing exception stack trace when…
-1
votes
1 answer

Slowness in reading the large ResultSet

I'm having problems in generating a report the result reaches more than 500,000 lines. Believe me, this result is already filter. The query (DB2) runs almost instantly, but the the interaction in resultSet is absurdly slow. I'm doing several tests…
Luiz Paulo
  • 189
  • 1
  • 1
  • 6
-1
votes
1 answer

Apache pauses unexpectedly to make a request

After running the web application for a day, the login load properly but don't work. The log show a tomcat pause in the moment of request. I'm using: Spring 3 c3p0 MySql and Tomcat 7 The log is as follows: Jan 06, 2014 9:56:18 PM…
Deoxyseia
  • 1,359
  • 18
  • 29
-1
votes
1 answer

c3p0 connection pooling not supporting 20 users

we are using c3p0 connection pooling in our web-application( QTI based Online Examination System ), the problem is we are unable to support more than 18 simultaneous users, for 19th user server takes lots of time to give response. We have tried with…
atul
  • 1
-1
votes
2 answers

Spring + c3p0 + postgres

I am using Spring 3.0.5.RELEASE and Postgres 9.1. I am limiting a maximum number of connections in 17:
fernandosc
  • 20
  • 6
-2
votes
1 answer

C3p0 API for connection pooling

I found that c3p0 connection pooling Everytime creating new object for connection for example suppose I have pool of 5 connection and when I getting a connections from pool after using that close that connections then again getting connections each…
-2
votes
1 answer

Tomcat multiple Apps, ehcache wont work

I have startet multiple Identical Apps in Tomcat (They display different content but the code is the same). These Apps use Hibernate and ehcache. The Problem is: A singel Application works as expected. but adding a second one will make everything…
Mr.H.
  • 965
  • 1
  • 10
  • 18
-5
votes
1 answer

Should pooled JDBC connections using prepared statements be short-lived or long-lived?

Is it better to wrap a connection tightly around a SQL operation or let a connection persist through the application, if the connection is not a physical connection but an abstraction that comes from a ConnectionPoolDataSource? (I'm using c3p0, for…
djechlin
  • 59,258
  • 35
  • 162
  • 290
1 2 3
76
77