AQQueueAdmin - Oracle 9i

Methods
start

This method is used to enable enqueue and dequeue on this queue.

startEnqueue

This method is used to enable enqueue on this queue. This is equivalent to start(TRUE, FALSE)

startDequeue

public void startEnqueue() throws AQException

This method is used to enable dequeue on this queue. This is equivalent to start(FALSE, TRUE).

stop

This method is used to disable enqueue/dequeue on this queue.

stopEnqueue

This method is used to disable enqueue on a queue. This is equivalent to stop(TRUE, FALSE, wait).

stopDequeue

This method is used to disable dequeue on a queue. This is equivalent to stop(FALSE, TRUE, wait).

drop

This method is used to drop a queue

alterQueue

This method is used to alter queue properties

addSubscriber

This method is used to add a subscriber for this queue.

removeSubscriber

This method removes a subscriber from a queue.

alterSubscriber

This method alters properties for a subscriber to a queue.table9
grantQueuePrivilege

This method is used to grant queue privileges to users and roles. The method has been overloaded. The second implementation is equivalent to calling the first implementation with grant_option = FALSE.

revokeQueuePrivilege

This method is used to revoke a queue privilege.

schedulePropagation

This method is used to schedule propagation from a queue to a destination identified by a database link.

unschedulePropagation

This method is used to unschedule a previously scheduled propagation of messages from the current queue to a destination identified by a specific database link.

alterPropagationSchedule

This method is used to alter a propagation schedule.

enablePropagationSchedule

This method is used to enable a propagation schedule.

disablePropagationSchedule

This method is used to disable a propagation schedule.

Examples

Set up the test_aqjava class. For more information, see "Setup for oracle.AQ Examples"

1. Create a queue and start enqueue/dequeue

2. Create a multi-consumer queue and add subscribers