Hi Mark, Yes, the code is wrapped by a try , catch, finally block but still we r facing suspended connections.. :(
am using MysqlFront to administer the dbs and i can kill the suspended/delayed processes manually.. Does mysqladmin provide any other additional services?? thnx, sands -----Original Message----- From: Mark Matthews [mailto:mark@;mysql.com] Sent: quinta-feira, 17 de Outubro de 2002 13:05 To: Sandeep Murphy Cc: [EMAIL PROTECTED] Subject: Re: MySQL processes.. Sandeep Murphy wrote: > hi, > > I have a problem with the connections and would appreicate a lot if anyone can >provide a soln.. > > Our JSP application has connections to both Oracle and MySQL... In each page there >are nearly a dozen queries executing on a MySQL db. at the begining of each page, a >connection is opened and at the end they are close.. Ideally, if the user waits for >the page to load completely and then hit the button Next or Cancel, the connection is >freed.. > > But what happens often is that soon after entering the page, many users just click >on Next resulting in the connection not getting closed...and soon, the no of >connections exceed the allotted number (because they dont get freed automatically) >and thus crashes the application.. Wrap your code with a try/finally{} block, and in the finally block, put your connection.close(). It will always get called, no matter whether or not the user clicks "next". > My question is this: Is there anyway to kill the processes in MySQL (ofcourse i can >do it manually but am talking about real time) ??? > mysqladmin will let you kill threads. -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mark Matthews <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA <___/ www.mysql.com --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
