you can limit the time a Statement will take to execute with: Statement.setQueryTimeout(int seconds)
Then you can continue with closing the connection, etc. HTH, -- Becky Norum Database Administrator Center for Subsurface Sensing and Imaging Systems (CenSSIS) Northeastern University http://www.censsis.neu.edu On Tue, 2003-03-25 at 23:10, V.T.R.Ravi Kumar wrote: > 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 > ----------------------------------------------------- ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
