Re: How to close database connections.

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