List of Tables

1-1 Oracle Streams AQ Demonstrations

1-2 Oracle Streams AQ JMS Demonstrations

1-3 Oracle Streams AQ XML Demonstrations

2-1 Enumerated Constants in the Oracle Streams AQ Administrative Interface

2-2 Enumerated Constants in the Oracle Streams AQ Operational Interface

3-1 Oracle Streams AQ Programmatic Interfaces

3-2 Comparison of Oracle Streams AQ Programmatic Interfaces: Administrative Interface

3-3 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Create Connection, Session, Message Use Cases

3-4 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Enqueue Messages to a Single-Consumer Queue, Point-to-Point Model Use Cases

3-5 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Publish Messages to a Multiconsumer Queue/Topic, Publish/Subscribe Model Use Cases

3-6 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Subscribing for Messages in a Multiconsumer Queue/Topic, Publish/Subscribe Model Use Cases

3-7 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Browse Messages in a Queue Use Cases

3-8 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Receive Messages from a Queue/Topic Use Cases

3-9 Comparison of Oracle Streams AQ Programmatic Interfaces: Operational Interface-Register to Receive Messages Asynchronously from a Queue/Topic Use Cases

4-1 Operations and Required Privileges for 8.1-Style and Higher Queues

9-1 DBA_QUEUE_TABLES View

9-2 ALL_QUEUE_TABLES View

9-3 DBA_QUEUES View

9-4 DBA_QUEUE_SCHEDULES View

9-5 ALL_QUEUES View

9-6 QUEUE_PRIVILEGES View

9-7 AQ$Queue_Table_Name View

9-8 USER_QUEUE_TABLES View

9-9 USER_QUEUES View

9-10 DBA_QUEUE_SCHEDULES View

9-11 AQ$Queue_Table_Name_S View

9-12 AQ$Queue_Table_Name_R View

9-13 DBA_QUEUE_SUBSCRIBERS View

9-14 USER_QUEUE_SUBSCRIBERS View

9-15 ALL_QUEUE_SUBSCRIBERS View

9-16 GV$AQ View

9-18 AQ$INTERNET_USERS View

9-19 DBA_TRANSFORMATIONS View

9-20 DBA_ATTRIBUTE_TRANSFORMATIONS View

9-21 USER_TRANSFORMATIONS View

9-22 USER_ATTRIBUTE_TRANSFORMATIONS View

11-1 StreamMessage Conversion

11-2 MapMessage Conversion

11-3 Oracle Streams AQ and Oracle JMS Buffered Messaging Constants

18-1 SID_DESC Parameters

19-1 WebSphere MQ Link Properties

19-2 Optional Configuration Properties for WebSphere MQ Base Java

19-3 Optional Configuration Properties for WebSphere MQ JMS

19-4 TIB/Rendezvous Link Properties

19-5 Optional Properties for TIB/Rendezvous

20-1 MGW Names for WebSphere MQ Header Values

20-2 Default Priority Mappings for Propagation

20-3 TIB/Rendezvous Datatype Mapping

20-4 TIB/Rendezvous and MGW Names for Oracle Streams AQ Message Properties

20-5 Oracle JMS Message Conversion

22-1 Propagation Between Different Types of Queues

A-1 Actions Performed for Nonpersistent Queues When RAW Presentation Specified

A-2 Actions Performed for Nonpersistent Queues When XML Presentation Specified