c3p0 « mysql « Java Database Q&A

1. Named pipes versus TCP for JDBC-MySQL in Windows    stackoverflow.com

I've been having numerous connection problems between my Java (JPA+Hibernate+CommonsDBCP) app connecting to MySQL. I've done the research, tweaked all the settings with validation queries, timeouts, tests before X, etc. This path ...

2. c3p0 database pool errors    stackoverflow.com

I'm getting the following exception after my program runs for 30 minutes or so with 3cp0 as my connection pool. here's the error:

   [java]  INFO [Timer-0] (BasicResourcePool.java:1392) - ...

3. java c3p0: how can i configure autoreconnect=true?    stackoverflow.com

I'm writing a red5 application using Java and I'm using the c3p0 for the database interaction. It seems that after the connection as timed out in my MySQL server my application stops working ...

4. C3P0 + MySQL : Got an error reading communication packets    stackoverflow.com

An error many have experienced is related with the message:

[Warning] Aborted connection 38 to db: 'database_name' user: 
'root' host: 'localhost' (Got an error reading communication packets)

5. Is C3P0 thread-safe?    stackoverflow.com

An interruption exception (java.lang.InterruptedException) occurs as I'm trying to perform some simple read (SELECT) operations using C3P0 on a MySQL database. The exception occurs as I increase the number of parallel ...

6. Example of a good 'middle-of-the road' c3p0 configuration for MySQL?    stackoverflow.com

i am trying to use c3p0 in my current Spring based application. I am no database pooling expert and was wondering if there is a more or less a good example ...