AQQueueAdmin - Oracle 9i

Methods
start

public void start(boolean enqueue,boolean dequeue) throws AQException

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

enable enqueue and dequeue on this queue.
startEnqueue

public void startEnqueue() throws AQException

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.

disable enqueue/dequeue on this queue

disable enqueue/dequeue on this queue

stopEnqueue

public void stopEnqueue(boolean wait) throws AQException

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

stopEnqueue

stopDequeue

public void stopDequeue(boolean wait) throws AQException

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

stopDequeue

drop

public void drop() throws AQException

This method is used to drop a queue

alterQueue

public void alterQueue(AQQueueProperty property) throws AQException

This method is used to alter queue properties

alterQueue

addSubscriber

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

addSubscriber

removeSubscriber

public void removeSubscriber(AQAgent subscriber) throws AQException

This method removes a subscriber from a queue.

removeSubscriber

alterSubscriber

public void alterSubscriber(AQAgent subscriber,java.lang.String rule) throws AQException

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.

grantQueuePrivilege

revokeQueuePrivilege

This method is used to revoke a queue privilege.

revoke a queue privilege.

schedulePropagation

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

schedulePropagation

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.

unschedulePropagation

alterPropagationSchedule

This method is used to alter a propagation schedule.

alterPropagationSchedule

enablePropagationSchedule

public void enablePropagationSchedule(java.lang.String destination)
throws AQException

This method is used to enable a propagation schedule.

enablePropagationSchedule

disablePropagationSchedule

public void disablePropagationSchedule(java.lang.String destination)
throws AQException

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


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Oracle 9i Topics