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 together comprise 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.