Hello,
I want to store the Session ID in the database. Does anyone know what the smallest
type I can use in Oracle is?
What I mean is... Is the session Id always a 32 character string?
Thanks.
Andoni.
not null,
last_accessbigint not null,
app_name varchar(255),
session_data mediumblob,
KEY kapp_name(app_name)
);
-Original Message-
From: Andoni [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 10:32 AM
To: Tomcat Users List
Subject: Storing the SessionID
the session ID?
Would a char(32) not do the trick?
Thanks,
Andoni.
- Original Message -
From: Angus Mezick [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 3:36 PM
Subject: RE: Storing the SessionID in the Database.
You want to use a VARCHAR
-
From: Andoni [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 10:47 AM
To: Tomcat Users List
Subject: Re: Storing the SessionID in the Database.
I am only looking to know when a particular user clicks on Exit is
that
the same user that logged in, as in my app. many users use the same
login
ID
Yes, the can. In fact I am using JSP so I can do session.getID() at
anytime.
But this does not help me as I want to know how long this session has been
active. I want to be able to store the timestamp for when the session was
invalidated by clicking exit so as to be able to calculate how long
-oriented approach.
Yoav Shapira
Millennium ChemInformatics
-Original Message-
From: Andoni [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 11:11 AM
To: Tomcat Users List
Subject: Re: Storing the SessionID in the Database.
Yes, the can. In fact I am using JSP so I can do session.getID
-
From: Shapira, Yoav [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 4:15 PM
Subject: RE: Storing the SessionID in the Database.
Howdy,
Why not to this via a session listener? It's trivial. Keep a static
map with the session Id (String, key
Howdy,
That is fine for monitoring who or how many are online now but it is no
use
for long-term statistics calculation. I want to be able to graph the
changes in times spent on the site over the past week / month / year.
For
that I think I will need a DB approach??
You could... Or you could
approach??
Andoni.
- Original Message -
From: Shapira, Yoav [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Thursday, July 03, 2003 4:15 PM
Subject: RE: Storing the SessionID in the Database.
Howdy,
Why not to this via a session listener? It's trivial. Keep a static
map