The list of messages currently in any queue. Each row in this table represents a single message in a queue.
Column | Data Type | Constraint |
---|---|---|
| NUMERIC(19) | NOT NULL |
The queue ID of the queue this message is currently in. | ||
| NUMERIC(19) | NOT NULL |
The unique numeric representation of the message used internally by the SQL-JMS system. | ||
| NUMERIC(19) | NULL |
A Java long date value that specifies when the message should be delivered. The value is a date/time in the form of UTC milliseconds from the epoch start (1 January 1970 0:00 UTC). If there is to be no delayed delivery of the message, this column effectively holds a timestamp of when the message was put into the queue allowing it to be delivered as soon as possible. | ||
| NUMERIC(19) | NULL |
The client ID of the client that is attempting to handle this message. If no client is attempting to handle this message yet, this column contains the value –1. | ||
| NUMERIC(19) | NULL |
The current state of the message. A message that is not currently being handled by a client has a value of zero. A message that is being handled has a non-zero value. Messages that are handled successfully are deleted from this table. |