NonStop Servlets for JavaServer Pages (NSJSP) 6.1 System Administrator's Guide

Configuring NSJSP
NonStop Servlets for JavaServer Pages (NSJSP) 6.1 System Administrator’s Guide—596210-006
3-86
Persistent Manager Sessions
(SessionBasedLoadBalancing = false)
Configure the Persistent Store
When configuring a Manager element for session persistence, a Store element must
be configured as a child element of the Manager element.
Example 3-69 shows the sample configuration of the Store element.
Example 3-68. SQL/MX script to create a Persistent Store
create catalog nsjspcat;
set catalog nsjspcat;
create schema nsjspsch;
set schema nsjspsch;
--
-- Create the NonStop(tm) SQL Table in the above catalog for storing the
-- NonStop(tm) Servlets for JavaServer Pages(tm) persistent session data.
--
create table SessData (
session_id CHAR(48) NO DEFAULT NOT NULL,
process_name CHAR(8) NO DEFAULT NOT NULL,
rec_number INTEGER UNSIGNED NO DEFAULT NOT NULL,
valid SMALLINT UNSIGNED NO DEFAULT,
maxinactiveinterval INTEGER NO DEFAULT,
lastaccessed LARGEINT NO DEFAULT,
app_name VARCHAR(150) NO DEFAULT NOT NULL,
session_data VARCHAR(3600) CHARACTER SET ISO88591,
primary key (session_id, process_name, rec_number) );
Example 3-69. Sample Configuration of the Store Element
<Manager
className="com.tandem.servlet.catalina.session.NSJSPPersistentManager">
<Store
className="com.tandem.servlet.catalina.session.NonStopSQLJDBCStore"
driverName="com.tandem.sqlmx.SQLMXDriver"
connectionURL="jdbc:sqlmx:"
sessionTable="nsjspcat.nsjspsch.SessData"
sessionIdCol="session_id"
sessionProcessNameCol="process_name"
sessionRecNumberCol="rec_number"
sessionAppCol="app_name"
sessionDataCol="session_data" sessionValidCol="valid"
sessionMaxInactiveCol="maxinactiveinterval"
sessionLastAccessedCol="lastaccessed"/>
</Manager>