Hi Pat, Not closing a database connection should not run you out of memory, unless you have ALOT of traffic or no memory to begin with. Connections should time out after a period of time, if you have relinquished to reference to them. It is obviously best to close them explicitly when you are finished with them.
How long does it take before you run out of memory? I seem to recall that older versions of SUN's jdk had memory leaks when compiling JSP pages. Do you only run out of memory after new JSP pages have been loaded or existing ones have been changed? Or is this a slow leak that has some sort of predictable behavior, like it runs out of memory three days after a restart, etc... Could you give more info? Without it, we are just guessing. --Jay Gardner -----Original Message----- From: Patrick Codere [mailto:[EMAIL PROTECTED]] Sent: Monday, August 26, 2002 4:15 PM To: 'Tomcat Users List' Subject: OUT OF MEMORY ERROR Hi everyone, I have been getting this error for the past few weeks without solving the issue. But I just found out that I had forgotten to close a database connection. Could that have been the problem? Time will tell, but what exactly happens when you don't close a db connection? Thanks for your help. Pat -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>