Contents
- Intended Audience
- Structure
- Related Documents
- Conventions
- Documentation Accessibility
- Oracle Streams AQ Release 10.1 New Features
- Oracle9i Release 2 (9.2.0) New Features
- Oracle9
i Release 1 (9.0.1) New Features in Oracle Streams AQ
- Oracle8i New Featur
es in Oracle Streams AQ
- Overview of Oracle Streams AQ
- Oracle Streams AQ in Integrated Application Environments
- Oracle Streams AQ Client/Server Communication
- Multiconsumer Dequeuing of the Same M
essage
- Oracle Streams AQ Implementation of Workflows
- Oracle Streams AQ Implementation of Publish/Subscribe
- Message Propagation<
/dd>
- Message Format Transformation
- Internet Integrat
ion and Internet Data Access Presentation
-
- Internet Message Payloads
<
dd>Propagation over the Internet Using HTTP
- Internet Dat
a Access Presentation (IDAP)
Interfaces to Oracle Streams AQ
Oracle Streams AQ Features
- Enqueue Features
- Dequeue Features
- Propagation Features
Other Oracle Streams AQ Features
Oracle St
reams AQ Demos
- Oracle Streams AQ Prerequisites<
/a>
- Oracle Streams AQ by Example
-
- Cr
eating Oracle Streams AQ Queues and Queue Tables
- Enqueuing and Dequeuing Oracle Streams
AQ Messages
- Oracle Streams AQ Propagation
- Dropping Oracle Streams AQ Objects
- Revoking Roles and Privileges
- Deploying Oracle Streams AQ with XA
- Oracle Streams AQ and Mem
ory Usage
- Frequently Asked Questions
-
- Oracle Streams AQ Installation Questions
- General Oracle Streams AQ Ques
tions
- Transformation Questions
- Object Name (object_name)
- Type Name (type_name)
- AQ Agent Type (aq$_agent)
- AQ Recipient List Type (aq$_recipien
t_list_t)
- AQ Agent List Type (aq$_agent_list_t)
- AQ Subscriber List Type (aq$_subscriber_list_t)
- AQ Registration Information List
Type (aq$_reg_info_list)
- AQ Post Information List Type (aq$_post_info_list)
<
dd>AQ Registration Information Type (aq$_reg_info)
- AQ
Notification Descriptor Type
- AQ Post Information Type
- Enumerated Constants in the Oracle Streams AQ Administrative Interface
- Enu
merated Constants in the Oracle Streams AQ Operational Interface
- INIT.ORA Parameter Fil
e Considerations
-
- AQ_TM_PROCESSES Parameter No Longer Needed in init.ora
- JOB_QUEUE_PROCESSES Parameter
Programmatic Environments for Accessing Oracle Streams AQ
Using PL/SQL to Access Oracle Streams AQ
Using OCI to Access Oracle Streams
AQ
Using OCCI to Access Oracle Streams AQ
Using Visual Basic (OO4O) to Access Oracle Streams AQ
Using Oracle Java Message Servic
e (OJMS) to Access Oracle Streams AQ
- Accessing Standard and Oracle JMS Applic
ations
Using Oracle Streams AQ XML Servlet to Access Oracle Streams AQ
Comparing Oracle Streams AQ Programmatic Environments
- Oracle Streams AQ Administrative Interfaces
- Oracle Streams AQ Operatio
nal Interfaces
- Oracle Streams AQ Compatibility P
arameters
- Queue Security and Access Control
-
- Oracle Streams AQ Security
-
- Administrator Role
- User Role
- Access to Oracle Streams AQ Object Types
- Queue Security
- Queue Privileges and Access Control
- OCI Applications and Queue Access
- Security Requ
ired for Propagation
- Queue Table Export-Import
-
- Exporting Queue Table Data
- Importing Queue Table Data
-
Data Pump Export and Import
- Creating Oracle Stre
ams AQ Administrators and Users
- Oracle Enterprise Manager Support
- Using Oracle Streams AQ with XA
- Restrictions on Queue Management
-
- Remote Subscribers
- DML Not Supported o
n Queue Tables or Associated IOTs
- Propagation from Object Queues with REF Payload Attribu
tes
- Collection Types in Message Payloads
- Syno
nyms on Queue Tables and Queues
- Tablespace Point-in-Time Recovery
- Nonpersistent Queues
- Managing Propagation
-
- EXECUTE Privileges Required for Propagation
- The Num
ber of Job Queue Processes
- Optimizing Propagation
- Message States During Client Requests for Enqueue
- Propagation from Object Queues
- Debugging Oracle Streams AQ Propagation Problems
8.0-Compatible Queues
- Migrating To and From 8.0
- Importing and Exporting with 8.0-Style Queues
- Roles in 8.0
- Security with 8.0-Style Queues
- Access to Oracle Str
eams AQ Object Types
- OCI Application Access to 8.0-Style Queues
- Pluggable Tablespaces and 8.0-Style Multiconsumer Queues
- Autocommit Fe
atures in the DBMS_AQADM Package
- Performance Overview
-
- Oracle Streams AQ and Oracle Real Application Clusters
- Oracle Streams AQ in a Shared Server Environment
- Basic Tuning Tips
-
- Using Storage Parameters
- I/O Configuration
- Running Enqueue and Dequeue Processes Concurr
ently in a Single Queue Table
- Running Enqueue and Dequeue Processes Serially in a Single
Queue Table
- Creating Indexes on a Queue Table
- Propagation Tuning Tips
- A Sample
Application
- General Features of Oracle Streams AQ
- System-Level Access Control
- Queue-Level Access Control
- Message Format Transformation
-
- Creating Transformations
<
/dl>
- Structured Payloads
-
- Creating Queue
s with XMLType Payloads
- Nonpersistent Queues
- Retention and Message History
- Publish/Subscribe Support
- Oracle Real Application Clusters Support
- Statistics Views and Oracle
Streams AQ
- Internet Access for Oracle Streams AQ
- Enqueue Features
-
- Subscriptions and Recipient Lists
- Priority and Ordering of Messages
- Time Specification: Delay
- Time Specification: Expiration
- Message Grouping
- Message Transformation During Enqueue
- Enqueue Usin
g the Oracle Streams AQ XML Servlet
- Dequeue Features
-
- Dequeue Methods
- Multiple Recipients
- Local and Remote Recipients
- Message Navigation in Dequeue
- Modes of Dequeuing
- Optimization of Waiting for Arrival of
Messages
- Retry with Delay Interval
- Exception Handling
-
- Rule-Based Subscription
- Listen Capability
- Message Transformation During Dequeue
- Dequeue Using the Oracle Streams AQ XML Servlet
- Asynchronou
s Notifications
-
- Registering for Notifications Using the Oracle Streams AQ XML S
ervlet
- Propagation Features
-
- Propagation Overview
- Propagation Scheduling
- Propagation of Messages with LOB Attributes
- Enhanced Propagation Scheduling Capabilitie
s
- Exception Handling During Propagation
- Messa
ge Format Transformation During Propagation
- Propagation Using HTTP
- Managing Queue Tables
-
- Creating a Queue Table
- Altering a Queu
e Table
- Dropping a Queue Table
- Purging a
Queue Table
- Migrating a Queue Table
- Managing Queues
-
- Creating a Queue
- Creating a Nonpersistent Queue
- Altering a Queue
- Dropping a Queue
- Starting a Queue
- Stopping a Queue
- Managing Transformations
-
- Creating a Transformation
- Modifying a Transformation
- Dropping a Transformation
- Granting an
d Revoking Privileges
-
- Granting System Oracle Streams AQ Privileges
<
dd>Revoking Oracle Streams AQ System Privileges
- Granti
ng Queue Privileges
- Revoking Queue Privileges
Managing Subscribers
- Adding a Subscriber
- Altering a Subscriber
- Removing a Subscriber
Managing Propagations
- Scheduling a Queu
e Propagation
- Unscheduling a Queue Propagation
- Verifying Propagation Queue Type
- Altering a Propagation Schedule
- Enabling a Propagation Schedule
- Disabling a Propagation S
chedule
Managing Oracle Streams AQ Agents
- Creating an Oracle Streams AQ Agent
- Altering an Oracle Streams AQ
Agent
- Dropping an Oracle Streams AQ Agent
- Enabling Database Access
- Disabling Database Access
Adding an Alias to the LDAP Server
Deleting an Alias from the LDAP
Server
- All Queue Tables in Database
View
- User Queue Tables View
- All Queues i
n Database View
- All Propagation Schedules View
- Queues for Which User Has Any Privilege View
- Queues for Which User Has Queue Priv
ilege View
- Messages in Queue Table View
- Q
ueue Tables in User Schema View
- Queues In User Schema View
- Propagation Schedules in User Schema View
- Queue Subscribers View<
/dd>
- Queue Subscribers and Their Rules View
- Number
of Messages in Different States for the Whole Database View
- Number of Messages in Diff
erent States for Specific Instances View
- Oracle Streams AQ Agents Registered for Intern
et Access View
- All Transformations View
- A
ll Transformation Functions View
- User Transformations View
- User Transformation Functions View
- Enqueuing a Message
-
- Enqueuing a Message and Specify
ing Options
-
- Using Secure Queues
- Enqueuing a Message and Specifying Message Properties
- Enqueuing a Message an
d Specifying Sender ID
- Enqueuing a Message and Adding Payload
- Enqueuing an Array of Messages
- Listening to One or More
Queues
- Dequeuing a Message
-
- Dequ
euing a Message from a Single-Consumer Queue and Specifying Options
- Dequeuing a Message
from a Multiconsumer Queue and Specifying Options
- Dequeuing an Array of Mess
ages
- Registering for Notification
- Posting
for Subscriber Notification
- Adding an Agent to the LDAP Server
- Removing an Agent from the LDAP Server
- <
a href="jm_create.htm#sthref762">General Features of JMS and Oracle JMS
-
- J2EE
Compliance
-
- JMSPriority
- JMSEx
piration
- Durable Subscribers
-
JMS Connection and Session
-
- ConnectionFactory Objects
- Using AQjmsFactory to Obtain ConnectionFactory Objects
- Using J
NDI to Look Up ConnectionFactory Objects
- JMS Connection
- JMS Session
- JMS Connection Examples
- JMS Destination
-
- Using a JMS Session to Obtain Destin
ation Objects
- Using JNDI to Look Up Destination Objects
- JMS Destination Methods
- JMS Destination Examples
<
dd>System-Level Access Control in JMS
- Destination-Le
vel Access Control in JMS
- Retention and Message History in JMS
- Supporting Oracle Real Application Clusters in JMS
- Supporting
Statistics Views in JMS
Structured Payload/Message Types in JMS
- JMS Message Headers
- JMS Message Propertie
s
- JMS Message Body
-
- The AQ$_JM
S_MESSAGE Type
- JMS Message Body: Stream Message
- JMS Message Body: Bytes Message
- JMS Message Body: Map Message
- JMS Message Body: Text Message
- JMS Message B
ody: Object Message
- JMS Message Body: AdtMessage
JMS Point-to-Point Model Features
- Queues
- QueueSender
- QueueReceiver
- QueueBrowser
JMS Publish/Subscribe Model Features
- Topic
- Durable Subscriber
TopicPublisher
Recipient Lists
TopicReceiver
TopicBrowser
JMS MessageProducer Features
- Priority and Ordering
of Messages
- Time Specification - Delay
- Time Specification - Expiration
- Message Grouping
JMS Message Consumer Features
- Receiving Messages
- Message Navigation in Receive
- Browsing Messag
es
- Retry with Delay Interval
- Asynchrono
usly Receiving Messages Using Message Listener
- Oracle Streams AQ Exception Handling
JMS Propagation
- Remote
Subscribers
- Scheduling Propagation
- Enh
anced Propagation Scheduling Capabilities
- Exception Handling During Propagation
Message Transformation with JMS AQ
- Defining Message Transformations
- Sending Messages to a Destination Using a T
ransformation
- Receiving Messages from a Destination Using a Transformation
Specifying Transformations for Topic Subscribers
S
pecifying Transformations for Remote Subscribers
- EXECUTE Privilege on DBMS_AQIN
- Registering a Queue/Topic Conne
ction Factory
-
- Registering Through the Database Using JDBC Connection Paramete
rs
- Registering Through the Database Using a JDBC URL
- Registering Through LDAP Using JDBC Connection Parameters
- Registering Throu
gh LDAP Using a JDBC URL
- Unregistering a Queue/Topic Connection Factory
-
- Unregistering Through the Database
- U
nregistering Through LDAP
- Getting a Queue/Topic Connection Factory
<
dd>
- Getting a Queue Connection Factory with JDBC URL
- Getting a Queue Connection Factory with JDBC Connection Parameters
- Getting a Top
ic Connection Factory with JDBC URL
- Getting a Topic Connection Factory with JDBC Connec
tion Parameters
- Getting a Queue/Topic Connection Factory in LDAP
- Getting a Queue/Topic in LDAP
- Creating a Queue Table<
/a>
- Getting a Queue Table
- Creating a Queue
-
- Creating a Point-to-Point Queue
- C
reating a Publish/Subscribe Topic
- Granting and Revoking Privileges
<
dd>
- Granting Oracle Streams AQ System Privileges
- Revoking Oracle Streams AQ System Privileges
- Granting Publish/Subscribe Topic Privi
leges
- Revoking Publish/Subscribe Topic Privileges
- Granting Point-to-Point Queue Privileges
- Revoking Point-to-Point Queue Privile
ges
- Managing Destinations
-
- Starting a Destination
- Stopping a Destination
- Altering a Destination
- Dropping a Destination
- Propagation Schedules
-
- Scheduling a Propagation
- Enabling a Propagation Schedule
- Altering a Pro
pagation Schedule
- Disabling a Propagation Schedule
- Unscheduling a Propagation
- Creating a Connection
-
- Creating a Connection with Use
rname/Password
- Creating a Connection with Default Connection Factory Parameters
- Creating a Queue Connection
-
- Creating a Queue Connection with Username/Password
- Creating a Queue Connection with
an Open JDBC Connection
- Creating a Queue Connection with Default Connection Factory P
arameters
- Creating a Queue Connection with an Open OracleOCIConnection Pool
- Creating a Session
- Creating a QueueSess
ion
- Creating a QueueSender
- Sending Mess
ages
-
- Sending Messages Using a QueueSender with Default Send Options
- Sending Messages Using a QueueSender by Specifying Send Options
- Creating a QueueBrowser
-
- Queues with Text, Stream,
Objects, Bytes or Map Messages
- Queues with Text, Stream, Objects, Bytes, Map Messages
, Locking Messages
- Queues of Oracle Object Type Messages
- Queues of Oracle Object Type Messages, Locking Messages
- Cr
eating a QueueReceiver
-
- Queues of Standard JMS Type Messages
- Queues of Oracle Object Type Messages
- Creating a Connection
-
- Creating a Connection with Username/Password
- Creating a Connection with Default Co
nnection Factory Parameters
- Creating a TopicConnection
-
Creating a TopicConnection with Username/Password
-
Creating a TopicConnection with Open JDBC Connection
- Creating a TopicConnection with D
efault Connection Factory Parameters
- Creating a TopicConnection with an Open OracleOCI
ConnectionPool
Creating a Session
Creating a TopicSession
Creating a TopicPublisher
Publishing a Message
- TopicPublisher with Minimal Specificati
on
- TopicPublisher and Specifying Correlation and Delay
- TopicPublisher and Specifying Priority and TimeToLive
- TopicPublisher a
nd Specifying a Recipient List Overriding Topic Subscribers
Creating a Durab
le Subscriber
- Creating a Durable Subscriber for a JMS Topic Without Selector
- Creating a Durable Subscriber for a JMS Topic With Selector
- Creating a Durable Subscriber for an Oracle Object Type Topic Without Selector
- Creating a Durable Subscriber for an Oracle Object Type Topic With Selector
Creating a Remote Subscriber
- Creating a Remote Subscriber for
Topics of JMS Messages
- Creating a Remote Subscriber for Topics of Oracle Object Type
Messages
Unsubscribing a Durable Subscription
- Unsubscribing a Durable Subscription for a Local Subscriber
- Unsubscribing a Durable Subscription for a Remote Subscriber
Creating a Top
icReceiver
- Creating a TopicReceiver for a Topic of Standard JMS Type Message
s
- Creating a TopicReceiver for a Topic of Oracle Object Type Messages
Creating a TopicBrowser
- Topics with
Text, Stream, Objects, Bytes or Map Messages
- Topics with Text, Stream, Objects, Bytes
, Map Messages, Locking Messages
- Topics of Oracle Object Type Messages
- Topics of Oracle Object Type Messages, Locking Messages
Browsing Messages Using a TopicBrowser
- Oracle Streams AQ JMS Operational Interface: Shared Interfaces
-
- AQjmsConnection.start
- AQjmsSession.getJmsConnection
- AQjmsSession.commit
- AQjmsSession.rollback
- <
a href="jm_share.htm#sthref1067">AQjmsSession.getDBConnection
- AQjmsConnection.getOCICo
nnectionPool
- AQjmsSession.createBytesMessage
- AQjmsSession.createMapMessage
- AQjmsSession.createStreamMessage
- AQjmsSession.createObjectMessage
- AQjmsSession.createText
Message
- AQjmsSession.createMessage
- AQjm
sSession.createAdtMessage
- AQjmsMessage.setJMSCorrelationID
- Specifying JMS Message Property
-
- AQjmsMessage.s
etBooleanProperty
- AQjmsMessage.setStringProperty
- AQjmsMessage.setIntProperty
- AQjmsMessage.setDoubleProperty
- AQjmsMessage.setFloatProperty
- AQjmsMessage.setByteProper
ty
- AQjmsMessage.setLongProperty
- AQjmsMe
ssage.setShortProperty
- AQjmsMessage.setObjectProperty
- Setting Default TimeToLive for All Messages Sent by a MessageProducer
- Setting Default Priority for All Messages Sent by a MessageProducer
- Creating
an AQjms Agent
- Receiving a Message Synchronously
-
- Using a Message Consumer by Specifying Timeout
- Using a Message Con
sumer Without Waiting
- Specifying the Navigation Mode for Receiving Messages<
/a>
- Receiving a Message Asynchronously
-
- Specifying a Message Listener at the Message Consumer
- Specifying a Message Liste
ner at the Session
- Getting Message ID
-
- AQjmsMessage.getJMSCorrelationID
- AQjmsMessage.getJMSMessageID
- Getting the JMS Message Properties
-
- AQjmsMessage.getBooleanProperty
- AQjmsMessage.getStringProperty
- AQjmsMessage.getIntProperty
- AQjmsMessage.getDoubleP
roperty
- AQjmsMessage.getFloatProperty
- A
QjmsMessage.getByteProperty
- AQjmsMessage.getLongProperty
- AQjmsMessage.getShortProperty
- AQjmsMessage.getObjectProperty
- Closing and Shutting Down
-
-
AQjmsProducer.close
- AQjmsConsumer.close
- AQjmsConnection.stop
- AQjmsSession.close
- AQjmsConnection.close
- Troubleshooting
-
- AQjmsException.getErrorCode
- AQjmsException.getErrorNumber
- AQjmsException.getLinkString
- AQjmsException.pr
intStackTrace
- AQjmsConnection.setExceptionListener
- AQjmsConnection.getExceptionListener
- How to Run the Oracle Streams AQ JMS Type Examples
-
- Setting Up th
e Examples
- JMS Bytes Message Examples
- JMS Stream Message Examples
- JMS Map Message Examples
- More Oracle Streams AQ JMS Examples
- Overview of Oracle Streams AQ Operations over the Internet
- Internet D
ata Access Presentation (IDAP)
-
- SOAP Message Structure
-
- The SOAP Envelope
- SOAP Headers
- The SOAP Body
- SOAP Method Invocation
-
- HTTP Headers
- Method Invocation Body
- Results from a Method Request
- IDAP Documents
-
- IDAP Client Requests for Enqueue
- IDAP Client Requests for Dequeue
- IDAP Client Requests for Reg
istration
- IDAP Client Requests to Commit a Transaction
- IDAP Client Requests to Rollback a Transaction
- IDAP Server Response to
Enqueue
- IDAP Server Response to a Dequeue Request
- IDAP Server Response to a Register Request
- IDAP Commit Response
<
dd>IDAP Rollback Response
- IDAP Notification
- IDAP Response in Case of Error
SOAP a
nd Oracle Streams AQ XML Schemas
- SOAP Schema
- IDAP Schema
Deploying the Oracle Streams AQ XML Servlet<
/dd>
- Creating the Oracle Streams AQ XML Servlet Class
- Compiling the Oracle Streams AQ XML Servlet
- Configuring the Web server
to Authenticate Users Sending POST Requests
-
- Using HTTP
<
dd>Authorizing Users to Perform Operations with Oracle Streams AQ Servlet
- Registering the Oracle Streams AQ Agent
- Mapping the Or
acle Streams AQ Agent to Database Users
- Database Sessions
Using an LDAP Server with an Oracle Streams AQ XML Servlet
Using HTTP to Access the Oracle Streams AQ XML Servlet
- User Sess
ions and Transactions
Using HTTP and HTTPS for Oracle Streams AQ Propagation
- High-Level Architecture
-
- Setting Up for HTTP Propagation
- Setting Up for Oracle Streams AQ Propagation ove
r HTTP
Customizing the Oracle Streams AQ Servlet
- Setting the Connection Pool Size
- Setting the S
ession Timeout
- Specifying the Style Sheet for All Responses from the Servlet
- Callbacks Before and After Oracle Streams AQ Operations
Frequently Asked Questions: Using Oracle Streams AQ and the Internet
- Internet Access Questions
- Oracle Internet Directory Questions
