I configure connection pooling on my app server, so I have no hands-on experience with c3p0.
Certainly it looks like this would work well. If it doesn't, then one more paranoid thing Abangkis can do is add hibernate.c3p0.validate=true to force checking of every connection on checkout from the pool. > -----Original Message----- > From: Angelo Chen [mailto:angelochen...@yahoo.com.hk] > Sent: Sunday, January 11, 2009 22:10 > To: users@tapestry.apache.org > Subject: Re: Connection Problem > > > Hi, > > there was a post before in this forum that solves this problem for me, but > I > can't remember the link, basically, here are the things I added and it's > running with any problem: > > <!-- pool via c3p0 which knows how to reconnect to server and does it > nicely--> > <property > name="connection.provider_class">org.hibernate.connection.C3P0ConnectionPr > ovider</property> > <property name="hibernate.c3p0.acquire_increment">3</property> > <property name="hibernate.c3p0.idle_test_period">100</property> > <!-- seconds --> > <property name="hibernate.c3p0.max_size">20</property> > <property name="hibernate.c3p0.max_statements">0</property> > <property name="hibernate.c3p0.min_size">1</property> > <property name="hibernate.c3p0.timeout">1000</property> > > I put this in hibernate.cfg.xml, that's the only file I have for > tapestry-hibernate. > > Angelo > > > > abangkis wrote: > > > > Hello, > > > > I have an application that deployed with this kind of architecture : > > > > Apache httpd server -> Glassfishv2 -> Tapestry -> Tapestry-Hibernate -> > > Mysql. > > > > And every 8 Hour or So, i've got a broken pipe error message. > > > > I've tried following this guide > > http://www.codefin.net/2007/05/hibernate-and-mysql-connection- > timeouts.html, > > but it didn't seems to work. Any other idea what kind of configuration > > i should tweak in order for this not to happened ? > > > > the software versions are : > > > > Apache 2.2.8 > > Sun Java System Application Server 9.1 (build b58g-fcs) > > Tapestry 5.0.15 > > Mysql 5.0.51a-3ubuntu5.4 > > > > Cheers , > > > > Abangkis > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org > > For additional commands, e-mail: users-h...@tapestry.apache.org > > > > > > > > -- > View this message in context: http://www.nabble.com/Connection-Problem- > tp21393799p21407688.html > Sent from the Tapestry - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org > For additional commands, e-mail: users-h...@tapestry.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org For additional commands, e-mail: users-h...@tapestry.apache.org
