On Sat, 7 Apr 2001, Bip Thelin wrote:
> Here's the JDBCStore implementation. To use it change your server.xml to something
>like:
>
> <Manager
> className="org.apache.catalina.session.PersistentManager"
> debug="0" saveOnRestart="true" maxActiveSessions="1"
> minIdleSwap="-1" maxIdleSwap="1" maxIdleBackup="-1">
> <Store className="org.apache.catalina.session.JDBCStore"
> driverName="com.merant.datadirect.jdbc.sqlserver.SQLServerDriver"
> sessionTable="tomcat$sessions"
>
>connectionURL="jdbc:mysql://localhost/authority?user=test;password=test"
> debug="99"/>
> </Manager>
>
> You also have to create a table that has the fields id, session. And where id is a
>varchar field
> and session is a binary field, i.e. Blob. Sort of like:
> CREATE TABLE [dbo].[tomcat$sessions] (
> [id] [varchar] (50) NOT NULL ,
> [session] [binary] (1000) NULL
> )
>
> However the SQL command varies from different RDBMS.
>
Bip,
A couple of quick notes:
- Would it be possible to flesh out the rest of the JavaDoc comments?
I would like us to maintain the high quality level of JavaDocs that
Tomcat 4 is known for :-)
- 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).
> ..bip
>
Craig
