Logging out a user when browser is closed

[Vamsi]

I have a java servlet which is connected to a database X. X has 4 fields in it
1.User name
2.logged in time
3.logged out time
4.Is logged in.

Whenever a user logsout from the application, those 4 fields get updated. I have used cookies to store username in log in servlet and called it in logout servlet.

Now, if the user does not logout but just closes his browser, he must be anyways logged out, and those 4 fields must get updated ..which am not able to do.

Any help is appreciated. Thank you.

[Tolls]

That's not generally the best way of determining the state of someone's login in a webapp.
Normally you'd simply rely on the Session.
You have no idea when the browser is shut down.
Without some form of monitoring of last access or somesuch this isn't generally doable.

[Vamsi]

Actually whenever a user closes his browser and opens it again, he is prompted to login..So i say virtually he is logged out.. but those fields in the database are not updated. SO log out is not complete in real sense. So u say this is not doable???

[DarrylBurke]

So u say this is not doable???

Did you read the last line of the response posted by Tolls?

db

[Tolls]

Actually whenever a user closes his browser and opens it again, he is prompted to login..So i say virtually he is logged out.. but those fields in the database are not updated. SO log out is not complete in real sense. So u say this is not doable???

They're not "virtually logged out".
I suspect it simply clears the cookies or something, which is entirely browser side.

This is doable, but you need more data in the database and a separate process that logs out users that have no active session id (using something like a session monitor).
It won't be instant, it will take however long the session timeout is plus the monitoring period.