Re: Too many connections (again) (could Mark answer this please)

["Mark Matthews" <mmatthew@xxxxxxxxxxxxxxx>]

I've answered this twice, both in personal e-mails, but I'll answer it
again, one last time :).



Three things, First, you're using an old version of the driver. Please
upgrade to the latest (you should do this when you suspect it might be the
driver. Always check http://mmmysql.sourceforge.net/ as this is
_the_only_official_ MM.MySQL download site. I can't vouch for anything you
download from somewhere else).



Second, you are not closing your connections in finally{} blocks, so you can
not guarantee that they are being closed! Many browsers terminate the
connection to the servlet/JSP early (IE for example), which can cause code
you think should be executing not to execute. You should _always_ get rid of
expensive resources in a finally{} block to make sure that it actually
happens.



Third, please subscribe to the java@xxxxxxxxxxxxxxxx This forum is not the
correct place to ask these types of questions, and I only get it in digest
mode, so it takes me a while to read/get back to people who ask JDBC
questions in the mysql list.



    -Mark



----- Original Message -----

Message-ID: <000701c17707$7d6a7610$7300a8c0@yilmaz>

From: "yilmaz" <yilmaz@xxxxxxxxxxxxx>

To: <mysql@xxxxxxxxxxxxxxx>

Subject: Re: Too many connections (again) (could Mark answer this please)

Date: Tue, 27 Nov 2001 13:50:59 +0800

MIME-Version: 1.0

Content-Type: text/plain;

charset="iso-8859-1"

Content-Transfer-Encoding: 7bit

Me , too, have the same problem.

it seems that every opened page establishes a connection but

those connections can't be closed, although i explicitly close in my code

I posted a message related with this problem a few days ago,

unfortunately couldn't get a satisfying answer. So, i request from Mark

Matthew

to help us with this problem , since he is the author of Mysql.

(my Mysql version is 3.23 , i use jdbc through tomcat 4 b7, on win 2000.)

Thanks in advance

cheers



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread92352@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php