Table of Contents
This appendix describes the columns of the tables created when the Persistence store is set to JDBC in JEUS MQ.
Contains information about destinations.
| Item | Type | Description |
|---|---|---|
| DT_ID | BIGINT | Destination ID |
| DT_NAME | VARCHAR(255) | Destination name |
| DT_QUEUE | BIT | Indicates whether the destination is a Queue or Topic.
|
| DT_VALID | BIT | Indicates whether the destination is valid. |
| DT_LVID | BIGINT | Current version of the destination |
| DT_DYNAMIC | BIT | Indicates whether the destination is created dynamically or not |
| DT_OBJECT | BLOB | Binary data of the destination |
Contains information about durable subscribers.
| Item | Type | Description |
|---|---|---|
| DS_ID | BIGINT | Durable subscriber ID |
| DS_CLIENT_ID | VARCHAR(255) | Client ID assigned to the durable subscriber |
| DS_NAME | VARCHAR(255) | Durable subscriber name |
| DS_SELECTOR | VARCHAR(255) | Message selector assigned to the durable subscriber |
| DS_VALID | BIT | Indicates whether the durable subscriber is valid |
| DS_LVID | BIGINT | Current version of the durable subscriber |
| DT_ID | BIGINT | ID of the topic linked to the durable subscriber |
| DT_LVID | BIGINT | Version of the topic linked to the durable subscriber |
Contains information about messages.
| Item | Type | Description |
|---|---|---|
| MG_ID | BIGINT | Message ID |
| MG_TYPE | TINYINT | Message type |
| MG_LENGTH | INTEGER | Message length |
| MG_OBJECT | TINYINT[] | Binary data of the message |
| MG_STATUS | SMALLINT | Message status |
| MG_GLOBAL_ORDER_CLOCK | SMALLINT | Time when the message's Global Order was set |
| MG_PERSISTENT | TINYINT[] | Indicates whether a message is set as persistent or not. |
| DT_ID | BIGINT | ID of the message's destination |
| DT_LVID | BIT | Version of the message's destination |
Contains information about durable subscriber messages.
| Item | Type | Description |
|---|---|---|
| DM_ID | BIGINT | Durable subscriber message ID |
| DM_STATUS | SMALLINT | Status of the durable subscriber message |
| DM_LVID | BIGINT | Current version of the durable subscriber message |
| MG_ID | BIGINT | ID of the actual message |
| DS_ID | BIGINT | ID of the durable subscriber that contains the durable subscriber message |