AQ Administrative Interfaces

Table 3-2 lists the equivalent AQ administrative functions for the three programmatic environments, PL/SQL, Java (native AQ), and Java (JMS):

Table 3-2 Comparing AQ Programmatic Environments: Administrative interfaces  

Use Case	PL/SQL	Java (native AQ)	Java (JMS)
Create a Connection Factory	N/A	N/A	AQjmsFactory.getQueueConnectionFactory AQjmsFactory.getTopicConnectionFactory
Create a Queue Table	DBMS_AQADM.create_queue_table	Create AQQueueTableProperty, then AQSession.createQueueTable	AQjmsSession.createQueueTable
Get a Queue Table	Use <schema>.<queue_table_name>	AQSession.getQueueTable	AQjmsSession.getQueueTable
Alter a Queue Table	DBMS_AQADM.alter_queue_table	AQQueueTable.alter	AQQueueTable.alter
Drop a Queue Table	DBMS_AQADM.drop_queue_table	AQQueueTable.drop	AQQueueTable.drop
Create a Queue	DBMS_AQADM.create_queue	AQSession.createQueue	AQjmsSession.createQueue
Get a Queue	Use <schema>.<queue_name>	AQSession.getQueue	AQjmsSession.getQueue
Create a Non-persistent Queue	DBMS_AQADM.create_np_queue	Not supported	Not supported
Create a Multi-consumer Queue/Topic	DBMS_AQADM.create_queue in a queue table with multiple consumers enabled	AQSession.createQueue in a queue table with multiple consumers enabled	AQjmsSession.createTopic in a queue table with multiple consumers enabled
Get a Multi-consumer Queue/Topic	Use <schema>.<queue_name>	AQSession.getQueue	AQjmsSession.getTopic
Alter a Queue/Topic	DBMS_AQADM.alter_queue	AQQueue.alterQueue	AQjmsDestination.alter
Start a Queue/Topic	DBMS_AQADM.start_queue	AQQueue.start AQQueue.startEnqueue AQQueue.startDequeue	AQjmsDestination.start
Stop a Queue/Topic	DBMS_AQADM.stop_queue	AQQueue.stop AQQueue.stopEnqueue AQQueue.stopDequeue	AQjmsDestination.stop
Drop a Queue/Topic	DBMS_AQADM.drop_queue	AQQueue.drop AQQueueTable.dropQueue	AQjmsDestination.drop
Grant System Privileges	DBMS_AQADM.grant_system_privilege	Not supported	AQjmsSession.grantSystemPrivilege
Revoke System Privileges	DBMS_AQADM.revoke_system_privilege	Not supported	AQjmsSession.revokeSystemPrivilege
Grant a Queue/Topic Privilege	DBMS_AQADM.grant_queue_privilege	AQQueue.grantQueuePrivilege	AQjmsDestination.grantQueuePrivilege AQjmsDestination.grantTopicPrivilege
Revoke a Queue/Topic Privilege	DBMS_AQADM.revoke_queue_privilege	AQQueue.revokeQueuePrivilege	AQjmsDestination.revokeQueuePrivilege AQjmsDestination.revokeTopicPrivilege
Verify a Queue Type	DBMS_AQADM.verify_queue_types	Not supported	Not supported
Add a Subscriber1	DBMS_AQADM.add_subscriber	AQQueue.addSubscriber	See Table 3-3, "Comparing AQ Programmatic Environments: Operational Interfaces"
Alter a Subscriber	DBMS_AQADM.alter_subscriber	AQQueue.alterSubscriber	See Table 3-3, "Comparing AQ Programmatic Environments: Operational Interfaces"
Remove a Subscriber	DBMS_AQADM.remove_subscriber	AQQueue.removeSubscriber	See Table 3-3, "Comparing AQ Programmatic Environments: Operational Interfaces"
Schedule Propagation	DBMS_AQADM.schedule_propagation	AQQueue.schedulePropagation	AQjmsDestination.schedulePropagation
Enable a Propagation Schedule	DBMS_AQADM.enable_propagation_schedule	AQQueue.enablePropagationSchedule	AQjmsDestination.enablePropagationSchedule
Alter a Propagation Schedule	DBMS_AQADM.alter_propagation_schedule	AQQueue.alterPropagationSchedule	AQjmsDestination.alterPropagationSchedule
Disable a Propagation Schedule	DBMS_AQADM.disable_propagation_schedule	AQQueue.disablePropagationSchedule	AQjmsDestination.disablePropagationSchedule
Unschedule a Propagation	DBMS_AQADM.unschedule_propagation	AQQueue.unschedulePropagation	AQjmsDestination.unschedulePropagation

1 Refer to Chapter 1, "What is Oracle Advanced Queuing?" for the differences between subscriber and recipient.