EAServer stores all session data in a remote database, connecting through the predefined JDBC data source session.db. All servers in the cluster share the same database. Sybase recommends that you configure this data source to connect to an enterprise-grade database server. The database cannot be shared between servers that are not running in the same EAServer cluster.
The database table that stores session data is automatically created for every database type that EAServer supports. The name of the table is web_session.
Change the sample session.db properties
As preconfigured, the session.db data
source connects to the sample database that is included with the EAServer
sample applications. This sample uses the evaluation version of Adaptive
Server Anywhere, which does not allow connections from multiple hosts.
You must use another database that allows connections from multiple hosts,
and supports the number of connections required by your cluster.
Configuring persistent session storage
The Web application must be marked “distributable.”
Perform these steps from the Management Console, while connected to the primary server for your EAServer cluster:
Install the Web application to one or more logical servers that are part of the cluster.
Configure the properties of the data source named session.db to connect to the database that you use for persistent session storage. This data source must use JDBC. See “Configuring data sources” for instructions.
Make sure the session.db data source is installed in each logical server where the Web application is installed.
Synchronize the EAServer cluster to propagate the configuration changes to other servers in the cluster. See Chapter 7, “Exporting Server Modules.”