Howdy, Either varchar(100) or char(32) or pretty much any other choice is future to breakage in the future and non-portability. The servlet specification leaves it up to the container to choose the session ID string. What Mr. Mezick said about the jvmRoute being appended to the session ID is true for tomcat 4, may not be true in the future, and isn't the whole story anyways.
When the user clicks, does it not go to some page in your system? Can't that page just do request.getSession() to get the session and its ID? Yoav Shapira Millennium ChemInformatics >-----Original Message----- >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 >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] This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential, proprietary and/or privileged. This e-mail is intended only for the individual(s) to whom it is addressed, and may not be saved, copied, printed, disclosed or used by anyone else. If you are not the(an) intended recipient, please immediately delete this e-mail from your computer system and notify the sender. Thank you. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
