-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Wouter,
On 5/9/2009 5:46 AM, Wouter D'Haeseleer wrote: > This means, no connections available anymore. > > And when I look at the connections itself in oracle I see that the > following connection is using more then 200 sessions ! I think Chuck is right: you're leaking connections. > <Resource auth="Container" > ... I would highly recommend adding these two attributes to your <Resource>: logAbaodoned="true" removeAbandoned="true" removeAbandonedTimeout="30" (# of seconds to wait before considering a connection "abandoned". Adjust to fit your needs) While you're at it, maybe you want to set: validationQuery="SELECT 1 FROM DUAL" (or something else appropriate to test your connections) > For me this is really strange since this connections says maxActive=10 I always recommend setting maxActive="1" in development. You'll find connection leaks REALLY quick! I'll take this opportunity to plug my own blog entry regarding proper JDBC resource management: http://blog.christopherschultz.net/?p=68 - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkoIm4YACgkQ9CaO5/Lv0PDFcgCeMcq1tf6zJM2LL50BvFfclJ/j /eQAoISCn7x1AoIxcLz32NY1XT1ZkrlT =4iKb -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org