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 | Description |
|---|---|---|---|
| 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. |
