Insert session data into a db at end of session

[Brian E]

I'm storing session data in my application. I need to know how I can insert that data into a db at the end of a session -- both by explicitly killing the session (ie -- logout) or by session timeout.
I am running Tomcat 3.2.2 on Apache w/ Oracle 8.1.7
Thanks for your help.

[shilpa kulkarni]

implement the interface javax.servlet.http.HttpSessionBindingListener to bind all ur values to session. When the sesison times out or when it is invalidated (on clicking a 'logout' button, invalidate the session), it invokes sessionUnbound() on all the listeners. U can put in code for insertion into database in sessionUnbound() method then.

[Anonymous]

It might make more sense to bind a single listener and have it be responsible for persisting all the session data (as opposed to having each data object be responsible for persisting itself).

[Brian E]

Thanks for the replies.
I'm still having a bit of a time trying to figure this out. Could someone reply with some sample code of how I might do this?
Thanks.

[shilpa kulkarni]

If the object that u store in session is SessionBoundObject, when this obj is added to session by using :
session.putValue("name", obj);
it executes the valueBound() method.
And when session is destroyed, the valueUnbound method is called.
So whatever u need to do before destroying this object (like insert into database) should be done in the valueUnbound() method.

import javax.servlet.http.*;
public class SessionBoundObject implements HttpSessionBindingListener{
  public SessionBoundObject(){
    //log("created session bound object");
    System.out.println("created session bound object");
  }
  public void valueBound(HttpSessionBindingEvent event){
    //log("object bound to session");
    System.out.println("object bound to session");
  }
  public void valueUnbound(HttpSessionBindingEvent event){
    //log("object unbound from session");
    System.out.println("object unbound from session");
  }
}