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 and password. So I only want to store the session ID to compare with the ones created at login.
Do I really need a varchar(100) to store 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. This is because the jvmroute parameter will be appended to the sessionId. This is the suggested table structure for JdbcStore: create table tomcat_sessions ( session_id varchar(100) not null primary key, valid_session char(1) not null, max_inactive int not null, last_access bigint 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 in the Database. > > > 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. > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
