The list of actual messages currently in the SQL-JMS system. Each row represents a single message that might be in a single queue or waiting to be received by multiple topic subscribers.
Column | Data Type | Constraint |
---|---|---|
| VARCHAR(250) | NULL |
The Java class of the message. | ||
| NUMERIC(1) | NULL |
Whether or not the message has properties beyond the standard JMS header properties, such as implementation or application specific properties. | ||
| NUMERIC(10) | NULL |
The number of topic subscribers still waiting to receive the message. | ||
| NUMERIC(19) | NOT NULL |
The unique identifier of the message used internally by the SQL-JMS system. | ||
| NUMERIC(19) | NULL |
JMS header property: the time the message was handed off to the provider to be sent. | ||
| VARCHAR(250) | NULL |
JMS header property: the correlation ID. Currently, this property is unsupported and this column is always null. | ||
| NUMERIC(19) | NULL |
JMS header property: the destination where a reply to the message should be sent. This column uses the topic or queue ID to represent the reply destination. If no reply-to was specified in the JMS message the column has the value zero. | ||
| NUMERIC(19) | NULL |
JMS header property: the destination where the message is being sent. This column uses the topic or queue ID to represent the destination. | ||
| NUMERIC(1) | NULL |
JMS header property: the delivery mode of the message. | ||
| NUMERIC(1) | NULL |
JMS header property: an indication of whether the message is being redelivered. | ||
| VARCHAR(250) | NULL |
JMS header property: the message type. | ||
| NUMERIC(19) | NULL |
JMS header property: the message’s expiration value. | ||
| NUMERIC(1) | NULL |
JMS header property: the message priority. | ||
| VARBINARY(250) | NULL |
The body of the message if the body is within the preset size for small bodies. | ||
| LONG VARBINARY | NULL |
The body of the message if the body is larger than the preset size for small bodies. |