You can configure a database to collect session data for database session persistence.
To configure the session management facility for database session persistence, complete the following steps.
Use the JDBC provider that you defined: Resources > JDBC > JDBC Providers > JDBC_provider > Data Sources > New. The data source should be non-JTA, for example, non-XA enabled. Note the JNDI name of the data source.
Point
to an existing database.
The session manager uses the schema name to qualify the session table name for all database operations. If only the userid is specified without the schema name, the schema name defaults to NULL and therefore a table name with NULL as the schema name, for example, NULL.SESSIONS, is created. You can create multiple session tables with different schema names, other than NULL, and access them separately by modifying the user name to contain the appropriate schema name.