locked
how can i kill the mysql connection ? RRS feed

  • Question

  • User-1109719307 posted

    When i Connect to the mysql database there is one process created and when the query gets executed then the mysqlconnection thread remains sleeping..

    i want to kill that sleeping thread....

    how can i do this thing??

    Tuesday, August 30, 2011 1:06 PM

All replies

  • User197322208 posted

    do you use

    using( connection...)

    {

    //execute query

    }

    ?

    Tuesday, August 30, 2011 11:26 PM
  • User-1109719307 posted

    no sir. 

    i am not using this code...

    Wednesday, August 31, 2011 9:42 AM
  • User197322208 posted

    so please use ;-)

    Wednesday, August 31, 2011 9:51 AM
  • User-1109719307 posted

    sir i tried the way you told by "using" 

    but thread doesn't gets killed...

    Wednesday, August 31, 2011 11:51 AM