C Overview of the Session State Tables

This appendix documents the schema for the database tables used by the OC4J database persistence mechanism. See "Configuring Database Replication" for additional information on this mechanism.

OC4J_HTTP_SESSION

This table stores metadata for a single HTTP session, including identifiers for the application and user setting properties on the session. The ID is the primary key.

There is a 1:many relationship between an OC4J_HTTP_SESSION table and the OC4J_HTTP_SESSION_VALUE tables. Each entry in the OC4J_HTTP_SESSION table may have 0 or more entries in the OC4J_HTTP_SESSION_VALUE table.

Table C-1 OC4J_HTTP_SESSION Table Description

Name	Null?	Data Type	Description
`ID`	`NOT_NULL`	`VARCHAR2(100)`	The unique session ID.
`APPLICATION_ID`	`NULL`	`VARCHAR2(100)`	The OC4J internal ID assigned to the application the session belongs to.
`IP`	`NULL`	`NUMBER(38)`	The IP address of the machine hosting the application.
`LAST_ACCESSED`	`NULL`	`NUMBER(38)`	The last time the current record was updated.
`USER_NAME`	`NULL`	`VARCHAR2(50)`	The user name for the application user setting values on the session.
`MAX_INACTIVE_TIME`	`NULL`	`NUMBER(38)`	The maximum time the session can remain idle before being expired. Session data will not be persisted after this maximum is exceeded.
`CREATION_TIME`	`NULL`	`NUMBER(38)`	The time at which the table was created.

OC4J_HTTP_SESSION_VALUE

This table stores each HTTP session property and the values set on it by the application user. The values are stored as a BLOB (binary large object). The ID and KEY_FIELD values together compose the primary key.

Table C-2 OC4J_HTTP_SESSION_VALUETable Description

Name	Null?	Data Type	Description
`ID`	`NOT_NULL`	`VARCHAR2(100)`	The unique session ID.
`KEY_FIELD`	`NOT_NULL`	`VARCHAR2(100)`	The name of a property set by the application user on the session.
`VALUE_FIELD`	`NULL`	`BLOB`	The value of the property set on the session.

OC4J_EJB_SESSION

This table stores the current state of a stateful session bean. The state data is stored as a BLOB (binary large object). The ID is the primary key.

Table C-3 OC4J_EJB_SESSION Table Description

Name	Null?	Data Type	Description
`ID`	`NOT_NULL`	`VARCHAR2(100)`	The unique session ID.
`VALUE_FIELD`	`NULL`	BLOB	The current state data of the session bean.
`LOCATION`	`NULL`	`NUMBER(38)`	The JNDI name that the session bean is bound to.
`CHECKSUM`	`NULL`	`NUMBER(38)`	Used internally to validate that bytes are formatted correctly.
`PASSIVATE`	`NULL`	`NUMBER(38)`	A Boolean value indicating whether the bean has been passivated. If true, the passivated bean will be retrieved from disk.
`LAST_ACCESSED`	`NULL`	`NUMBER(38)`	The last time the current record was updated.
`USER_NAME`	`NULL`	`VARCHAR2(50)`	The user name for the application user setting values on the session.
`MAX_INACTIVE_TIME`	`NULL`	`NUMBER(38)`	The maximum time the session can remain idle before being expired. Session data will not be persisted after this maximum is exceeded.
`CREATION_TIME`	`NULL`	`NUMBER(38)`	The time at which the table was created.