JDBC Persistence Store Columns
This appendix describes the columns of the tables created when the Persistence store is set to JDBC in JEUS MQ.
1. Destination Table
The following table 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 |
2. Durable Subscription Table
The following table contains information about durable subscription.
| Item | Type | Description |
|---|---|---|
DS_ID |
BIGINT |
Durable subscription ID |
DS_CLIENT_ID |
VARCHAR(255) |
Client ID assigned to the durable subscription |
DS_NAME |
VARCHAR(255) |
Durable subscription name |
DS_SELECTOR |
VARCHAR(255) |
Message selector assigned to the durable subscription |
DS_VALID |
BIT |
Indicates whether the durable subscription is valid |
DS_LVID |
BIGINT |
Current version of the durable subscription |
DT_ID |
BIGINT |
ID of the topic linked to the durable subscription |
DT_LVID |
BIGINT |
Version of the topic linked to the durable subscription |
3. Message Table
The following table 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 |
MG_HEADER_LENGTH |
INTEGER |
Message header length |
MG_HEADER_OBJECT |
TINYINT[] |
Binary data of the message header |
4. MetaInfo Table
The following table contains information about JEUS MQ’s persistence store.
| Item | Type | Description |
|---|---|---|
SERVER_NAME |
VARCHAR(255) |
JEUS MQ server name |
VERSION |
BIGINT |
JEUS MQ version |
5. Subscription Message Table
The following table contains information about durable subscription messages.
| Item | Type | Description |
|---|---|---|
DM_ID |
BIGINT |
Durable subscription message ID |
DM_STATUS |
SMALLINT |
Status of the durable subscription message |
DM_LVID |
BIGINT |
Current version of the durable subscription message |
MG_ID |
BIGINT |
ID of the actual message |
DS_ID |
BIGINT |
ID of the durable subscription containing the durable subscription messages |