C ADF Mobile Transaction Replay Service Tables

This appendix describes tables that form parts of ADF Mobile transaction replay service schema.

This appendix includes the following sections:

Section C.1, "REPLAY_ITEM Table"
Section C.2, "REPLAY_TYPE Table"
Section C.3, "REPLAY_STATUS Table"

Note:

REPLAY_JOBS and REPLAY_USERS tables are internal to the transaction replay service and are not described in this appendix.

C.1 REPLAY_ITEM Table

Table C-1 contains details on the REPLAY_ITEM table.

Table C-1 REPLAY_ITEM Table Column Details

Column Name	Type	Length	Key	Comments
`ITEM_ID`	`NUMBER`	15	Primary Key	Primary KeyID and the primary key. Replay items are processed in the order of `ITEM_ID`.
`REPLAY_TYPE`	`NUMBER`	10	Foreign Key	Foreign key to the `REPLAY_TYPE` table that references details for replaying the replay item.
`STATUS`	`NUMBER`	10	Foreign Key	Numerical status of replay item during processing through the transaction replay service.
`CLIENT_ID`	`NUMBER`	10	Primary Key, Foreign Key	A unique identifier for a disconnected client device. Items with the same `CLIENT_ID` are processed sequentially. Items with different `CLIENT_ID` are processed concurrently.
`USER_NAME`	`VARCHAR2`	2000	NA	The user name for an enterprise server application. Used for authentication and authorization to the back-end server where items are replayed.
`USER_PASSWORD`	`VARCHAR2`	4000	NA	The user password for an enterprise server application. Used for authentication and authorization to the back-end server where items are replayed.
`PARAMS`	`CLOB`		NA	An XML-formatted string containing input parameters to the corresponding replay type method call. Note that this is not a required column.
`ERROR`	`VARCHAR2`	4000	NA	Detailed error information regarding an item during replay.
`CREATED_ON`	`TIMESTAMP`		NA	The timestamp when the replay item was posted to the table.
`PROCESSED_ON`	`TIMESTAMP`		NA	The timestamp when the replay item was replayed on the server. Also indicates the time when a replay item status is set to success or error.
`DEPENDENCY`	`NUMBER`	15	Foreign Key	Dependency of this item. It may contain the `Item_ID` of another replay item, which means the dependency replay item must be processed before this replay item.

C.2 REPLAY_TYPE Table

Table C-2 contains details on the REPLAY_TYPE table.

Table C-2 REPLAY_TYPE Table Column Details

Column Name	Type	Length	Key	Comments
`TYPE_ID`	`NUMBER`	10	Primary Key	ID number and the primary key of the `REPLAY_TYPE` table.
`TYPE_NAME`	`VARCHAR2`	1000	NA	Descriptive name for the replay type.
`INV_TYPE`	`VARCHAR2`	1000	NA	The invocation type to be used for replaying the type.For example, Java Class, Web Service, or Oracle ADF Business Service.
`ADF_CONFIG_NAME`	`VARCHAR2`	1000	NA	ADF application module runtime configuration name.
`CLASS_NAME`	`VARCHAR2`	1000	NA	The full class name including the package name.
`METHOD_NAME`	`VARCHAR2`	1000	NA	The method to be called on the application.
`XSD_URL`	`VARCHAR2`	2000	NA	The location of the XSD URL used for validation.
`XSL_URL`	`VARCHAR2`	2000	NA	The location of the XSLT URL that is to be used for transformation.
`PASSWORD_TYPE`	`VARCHAR2`	40	NA	Password type. The supported values are CSF for credential store, and PKE for public key encryption.
`CS_MAP_NAME`	`VARCHAR2`	1000	NA	Specific map name for this given replay type.
`PORT_CLASS_NAME`	`VARCHAR2`	1000	NA	Port classname for JAX-WS proxy.
`CLIENT_CONFIG_URL`	`VARCHAR2`	2000	NA	The client security policy configuration file for JAX-WS proxy.

C.3 REPLAY_STATUS Table

Table C-3 contains details on the REPLAY_STATUS table.

Table C-3 REPLAY_STATUS Table Column Details

Column Name	Type	Length	Key	Comments
`STATUS_ID`	`NUMBER`	10	Primary Key	The primary key generated by sequence.
`STATUS`	`VARCHAR2`	1000	N/A	Descriptive text to define the status.