tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 57147] Fixes to Documentation of JDBC-Based Store
Date Sun, 26 Oct 2014 23:15:31 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=57147

--- Comment #1 from Konstantin Kolinko <knst.kolinko@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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org


Mime
View raw message