The list of messages currently in any queue. Each row in this table represents a single message in a queue.

Column

Data Type

Constraint

queue_id

NUMERIC(19)

NOT NULL

The queue ID of the queue this message is currently in.

msg_id

NUMERIC(19)

NOT NULL

The unique numeric representation of the message used internally by the SQL-JMS system.

delivery_date

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.

handling_client_id

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.

read_state

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.