Bip Thelin typed the following on 03:57 PM 4/13/2001 -0700
>> - Would it be possible to parameterize the SQL statements used to
>> access the database? The idea would be that we can adapt to different
>> table and column names (like JDBCRealm does on the authentication side).
...
>I would like to propose that we save additional data in the database. The
>table would
>then look something like following:
>TABLE:
> [int ID] The ID for this session
> [boolean ISVALID] True if this session is valid
> [int MAXINACTIVE] The Max inactive attribute
> [Blob SESSION] The session object
>
>Then you could have a StoredProcedure if you want to that checks for
>timedout sessions
>and delete/invalidate them.
I think this is a good way to go about it: it looks like the table name can be
configured
in the server.xml file. Probably the column names should also maintained as JDBCStore
properties for configurability.
The table will need a column for the lastAccessedTime. And the ID column will need to
be something like CHAR, VARCHAR, or BYTE rather than an int.
Kief
