https://issues.apache.org/bugzilla/show_bug.cgi?id=57147

--- Comment #1 from Konstantin Kolinko <knst.koli...@gmail.com> ---
(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?

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?

I wonder whether "MEDIUMBLOB" is specific to MySQL or is actually defined in
some specification.

> 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

Reply via email to