Enqueuing a Message [Specify Message Properties]

Figure 11-4 Use Case Diagram: Enqueuing a Message [Specify Message Properties]

Text description of the illustration adq11qop14.gif

To refer to the table of all basic operations having to do with the Operational Interface see: "Use Case Model: Operational Interface -- Basic Operations"

Purpose

The Message Properties describe the information that is used by AQ to manage individual messages. These are set at enqueue time and their values are returned at dequeue time.

Usage Notes

• To view messages in a waiting or processed state, you can either dequeue or browse by message ID, or use SELECT statements.

• Message delay and expiration are enforced by the queue monitor (QMN) background processes. You should remember to start the QMN processes for the database if you intend to use the delay and expiration features of AQ.

Syntax

See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Use the following syntax references for each programmatic environment:

• PL/SQL (DBMS_AQ Package): Oracle9i Supplied PL/SQL Packages and Types Reference DBMS_AQ, ENQUEUE procedure

• Visual Basic (OO4O) (Oracle Objects for OLE (OO4O) Online Help): From Help Topics, Contents tab, select OO4O Automation Server > OBJECTS > OraAQ

• Java (JDBC): Oracle9i Supplied Java Packages Reference,oracle.jms, AQMessageProperty

Examples

See Chapter 3, "AQ Programmatic Environments" for a list of available functions in each programmatic environment. Examples in the following programmatic environments are provided:

• PL/SQL (DBMS_AQ Package): Enqueue of Object Type Messages

• Java (JDBC): Enqueue a message (add payload)

• Visual Basic (OO4O): Enqueue a message