-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Kees Jan,
On 8/7/2009 12:44 PM, Kees Jan Koster wrote: > I have to restart Tomcat regularly because it exhausted my MySQL > connections. Show processlist confirms the problem. > > I use Hibernate. Do you? No, I just use straight JDBC in all my code. I abandoned OR mappers a long time ago because they forced me to deal with data from tables individually. Since MySQL didn't have VIEWs until recently, and I've been primarily using only MySQL for development, I just write all my SQL queries myself these days. > I'll dig deeper later when I have more time. I wonder if you have ResultSet or Statement objects that aren't closed. Next time you do a lot of restarts, run jmap to see if there are any "live" JDBC objects still laying around (other than java.sql.Connection, of course). - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAkp8fvwACgkQ9CaO5/Lv0PCYMgCfVHrktFh6N4CKBh9Gf1PXPTJ1 bH4AoJalpc4+D0pVQeV+CsE/IPZ+BXbi =i/MV -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org