Enabling session persistence to a database
Session persistence is enabled in a server or
environment file. You must also create the session database table to store
session information.
- Open the server or environment file to which you want to enable session persistence. The file opens in the editor window.
- In the Overview tab, click the Clustering/Session subtab.
- In the Session Timeout field, enter the amount of time to store persisted sessions, in minutes.
- Click the Persistent Session check box.
- Ensure the Persistence Directory field is cleared.
- In the connections or environment file, click the Data Source Connections tab.
- Add and configure the SessionDatabase data source.
- Create the Session table using the SessionDatabase data source, using the Data Load Tool or the Database Schema Tool.
- Configure the other session settings as required.
Important: The Persistent Session Timeout
property must be set to a larger value than the Session Timeout property
to avoid potential race conditions which may lead to unpredictable and
unexpected behaviour.