Column | TDV JDBC Data Type | Nullable | Description |
TYPE | VARCHAR(28) | Indicates the type of transaction log entry, which can be: | |
Begin transaction (manual)—Start a transaction supporting manual recovery. Begin transaction (auto)—Start a transaction supporting both manual recovery and automatic compensation. Execute SQL—Execute a SQL statement. Add work unit—Add a work unit (an insert, update, or delete action on a data source). Begin commit End commit Fail commit Begin rollback End rollback Fail rollback Server restart Begin work unit commit End work unit commit Work unit commit failure Work unit commit in doubt Begin work unit rollback End work unit rollback Work unit rollback failure Being work unit compensate End work unit compensate Work unit compensate failure | |||
SERIAL | BIGINT | Unique serial number for the transaction log entry. | |
TIMESTAMP | BIGINT | The time when the log entry was made, to the millisecond. | |
TRANSACTION_ID | BIGINT | The unique ID for the transaction to which this log entry applies. | |
WORK_UNIT_ID | BIGINT | Yes | For work unit entries, this is the unique ID; otherwise NULL. |
MESSAGE | BLOB | Yes | Contains a SQL statement for Execute SQL and Add Work Unit. Contains the exception message for any failure type; otherwise NULL. |