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

Configuring NSJSP

NonStop Servlets for JavaServer Pages (NSJSP) 6.0 System Administrator’s Guide—544548-004

3-45

Configuring NSJSPPersistentManager and

Persistent Store

sessionProcessNameCol

The name of the NonStop SQL database column in the specified sessionTable

that includes the HP NonStop process name of the NonStop Server for Java (NSJ)

process. This column type must accept as many characters as are included in the

NonStop process name (typically 6).

sessionRecNumberCol

The name of the NonStop SQL database column contained in the specified

sessionTable that contains the record number level of the swapped out/backed

up session. This column type must accept a Java integer (32 bits).

Before using the NonStop SQL JDBC-based store, create a NonStop SQL catalog and

database table to store the swapped out/backed up sessions. For more information,

see Configuring the Session Manager to support Persistent Sessions on page 3-43.

Note. The NonStop SQL catalog must be created on a TMF-audited data volume (disk). To

save the persistent session data to the persistent store, you must use the PATHCOM utilities

instead of the stop script (For more information, see Stopping NSJSP

on page 2-10).

Example 3-22. Using the NSJSPPersistentManager

<Context path="/servlet_jsp/examples" docbase="examples"

reloadable="false" crossContext="true">

<Manager

className="com.tandem.servlet.session.NSJSPPersistentManager"

debug="0" saveOnRestart="true" maxActiveSessions="1"

minIdleSwap="-1" maxIdleSwap="-1" maxIdleBackup="-1">

<Store

className="com.tandem.servlet.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>

</Context>