You can use the javax.servlet.http.HttpSessionBindingListener to be notified
when the Session is being invalidated and clean up the Connection.
(*Chris*)
----- Original Message -----
From: Imam, Asim, CFCTR <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 26, 1999 2:44 PM
Subject: Database Connections Cleanup????
> Hi All,
>
> I have developed a simple query tool using JSP and JavaBeans. The user
logs
> in and a queryBean is instantiated and the connection is made to the
> database. I have an end session button which closes the DB connection but
if
> I dont use that my connection remains open as well as the bean is still
left
> instantiated...even if I close the browser the connection still stays
> there... until I stop and start the jswdk server again....Where can I do
> this kind of cleanup for JSP/Servlets??? Or is it possible using
> JavaScript?? I have set the scope of queryBean to be session...do I need
to
> change it to something else???
>
> Here's some info on my environment:
>
> WINNT4.0
> JSWDK 1.0
> JDK 1.2.2
> Oracle 8 Db
>
> Thanx
>
>
> Asim Imam
> Application Developer
> @AT&T Tax Systems Group
>
>
___________________________________________________________________________
> 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
