Using advanced queueing v42.7.3.2

EDB Postgres Advanced Server advanced queueing provides message queueing and message processing for the EDB Postgres Advanced Server database. User-defined messages are stored in a queue, and a collection of queues is stored in a queue table. You must first create a queue table before creating a queue that depends on it.

On the server side, procedures in the DBMS_AQADM package create and manage message queues and queue tables. Use the DBMS_AQ package to add or remove messages from a queue or register or unregister an SPL callback procedure. For more information about DBMS_AQ and DBMS_AQADM, see DBMS_AQ in the EDB Postgres Advanced Server documentation.

On the client side, the application uses the EDB-JDBC driver's JMS API to enqueue and dequeue message.

Enqueueing or dequeueing a message

For more information about using EDB Postgres Advanced Server's advanced queueing functionality, see Built-in packages in the EDB Postgres Advanced Server documentation.