How to close database connections.

[V.T.R.Ravi Kumar]

Hi friend,   I have some web reports developed which accesses my database and displays the result as a webpage. The thing is if due to some reason the query got stuck and caused delay then if the user closes the window the connection remained unclosed.  Although i have set time out in the database server . I would like to know if the server could sense if the sessions has been closed and close their database connection.     thanks     ----------------------------------------------------         V.T.R.Ravi Kumar Engineer,CCX,BHEL, Haridwar Phone : Office-91-01334-285260              Res  -91-01334-226121 -----------------------------------------------------