[thelist] preventing multiple web connections to a db app

[Johnson, Christopher (MTO)]

> -----Original Message-----
> We have a primarily Java front end running in IE6 connecting to a DB2
> database. Users often use the 'File | New' process to open another
> connection, which according to the developers uses the same db session
> ID, and leads to corruption and world hunger. However, starting from a
> fresh login to the app has no such problems.
> 
> I'm looking for a way, then, to force users to login in fresh 
> when they
> want a second window to the app.

Can you not just use a flag in the session variables/object that you are
using for each user? Once they make a db connection, you switch the flag to
true. If they try to make a second connection while the flag is set to true,
then they are forced to login again. Once they close the active DB
connection, the flag is reset to false and they are, once again, able to
establish a new connection.

This flag could be stored in a session variable or within the database.

Chris