Hi jonathan and angelo, thanks for the pointer. I'll try it this evening.
On Mon, Jan 12, 2009 at 10:51 AM, Jonathan Barker <jonathan.theit...@gmail.com> wrote: > 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tapestry.apache.org For additional commands, e-mail: users-h...@tapestry.apache.org
