469,292 Members | 1,310 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,292 developers. It's quick & easy.

session close in JSP

Hi

I am writing a program in JSP which requires user to log in and as he
logs in database was updated with his status on and till the user does
not sign out no other user with same login and password can enter in
the system. as he signs out database was updated but the problem is if
somehow he forgot to sign out and closed the browser or navigate to
other page or site his information was still on in the database. I
want a solution how to update a database when users forgot to signout
but closed the window or browser.
I am using Apache Tomcat ver 4.1.27 with Jsp and SQLServer7.0

Thanks

Megha
Jul 17 '05 #1
4 18759
megha wrote:
Hi

I am writing a program in JSP which requires user to log in and as he
logs in database was updated with his status on and till the user does
not sign out no other user with same login and password can enter in
the system. as he signs out database was updated but the problem is if
somehow he forgot to sign out and closed the browser or navigate to
other page or site his information was still on in the database. I
want a solution how to update a database when users forgot to signout
but closed the window or browser.
I am using Apache Tomcat ver 4.1.27 with Jsp and SQLServer7.0

Thanks
Hi, I already replied to this in your previous thread. Please do not post
the same question twice under a different heading.
***************************************** You should implement the HttpSessionListener interface. In case a session is invalidated either by a pre-defined time-out or when the user closes his
browser, the sessionDestroyed method is called. Use this method to
clean-up whatever that needs to be done in your database when the user
forgets to do a proper logoff.
Brgds,
Herman Megha


--
Suse Linux Professional 8.1 on Athlon 1.1 Ghz 512 Mb
Anti Spam = remove the "dot" and the "at"
Registered Linux User #264690
Jul 17 '05 #2
took look at the comp.lang.java.database
already one discussion on the same thema there now
actual
"megha" <me***@4cplus.com> wrote in message
news:ee**************************@posting.google.c om...
Hi

I am writing a program in JSP which requires user to log in and as he
logs in database was updated with his status on and till the user does
not sign out no other user with same login and password can enter in
the system. as he signs out database was updated but the problem is if
somehow he forgot to sign out and closed the browser or navigate to
other page or site his information was still on in the database. I
want a solution how to update a database when users forgot to signout
but closed the window or browser.
I am using Apache Tomcat ver 4.1.27 with Jsp and SQLServer7.0

Thanks

Megha

Jul 17 '05 #3
Hi
I tried to implement httpsessionlistener interface but it is not
activating
destroy method once the user closes the browser window though it is
properly running the create method. I am using the following code and
in destroy method it has to display only text but it is not. Please
send some suggestion.

public class SessionCounter implements HttpSessionListener {

private static int activeSessions = 0;
static String url="jdbc:odbc:candico";

/* Session Creation Event */
public void sessionCreated(HttpSessionEvent se) {
activeSessions++;
System.out.println("activeSessions90"+activeSessio ns);
}

/* Session Invalidation Event */
public void sessionDestroyed(HttpSessionEvent se) {

System.out.println("activeSessions");

}

public static int getActiveSessions() {
return activeSessions;
}
}


Herman Timmermans <ti********************@skynet.be> wrote in message news:<3f**********************@reader1.news.skynet .be>...
megha wrote:
Hi

I am writing a program in JSP which requires user to log in and as he
logs in database was updated with his status on and till the user does
not sign out no other user with same login and password can enter in
the system. as he signs out database was updated but the problem is if
somehow he forgot to sign out and closed the browser or navigate to
other page or site his information was still on in the database. I
want a solution how to update a database when users forgot to signout
but closed the window or browser.
I am using Apache Tomcat ver 4.1.27 with Jsp and SQLServer7.0

Thanks


Hi, I already replied to this in your previous thread. Please do not post
the same question twice under a different heading.
*****************************************
You should implement the HttpSessionListener interface. In case a session

is invalidated either by a pre-defined time-out or when the user closes his
browser, the sessionDestroyed method is called. Use this method to
clean-up whatever that needs to be done in your database when the user
forgets to do a proper logoff.
Brgds,
Herman
Megha

Jul 17 '05 #4
you must include <session-timeout> in your web-xml. In other cases the
session never expires.

you could test with value=1 (one minute) to test.

bye
"megha" <me***@4cplus.com> escribió en el mensaje
news:ee**************************@posting.google.c om...
Hi
I tried to implement httpsessionlistener interface but it is not
activating
destroy method once the user closes the browser window though it is
properly running the create method. I am using the following code and
in destroy method it has to display only text but it is not. Please
send some suggestion.

public class SessionCounter implements HttpSessionListener {

private static int activeSessions = 0;
static String url="jdbc:odbc:candico";

/* Session Creation Event */
public void sessionCreated(HttpSessionEvent se) {
activeSessions++;
System.out.println("activeSessions90"+activeSessio ns);
}

/* Session Invalidation Event */
public void sessionDestroyed(HttpSessionEvent se) {

System.out.println("activeSessions");

}

public static int getActiveSessions() {
return activeSessions;
}
}


Herman Timmermans <ti********************@skynet.be> wrote in message

news:<3f**********************@reader1.news.skynet .be>...
megha wrote:
Hi

I am writing a program in JSP which requires user to log in and as he
logs in database was updated with his status on and till the user does
not sign out no other user with same login and password can enter in
the system. as he signs out database was updated but the problem is if
somehow he forgot to sign out and closed the browser or navigate to
other page or site his information was still on in the database. I
want a solution how to update a database when users forgot to signout
but closed the window or browser.
I am using Apache Tomcat ver 4.1.27 with Jsp and SQLServer7.0

Thanks


Hi, I already replied to this in your previous thread. Please do not post the same question twice under a different heading.
*****************************************
You should implement the HttpSessionListener interface. In case a
session is invalidated either by a pre-defined time-out or when the user closes his browser, the sessionDestroyed method is called. Use this method to
clean-up whatever that needs to be done in your database when the user
forgets to do a proper logoff.
Brgds,
Herman
Megha

Jul 17 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Gonenc Ercan | last post: by
9 posts views Thread by charliewest | last post: by
2 posts views Thread by Antonio Dias | last post: by
14 posts views Thread by aroraamit81 | last post: by
3 posts views Thread by Steph | last post: by
9 posts views Thread by forje | last post: by
4 posts views Thread by rgparkins | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.