Hi guys, just want to give an update. My problem has been solved, i've been leaving it for days and there's no connection problem.
in my case, the problem was I'm missing this one line : <property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property> and the real c3p0-0.9.1.jar file. Since in development , using hibernate-c3p0-3.3.1.GA.jar is enough. Hope this can help anyone with the same problem. cheers, abangkis. On Mon, Jan 12, 2009 at 10:26 PM, abangkis <abang...@gmail.com> wrote: > 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
