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

Configuring NSJSP
NonStop Servlets for JavaServer Pages (NSJSP) System Administrator’s Guide—525644-002
3-58
Before using the NonStop SQL JDBC-based store, create a NonStop SQL catalog and
database table to store the swapped out/backed up sessions. See Configuring the
Manager for Sessions Support on page 3-51 for more details.
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 (see Stopping
NSJSP on page 2-7 for more details).
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>