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

Configuring NSJSP
NonStop Servlets for JavaServer Pages (NSJSP) System Administrator’s Guide525644-003
3-56
Configuring the Persistent Store
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 Manager for Sessions Support on page 3-49.
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 should use the
iTPWS_INSTALL_DIR/conf/nsjsp_stop script instead of the stop script (For more
information, see Stopping NSJSP on page 2-5).
Example 3-36. Using the NSJSPPersistentManager
<Context path="/servlet_jsp/examples" docbase="examples" debug ="0"
reloadable="false" crossContext="true">
<Manager
className="com.tandem.servlet.catalina.session.NSJSPPersistentManager"
debug="0" saveOnRestart="true" checkInterval="300"
maxActiveSessions="-1" minIdleSwap="-1" maxIdleSwap="600"
maxIdleBackup="-1">
<Store
className="com.tandem.servlet.catalina.session.NonStopSQLJDBCStore
debug="0" driverName="com.tandem.sqlmp.SQLMPDriver"
connectionURL="jdbc:sqlmp:"
sessionTable="$$SYSTEM.T1222CAT.SessData"
sessionIdCol="session_id"
sessionProcessNameCol="process_name"
sessionRecNumberCol="rec_number"
sessionAppCol="app_name"
sessionDataCol="session_data" sessionValidCol="valid"
sessionMaxInactiveCol="maxinactiveinterval"
sessionLastAccessedCol="lastaccessed" />
</Manager>
</Context>