Opened and closed in doGet( ).
Opened in beginning, and closed once the HTML has been generated (from
database query) to be displayed.
The servlet basically generates a report that is displayed as an HTML
table.
The connection is just a local variable. I don't store it in the session
or anything.
The problem is that it takes about a minute for the report to be generated.
If the user hits the "stop" button in browser before the HTML is returned,
the connection never gets closed.
Adrian Janssen
<ajanssen@TRUWORTHS. To:
[EMAIL PROTECTED]
CO.ZA> cc:
Sent by: "A mailing Subject: Re: Database connections
when user hits "stop" in
list for discussion browser..(in)
about Sun
Microsystem's Java
Servlet API
Technology."
<SERVLET-INTEREST@JA
VA.SUN.COM>
07/18/2002 08:37 AM
Please respond to "A
mailing list for
discussion about Sun
Microsystem's Java
Servlet API
Technology."
when do you open your connection, and when do you close, and where do you
store it for the duration of its existance?
> -----Original Message-----
> From: Jeremy W. Redmond [SMTP:[EMAIL PROTECTED]]
> Sent: 18 July 2002 02:13
> To: [EMAIL PROTECTED]
> Subject: Database connections when user hits "stop" in browser..(in)
>
> I couldn't find an answer to this question in archives. Maybe there is
no
> solution.
>
> In testing I have noticed that if a user runs a servlet that does some
> database access and hits "stop" (the X in IE for example) while the
> database connection is still open, then the database connection remains
> open. This will eventually cause problems if we have 100+ users and say
> 25% of them do this often.
>
> Is there anyway for me to clean these up on a regular basis?
> Better yet, can I somehow close the connection right away?
>
> Since the connection is established in the servlet's doGet( ) method,
> connections will keep being opened.
>
> Thanks in advance for any advice.
>
>
__________________________________________________________________________
> _
> 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
--
It is the strict policy of Truworths that its e-mail facility and all
e-mail communications emanating therefrom, should be utilised for
business purposes only and should conform to high professional and
business standards. Truworths has stipulated certain regulations in
terms whereof strict guidelines relating to the use and content of
e-mail communications are laid down. The use of the Truworths e-mail
facility is not permitted for the distribution of chain letters or
offensive mail of any nature whatsoever. Truworths hereby distances
itself from and accepts no liability in respect of the unauthorised
use of its e-mail facility or the sending of e-mail communications
for other than strictly business purposes. Truworths furthermore
disclaims liability for any unauthorised instruction for which
permission was not granted. Truworths Limited accepts no liability
for any consequences arising from or as a result of reliance on this
message unless it is in respect of bona fide Truworths business for
which proper authorisation has been granted.
Any recipient of an unacceptable communication, a chain letter or
offensive material of any nature is requested to notify the Truworths
e-mail administrator ([EMAIL PROTECTED]) immediately in order that
appropriate action can be taken against the individual concerned.
___________________________________________________________________________
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
___________________________________________________________________________
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
