I do not understand the last line of that create table statement: Create table tomcat_sessions { ... KEY kapp_name(app_name) );
Hmm... Harry Mantheakis > Hi all, > > I would like to use an SQL backend for the tomcat sessions like documented in > http://jakarta.apache.org/tomcat/tomcat-4.1-doc/config/manager.html > > I see : > > create table tomcat_sessions ( > session_id varchar(100) not null primary key, > [...] > > The DBA says that setting a primary key forces an index of this field, and > that the size could be a problem on the DB. As far as I understand it, the > size of the session_id in tomcat is 32bits. So, a varchar(32) should be > enough. Is the PersistentManager appending any information to the session_id > justifying the 100 size? > > Thanks for any tips about it (I'm not aware about SQL that much). > > François (bofh). --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]