https://issues.apache.org/bugzilla/show_bug.cgi?id=57147
--- Comment #2 from Fernando Ribeiro <fernando.ribe...@upic.com.br> --- (In reply to Konstantin Kolinko from comment #1) > (In reply to Fernando Ribeiro from comment #0) > > 3- The DDL for the sessions table doesn't match the defaults in the > > JDBCStore class [2]: > > > > CREATE TABLE tomcat$sessions ( > > id VARCHAR(100) NOT NULL PRIMARY KEY, > > app VARCHAR(255), > > data MEDIUMBLOB, > > lastaccess BIGINT NOT NULL, > > maxinactive INT NOT NULL, > > valid CHAR(1) NOT NULL > > ); > > I see no such DDL code as above in JDBCStore class. Where is it from? > Did you take the default column names and wrote it by yourself? Right. > I would say that the DDL in documentation has more readable column names. It > also specifies "KEY kapp_name(app_name)". Is any substantial missing in > documented DDL? They may be more readable but they are not the defaults. The key may really need to be added to my DDL. > I wonder whether "MEDIUMBLOB" is specific to MySQL or is actually defined in > some specification. It is a MySQL data type not available in many other databases. > > 1- The connectionName and connectionPassword parameters are missing > > Those have to be documented. > Though a better recommendation is to use a DataSource, referenced via > dataSourceName property. > > When a DataSource is used, the "connectionURL", "driverName" properties are > no more required. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@tomcat.apache.org For additional commands, e-mail: dev-h...@tomcat.apache.org
