Re: [JBoss-user] Design Question...

[Toby H. <tob...@in...>]

another way to approach this is through the datbase itself, writing a
trigger to remove the data and setting a schedule for processing. most
modern rdbms systems have similar implementations



----- Original Message -----
From: "C Murphy @ Intechtual" <cm...@in...>
To: <jbo...@li...>
Sent: Tuesday, July 31, 2001 3:15 AM
Subject: Re: [JBoss-user] Design Question...


> Hey Tim,
>
> If I correctly understand your qutestion, this is more of a servlet type
session management issue.  Take a look at the
javax.servlet.http.HttpSessionBindingListener interface.  It's basically a
callback interface for when a session expires.   Objects in the session,
that implement the interface,  will be messaged that they are being removed
from the session so that they can respond accordingly (in your case call
your Entity or whatever to remove the user/session relationship from the
data store).  So regardless if your user logs out explicity, or the session
expires due to inactivity, your object can be notified and do the
appropriate clean up.
>
> Hope this helps.
> Chris Murphy
>
> On Mon, 30 Jul 2001 16:45:41 +0100, Tim Yates <ti...@te...>  wrote:
> > Hi there!!
> >
> > When a user hits the site, they get allocated a unique 48 character
session
> > ID (allocated by me).  If they then login, I tie that sessionId to a
userId
> > (both rows in seperate tables)
> >
> > But I have a design question...  They can log-out, but many do not
> > (obviously), so what would be the best way of clearing out-of-date
> > sessionIds at regular intervals?
> >
> > As far as I can see, I have two choices...
> >
> > 1) A seperate java server which runs through the instance table every
hour
> > or so, and calls my EJB's to delete those rows that have become inactive
> >
> > or 2) Use a Timer MBean to callback after a certain time to remove the
> > row...
> >
> > I am thinking that option 2 would be a much cleaner way of doing things,
but
> > what would be the way to do it?
> >
> > Sorry if I am talking rubbish, I have been searching for tutorials, and
> > books all afternoon, and the Web (and Amazon) has come up dry :(
> >
> > Thanks for any input you can give :)
> >
> > Tim Yates
> >
> >
> > _______________________________________________
> > JBoss-user mailing list
> > JBo...@li...
> > http://lists.sourceforge.net/lists/listinfo/jboss-user
>
> _______________________________________________
> JBoss-user mailing list
> JBo...@li...
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>