Hello Boris. I have added hibernate-c3p0 ver. 3.3.1-GA.jar to my lib folder. May that be the issue of the following? Should I go for 3.6.10.Final?
> From: horvat.z.bo...@gmail.com > Date: Sat, 10 Aug 2013 16:44:10 +0200 > Subject: Re: Issue with cannot open connection > To: users@tapestry.apache.org > > Did you check to see if c3p0 is present in your pom? As far as I recall you > need to manually add it > > <dependency> > <groupId>org.hibernate</groupId> > <artifactId>hibernate-c3p0</artifactId> > <version>3.6.10.Final</version> > </dependency> > > I recall having the similar problem and my solution was to add this (since > this is not included by tapestry/hibernate by default) > > > > On Sat, Aug 10, 2013 at 2:56 PM, Nomen Nominus <geribi...@outlook.com>wrote: > > > Here is my problem. I have a very classical configuration where a webapp > > > > with some Hibernate code in it accesses a MySQL DB. Everything is > > > > installed in Tomcat 6. > > I even acquired c3p0 connection pooling with the following configuration: > > > > <?xml version="1.0" encoding="UTF-8"?> > > > > <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate > > Configuration DTD//EN" > > "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd";> > > <hibernate-configuration> > > > > <session-factory> > > > > <!-- Settings for MySql DB --> > > > > <property > > name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> > > > > <property > > name="hibernate.connection.url">jdbc:mysql://localhost:3306/myDB?autoReconnect=true</property> > > <property name="hibernate.connection.username">myUsername</property> > > > > <property name="hibernate.connection.password">myPass</property> > > > > <property > > name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property> > > <property name="dialect">org.hibernate.dialect.MySQLDialect</property> > > <property name="hibernate.connection.pool_size">5</property> > > <property name="show_sql">true</property> > > > > <property name="hibernate.c3p0.idle_test_period">1800</property> <!-- > > In seconds --> > > > > <property name="hibernate.c3p0.min_size">5</property> > > > > <property name="hibernate.c3p0.max_size">20</property> > > > > <property name="hibernate.c3p0.timeout">2400</property> > > <property name="hibernate.c3p0.max_statements">50</property> > > > > </session-factory> > > > > </hibernate-configuration> > > > > After some time, ( around 60 secs ) Hibernate complains about dropped > > connections, the > > > > error message looks like this : > > > > com.mysql.jdbc.CommunicationsException : Communications link failure The > > > > last packet successfully received from the server was > > milliseconds ago. The last packet sent successfully to the server was 0 > > > > milliseconds ago. > > > > java.io.EOFException : Can not read response from server. Expected to > > > > read 4 bytes, read 0 bytes before connection was unexpectedly lost. > > > > > > Refeshing the page once or twice usually fixes the problem. > > > > > > Has anyone else encountered on this issue before, and if so, please help > > me. What could be possible solution to this resolution? > > > > Thanks in advance. > > > > > > > > > > > -- > Sincerely > *Boris Horvat*
