I noticed this behavior with 3.0.14. This _really_ sounds like this entry in the Hibernate FAQ to me:
http://www.hibernate.org/117.html#A13 I wouldn't use DBCP though as Gavin King is apparently fed up with it, and built-in support for it is being yanked in the next major version of Hibernate. > -----Original Message----- > From: Marco Mistroni [mailto:[EMAIL PROTECTED] > Sent: Friday, July 30, 2004 5:08 AM > To: 'Struts Users Mailing List' > Subject: RE: OT/ Tomcat, Hibernate and MYSQL problem > > > Hello, > If I remember correct, mysql connector 3.0.11 > > Regards > marco > > -----Original Message----- > From: Mark Lowe [mailto:[EMAIL PROTECTED] > Sent: 30 July 2004 09:36 > To: Struts Users Mailing List > Subject: Re: OT/ Tomcat, Hibernate and MYSQL problem > > Marco > > What jdbc driver are you using? > > They was a shady version 3 behaving like this. > > > On 30 Jul 2004, at 10:05, Joe Hertz wrote: > > > Hibernate's internal connection pooling isn't meant for production > > because it does things just like that. > > > > Suggest you use c3p0 for the pooling. > > > >> From my hibernate.cfg.xml, I only had to add this: > > > > <property name="c3p0.minPoolSize">5</property> > > <property name="c3p0.maxPoolSize">20</property> > > <property name="c3p0.timeout">1800</property> > > <property name="c3p0.max_statement">50</property> > > > > HTH > > > > -Joe > > > > > >> -----Original Message----- > >> From: Marco Mistroni [mailto:[EMAIL PROTECTED] > >> Sent: Friday, July 30, 2004 3:58 AM > >> To: 'Struts Users Mailing List' > >> Subject: OT/ Tomcat, Hibernate and MYSQL problem > >> > >> > >> Hello, > >> > >> First of all, I apologize for the off topic issue.. > >> I know this is not the list, but I tried hibernate forums, and > >> Searched the web with no solution.. hopefully some of u > had the Same > >> problem and solved it.. > >> > >> > >> I m experiencing problems with Hibernate in tomcat, > talking to mysql. > >> > >> My situation is that I didn't define any connection pools > in tomcat, > >> but left it to Hibernate to handle that... > >> > >> After leaving the application running for 11 hours, I got > following > >> exception > >> > >> hi all, > >> i have a webapp taht uses Hibernate and MYSQL, running on top of > >> tomcat. > >> > >> i am letting Hibernate handle the connections to mysql db, since i > >> have no connection pools defined in tomcat. after running the > >> application for nearly 9 hours, when i tried to use my app > to connect > >> to the database i got following exception: > >> > >> Caused by: net.sf.hibernate.JDBCException: Could not > execute query at > >> net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1476) > >> at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:45) > >> at com.myapp.hibernate.HibernatePersistenceManager.query(Hibernat > >> ePersisten > >> ceManager.java:205) > >> ... 31 more > >> Caused by: java.sql.SQLException: Communication link failure: > >> java.net.SocketException, underlying cause: Software caused > connection > >> abort: recv failed > >> > >> ** BEGIN NESTED EXCEPTION ** > >> > >> java.net.SocketException > >> MESSAGE: Software caused connection abort: recv failed > >> > >> STACKTRACE: > >> > >> java.net.SocketException: Software caused connection abort: recv > >> failed > >> > >> > >> > >> now i have searched the web and found two possible > alternatives.. one > >> was to add following problems to hibernate config file.. <property > >> name="connection.autoReconnect">true</property> > >> <property name="connection.autoReconnectForPools">true</property> > >> <property > >> name="connection.is-connection-validation-required">true</property> > >> > >> > >> but this does not work, as ihave added thos eproperties to > hibernate > >> properties file and i am still getting same exception > >> > >> > >> then I tried to add ?autoReconnect=true to JBDC URL, but > that didn't > >> work either coz I left application running for 11 hours and after > >> that I got same exception... > >> > >> can anyone help me out? > >> > >> THANX in advance and regards > >> marco > >> > >> > >> > >> l: [EMAIL PROTECTED] > >> > >> > >> > --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
