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]
