Oracle9i Application Developer's Guide - Advanced Queuing -- Index

access control. See system-level access control, 4-4, 8-2

adding a subscriber, 9-58

administration

Messaging Gateway, 18-3

See also DBMS_MGWADM package

administration user

creating, 18-11

example, 18-11

administrative interface, 4-4, 9-1

basic operations, 13-2

use cases, 13-2

views, 10-1, 10-2

AdtMessage, 12-29

Advanced Queuing

operations over the Internet, 17-2

agent, 1-22

identifying, 2-3, 2-4

agent. See AQ agent, 9-92

agent. See gateway agent

agent user

creating, 18-11

example, 18-11

altering

destination, 13-54

messaging gateway links, 18-17

registered non-Oracle queues, 18-19

schedules, 18-22

subscribers, 18-22

AQ agent

altering, 9-92

creating, 9-90

dropping, 9-94

registering, 17-52

AQ queues

registering, 18-20

AQ servlet, 17-2

AQ XML

requests, using SMTP, 17-55

schema, 17-33

servlet, 17-48, 17-54

AQ XML servlet

registering for notifications, 8-105

AQ_TM_PROCESSES, 2-10

AQjmsQueueConnectionFactory, B-52

AQXmlPublish method, 17-7

AQXmlReceive method, 17-20

AQXmlSend method, 17-7

asynchronous notification, 1-17, 8-97

asynchronously receiving message, 12-76

BooksOnLine sample application, 8-1

using JMS, 12-2

bytes message, 12-27

C. See Oracle Call Interface (OCI)

Class - AQjmsQueueConnectionFactory, B-52

Class - oracle.AQ.AQQueueTableProperty, B-58

Class - oracle.jms.AQjmsAdtMessage, B-44

Class - oracle.jms.AQjmsAgent, B-45

Class - oracle.jms.AQjmsBytesMessage, B-45

Class - oracle.jms.AQjmsConnection, B-46

Class - oracle.jms.AQjmsConstants, B-46

Class - oracle.jms.AQjmsDestination, B-47

Class - oracle.jms.AQjmsDestinationProperty, B-48

Class - oracle.jms.AQjmsFactory, B-49

Class - oracle.jms.AQjmsMapMessage, B-50

Class - oracle.jms.AQjmsObjectMessage, B-51

Class - oracle.jms.AQjmsOracleDebug, B-51

Class - oracle.jms.AQjmsProducer, B-52

Class - oracle.jms.AQjmsQueueBrowser, B-52

Class - oracle.jms.AQjmsSession, B-53

Class - oracle.jms.AQjmsStreamMessage, B-55

Class - oracle.jms.AQjmsTextMessage, B-55

Class - oracle.jms.AQjmsTopicConnectionFactory, B-55

Class oracle.jms.AQjmsException, B-56

classes, B-1

Classes, JMS, B-5

commit response, 17-31

commit transaction, 17-26

commonly asked questions. See frequently asked questions, 6-1

compositing, 7-14

configuring

connection information, 18-11

messaging gateway links, 18-15

propagation jobs, 18-20

See DBMS_MGWADM.DB_CONNECT_INFO procedure

connection factory

queue/topic, LDAP, 13-25

topic, with JDBC URL, 13-21

unregistering in LDAP through database, 13-13

unregistering in LDAP through LDAP, 13-15

connection information

configuring, 18-11

example, 18-13

consumers, 7-5

correlation identifier, 1-15

creating

administration user, 18-11

agent user, 18-11

messaging gateway links, 18-15

point-to-point queue, 13-35

queue, 9-20

queue table, 13-28, 13-30

queue tables and queues, examples, A-4

schedules, 18-21

subscribers, 18-20

creating publish-subscribe topic, 13-37

creation of prioritized message queue table and queue, A-5

creation of queue table and queue of object type, A-4

creation of queue table and queue of RAW type, A-5

database

design and modeling, 7-1

tuning, 5-2

database access

enabling, 9-96

database objects

loading, 18-7

database session, 17-53

DBA_ATTRIBUTE_TRANSFORMATIONS, 10-41

DBA_QUEUE_TABLES, 10-4, 10-6, 10-22

DBA_QUEUES, 10-8

DBA_TRANSFORMATIONS, 10-40

DBMS_AQADM package, 4-2

DBMS_AQADM.DROP_QUEUE, 9-18

DBMS_MGWADM package, 18-3

DBMS_MGWADM.DB_CONNECT_INFO procedure

configuring Messaging Gateway, 18-13

example, 18-11

delay, 2-9

time specification, 12-59

delay interval

retry with, 8-77

time specification, 8-45

dequeue

client request for, 17-20

dequeue mode, 2-9

dequeue of messages after preview, A-33

dequeue request

server response, 17-28

dequeuing, 11-44

features, 8-58

message navigation, 8-65

methods, 8-58

modes, 1-18, 8-69

multiple-consumer dequeuing of one message, 7-7

navigation of messages, 1-18

same message, multiple-consumer, 7-7

using HTTP, 8-106

destination

altering, 13-54

dropping, 13-56

properties, specifying, 13-33

starting, 13-50

stopping, 13-52

destination-level access control, 12-17

disabling

propagation jobs, 18-22

propagation schedule, 9-87

dropping

destination, 13-56

queue table, 9-17

dropping AQ objects, A-66

durable subscriber, 12-45

e-mail server, 17-2

setup, 17-56

enabling

propagation jobs, 18-22

enqueue

client request for, 17-7

server response, 17-27

enqueue and dequeue of messages

by Correlation and Message Id Using Pro*C/C++, A-38

by priority, A-14, A-16, A-18

examples, A-11

of object type, A-11

of RAW type, A-14, A-16, A-18

of RAW type using Pro*C/C++, A-22, A-25

to/from multiconsumer queues, A-44, A-47

with time delay and expiration, A-37

enqueuing, 11-4, 11-12

features, 8-36

specify message properties, 11-9

specify options, 11-6

enqueuing, priority and ordering of messages, 1-16

Enterprise Manager, 1-7

enumerated constants

administrative interface, 2-8

operational interface, 2-9

error messages, D-1

examples

AQ operations, A-1

exception handling, 1-19, 8-80, 12-80

Exception Handling During Propagation, 12-95, 12-96

exception handling during propagation, 12-92, 12-93

Exception javax.jms.InvalidDestinationException, B-40

Exception javax.jms.InvalidSelectorException, B-40

Exception javax.jms.JMSException, B-40

Exception javax.jms.MesageNotWriteableException, B-42

Exception javax.jms.MessageEOFException, B-41

Exception javax.jms.MessageFormatException, B-41

Exception javax.jms.MessageNotReadableException, B-42

Exception oracle.jms.AQjmsInvalidDestinationException, B-56

Exception oracle.jms.AQjmsInvalidSelectorException, B-56

Exception oracle.jms.AQjmsMessageEOFException, B-57

Exception oracle.jms.AQjmsMessageFormatException, B-57

Exception oracle.jms.AQjmsMessageNotReadableException, B-57

Exception oracle.jms.AQjmsMesssageNotWriteableException, B-57

exception queue, 1-22

exception queues, 18-24

exceptions, B-1

expiration, 2-9

time specification, 8-48

exporting

incremental, 4-6

queue table data, 4-5

fanning-out of messages, 7-14

FAQs. See frequently asked questions, 6-1

features, new, xxxvii

frequently asked questions, 6-1

general questions, 6-1

installation questions, 6-19

Internet access questions, 6-17

JMS questions, 6-16

Messaging Gateway questions, 6-6

Oracle Internet Directory, 6-18

performance questions, 6-19

transformation questions, 6-19

funneling-in of messages. See compositing, 7-14

gateway agent, 18-5

managing, 18-13

gateway links. See messaging gateway links or messaging links

getting

queue table, 13-31

global agents, 6-18

global events, 6-18

global queues, 6-18

granting

system privilege, 9-48

system privileges, 13-39

grouping

message, 12-62

HTTP, 1-12, 17-2, 17-6, 17-52, 17-60

accessing AQ XML servlet, 17-58

AQ operations over, 17-2

headers, 17-5

propagation, 17-62

response, 17-6

HTTPS

propagation, 17-62

IDAP

message, 17-6

schema, 17-35

transmitted over Internet, 17-1

IDAP. See Internet Data Access Presentation, 1-13, 17-3

INIT.ORA parameter, 2-9

installing

Messaging Gateway

prerequisites for the Oracle database, 18-6

verification, 18-11

Interface - javax.jms.BytesMessage, B-22

Interface - javax.jms.Connection, B-24

Interface - javax.jms.ConnectionFactory, B-24

Interface - javax.jms.ConnectionMetaData, B-25

Interface - javax.jms.DeliveryMode, B-25

interface - javax.jms.Destination, B-26

Interface - javax.jms.MapMessage, B-26

Interface - javax.jms.Message, B-27

Interface - javax.jms.MessageConsumer, B-29

Interface - javax.jms.MessageListener, B-30

Interface - javax.jms.MessageProducer, B-30

Interface - javax.jms.ObjectMessage, B-31

Interface - javax.jms.Queue, B-31

Interface - javax.jms.QueueBrowser, B-31

Interface - javax.jms.QueueConnection, B-32

Interface - javax.jms.QueueConnectionFactory, B-32

Interface - javax.jms.QueueReceiver, B-33

Interface - javax.jms.QueueSender, B-33

Interface - javax.jms.QueueSession, B-34

Interface - javax.jms.Session, B-34

Interface - javax.jms.StreamMessage, B-36

Interface - javax.jms.TextMessage, B-37

Interface - javax.jms.Topic, B-37

Interface - javax.jms.TopicSession, B-39

Interface - javax.jms.TopicSubscriber, B-39

Interface - oracle.AQ.AQQueueTable, B-57

Interface - oracle.jms.AdtMessage, B-42

Interface - oracle.jms.AQjmsConnectionMetadata, B-46

Interface - oracle.jms.AQjmsConsumer, B-47

Interface - oracle.jms.AQjmsQueueReceiver, B-42

Interface - oracle.jms.AQjmsQueueSender, B-43

Interface - oracle.jms.AQjmsTopicPublisher, B-43

Interface - oracle.jms.AQjmsTopicReceiver, B-44

Interface - oracle.jms.AQjmsTopicSubscriber, B-44

Interface - oracle.jms.TopicReceiver, B-43

interfaces, classes, and exceptions, B-1

Internet

access, 8-35

Advanced Queuing operations, 17-2

Advanced Queuing operations over, 17-1

AQ operations over, xxvii, 1-2, 1-11

Internet Data Access Presentation (IDAP), 1-13, 17-3

Java API, 2-10

Java. See JDBC

javax.jms.BytesMessage, B-22

javax.jms.Connection, B-24

javax.jms.ConnectionFactory, B-24

javax.jms.ConnectionMetaData, B-25

javax.jms.DeliveryMode, B-25

javax.jms.Destination, B-26

javax.jms.InvalidDestinationException, B-40

javax.jms.InvalidSelectorException, B-40

javax.jms.JMSException, B-40

javax.jms.MapMessage, B-26

javax.jms.MesageNotWriteableException, B-42

javax.jms.Message, B-27

javax.jms.MessageConsumer, B-29

javax.jms.MessageEOFException, B-41

javax.jms.MessageFormatException, B-41

javax.jms.MessageListener, B-30

javax.jms.MessageNotReadableException, B-42

javax.jms.MessageProducer, B-30

javax.jms.ObjectMessage, B-31

javax.jms.Queue, B-31

javax.jms.QueueBrowser, B-31

javax.jms.QueueConnection, B-32

javax.jms.QueueConnectionFactory, B-32

javax.jms.QueueReceiver, B-33

javax.jms.QueueSender, B-33

javax.jms.QueueSession, B-34

javax.jms.Session, B-34

javax.jms.StreamMessage, B-36

javax.jms.TextMessage, B-37

javax.jms.Topic, B-37

javax.jms.TopicConnection, B-37

javax.jms.TopicSession, B-39

javax.jms.TopicSubscriber, B-39

JDBC, 3-6

connection parameters, registering through LDAP, 13-8

connection parameters, registering through the database, 13-4

connection parameters, topic connection factory, 13-23

JDBC URL

registering through LDAP, 13-11

registering through the database, 13-6

JMS

examples payload, 12-32

JMS classes, B-1

JMS exceptions, B-1

JMS Extension, 3-8

JMS interfaces, B-1

JMS Type queues/topics, 17-10

JMS types, 17-10

JMSClasses, B-5

JOB_QUEUE_PROCESSES parameter, 2-10

LDAP

queue/topic connection factory, 13-25

queue/topic, getting, 13-27

registering, 13-11

unregistering, 13-13, 13-15

LDAP server, 17-2

with an AQ XML Servlet, 17-54

links. See messaging gateway links

listen capability, 8-90

listener.ora file

modifying, 18-7

loading

database objects, 18-7

Messaging Gateway

prerequisites for non-Oracle messaging systems, 18-6

log file

monitoring, 18-26

managing

gateway agent, 18-13

map message, 12-28

message

error, AQ XML servlet, D-1

error, JMS, D-1

fanning-out, 7-14

grouping, 8-51

history, 8-27

navigation in dequeue, 8-65

ordering, 8-38, 12-56

priority and ordering, 8-38, 12-56

propagation, 7-14

recipient, 7-7

message enqueuing, 11-4

message format transformation, 1-7

message grouping, 1-16, 12-62

message history and retention, 12-18

message navigation in receive, 12-69

message payloads, 17-9

message producer features, 12-56, 12-93

message_grouping, 2-9

messages

producers and consumers, 1-22

messages, definition, 1-21

Messaging Gateway, 18-20

administration

architecture, 18-3

frequently asked questions, 6-6

functionality, 18-2

installing

prerequisites for non-Oracle messaging systems, 18-6

prerequisites for the Oracle database, 18-6

verification, 18-11

subscribers

creating, 18-20

Messaging Gateway agent. See gateway agent

messaging gateway links

altering, 18-17

configuring, 18-15

creating, 18-15

example, 18-18

removing, 18-18

MGW_ADMINISTRATOR_ROLE role, 18-13

mgw.ora file, 18-9

example, 18-10

modeling

queue entity, 7-2

modeling and design, 7-1

modifying

listener.ora file, 18-7

tnsnames.ora file, 18-8

monitoring

log file, 18-26

registered non-Oracle queues, 18-20

multiple recipients, 1-18

navigation, 2-9

new features, xxxvii

non-Oracle queues

registering, 18-18

unregistering, 18-19

nonpersistent queue, 1-10, 1-22, 6-3

creating, 9-26

normal queues. See user queue, 1-22

notification, 17-32

asynchronous, 8-97

object message, 12-29

object types, 4-3, 4-17

object_name, 2-2

OO4O. See Oracle Objects for OLE (OO4O)

operational interface

basic operations, 11-1

use cases, 11-2

optimization

arrival wait, 8-75

optimization of waiting for messages, 1-18

Oracle Extension, 3-8

Oracle Internet Directory, 6-18, 17-2

Oracle JMSClasses, B-5

Oracle object (ADT) type queues, 17-9

Oracle Real Application Clusters, 1-10, 8-30, 12-19

oracle.AQ.AQQueueTable, B-57

oracle.AQ.AQQueueTableProperty, B-58

oracle.jms.AdtMessage, B-42

oracle.jms.AQjmsAdtMessage, B-44

oracle.jms.AQjmsAgent, B-45

oracle.jms.AQjmsBytesMessage, B-45

oracle.jms.AQjmsConnection, B-46

oracle.jms.AQjmsConstants, B-46

oracle.jms.AQjmsConsumer, B-47

oracle.jms.AQjmsDestination, B-47

oracle.jms.AQjmsDestinationProperty, B-48

oracle.jms.AQjmsException, B-56

oracle.jms.AQjmsFactory, B-49

oracle.jms.AQjmsInvalidDestinationException, B-56

oracle.jms.AQjmsInvalidSelectorException, B-56

oracle.jms.AQjmsMapMessage, B-50

oracle.jms.AQjmsMessage, B-50

oracle.jms.AQjmsMessageEOFException, B-57

oracle.jms.AQjmsMessageFormatException, B-57

oracle.jms.AQjmsMessageNotReadableException, B-57

oracle.jms.AQjmsMesssageNotWriteableException, B-57

oracle.jms.AQjmsObjectMessage, B-51

oracle.jms.AQjmsOracleDebug, B-51

oracle.jms.AQjmsProducer, B-52

oracle.jms.AQjmsQueueBrowser, B-52

oracle.jms.AQjmsQueueReceiver, B-42

oracle.jms.AQjmsQueueSender, B-43

oracle.jms.AQjmsSession, B-53

oracle.jms.AQjmsStreamMessage, B-55

oracle.jms.AQjmsTextMessage, B-55

oracle.jms.AQjmsTopicBrowser, B-59

oracle.jms.AQjmsTopicConnectionFactory, B-55

oracle.jms.AQjmsTopicPublisher, B-43

oracle.jms.AQjmsTopicReceiver, B-44

oracle.jms.AQjmsTopicSubscriber, B-44

oracle.jms.TopicBrowser, B-59

oracle.jms.TopicReceiver, B-43

payload, 17-9

structured, 8-11

performance, 5-2

persistent queue, 1-22

ping period for Exception Listener, 16-93, 16-94

PL/SQL, 3-2

postinstallation tasks, 18-6

prerequisites

for non-Oracle messaging systems, 18-6

for the Oracle database, 18-6

priority and ordering of messages, 12-56

privileges, 4-4

revoking, A-67

privileges. See specific privilege, such as system privilege, topic privilege, 13-42

producers, 7-4

programmatic environments, 2-7, 3-2

propagation, 1-16, 2-10, 8-107, 12-83, 17-62

exception handling, 12-92, 12-93, 12-95

exception handling during, 12-92

failures, 4-12

features, 8-106

issues, 4-11

LOB attributes, 8-111

message, 4-5, 7-14

messages with LOB attributes, 8-111

processing, 18-5

schedule, 12-88

schedule, altering, 13-61

schedule, disabling, 13-63

scheduling, 1-20, 8-108, 8-114, 13-57

scheduling, enabling, 13-59

unscheduling, 13-64

using HTTP, 8-118

propagation jobs

configuring, 18-20

disabling, 18-22

enabling, 18-22

resetting, 18-22

restarting, 18-22

propagation schedule, 12-90

altering, 9-81

disabling, 9-87

enabling, 9-84

selecting, 10-9

selecting all, 10-9

selecting in user schema, 10-25

Propagation, Exception Handling During, 12-96

protocol address

example, 18-7

publish-subscribe, 7-12, 8-28

topic, 12-44

QMN. See queue monitor (QMN), 1-24, 2-10

queue, 1-22

altering, 9-28

creating, 9-20

creating, example, A-4

dropping, 9-31

nonpersistent, 1-10, 6-3, 9-26

point-to-point, 12-38

point-to-point, creating, 13-35

selecting all, 10-7

selecting in user schema, 10-23

selecting, in user schema, 10-23

selecting, user has any privilege, 10-13

selecting, user has queue privilege, 10-15

staring, 9-42

starting, 9-42

stopping, 9-45

subscriber rules, 10-31

subscriber, selecting, 10-29

subscribers, 7-7

subscribers, selecting, 10-29

queue entity

modeling, 7-2

queue monitor, 1-24

queue monitor (QMN), 2-10

queue privilege

granting, 9-53

granting, point-to-point, 13-46

revoking, 9-55

revoking, point-to-point, 13-48

queue propagation

scheduling, 9-71

unscheduling, 9-75

queue subscribers

selecting, rules, 10-31

queue table, 1-22

altering, 9-14

creating, 9-4, 13-28, 13-30

creating prioritized message, 9-23

creating, example, 9-7, 9-8, 9-22, 9-23

creating, example, XMLType attributes, 9-8

dropping, 9-17

getting, 13-31

messages, selecting, 10-17

selecting all, 10-3, 10-17

selecting messages, 10-17

selecting user tables, 10-5

queue table data

exporting, 4-5

queue tables

creating, example, A-4

selecting all in user schema, 10-21

queue type

verifying, 9-78

queue_type, 2-9

queue-level access control, 1-10, 8-4

queues

AQ

registering, 18-20

exception, 18-24

non-Oracle

registering, 18-18

unregistering, 18-19

queue/topic

connection factory in LDAP, 13-25

connection factory, unregistering in LDAP through the database, 13-13

connection factory, unregistering in LDAP through the LDAP, 13-15

LDAP, 13-27

queuing

basic, 7-3

basic, one producer, one consumer, 7-3

RAW queues, 17-9

Real Application Clusters. See Oracle Real Application Clusters, 1-10

receiving messages, 12-66

recipient, 1-23, 7-7

list, 2-4, 8-36, 12-50

local and remote, 1-18, 8-64

multiple, 8-63

register request

server response, 17-31

registered non-Oracle queues

altering, 18-19

example, 18-20

monitoring, 18-20

registering

AQ Agent, 17-52

AQ queues, 18-20

JDBC connection parameters through LDAP, 13-8

JDBC URL through LDAP, 13-11

non-Oracle queues, 18-18

through the database, JDBC connection parameters, 13-4

through the database, JDBC URL, 13-6

registration

client request for, 17-7

to a queue, 2-5

registration for notification vs. listener, 6-3

removing

messaging gateway links, 18-18

resetting

propagation jobs, 18-22

restarting

propagation jobs, 18-22

retention, 2-9

retention and message history, 1-9, 8-27, 12-18

retries with delays, 1-19

retry

delay interval, 8-77

revoking

system privileges, 13-40

revoking roles and privileges, A-67

role

revoking, A-67

user, 4-2

rollback a transaction, 17-26

rollback response, 17-32

rule, 1-24

selecting subscriber, 10-31

rule-based subscriber, 1-17

example, 9-61

rule-based subscription, 8-86

schedules

altering, 18-22

creating, 18-21

scheduling

propagation, 1-20, 12-88, 13-57

schema

AQ XML, 17-33

IDAP, 17-35

SOAP, 17-33

security, 4-2, 4-3

selection rules, 18-23

sender identification, 1-17

sequence_deviation, 2-9

servlet

AQ XML, 17-48, 17-54

queue table

creating, 9-12

setting up

Messaging Gateway, 18-6

shutdown, 18-14

SMTP, 1-12, 17-55

operations over the Internet, 17-2

SOAP, 17-33

body, 17-4

envelope, 17-4

headers, 17-4

message structure, 17-4

method invocation, 17-5

SOAP schema, 17-33

specifying

destination properties, 13-33

SQL access, 1-8

starting

destination, 13-50

startup, 18-14

state parameter, 2-9

static service information

example, 18-8

statistics views, 8-35

statistics views support, 12-21

stopping

destination, 13-52

stream message, 12-27

structured payload, 1-9, 8-11

structured payload/message types, 12-21

subscriber, 2-4

adding, 9-58

altering, 9-64

durable, 12-45

removing, 9-68

rule-based, 1-17, 9-61

selecting, 10-29

subscribers

altering, 18-22

creating, 18-20

subscription, 8-36

anonymous, 2-5

rule-based, 8-86

subscription and recipient list, 1-15

subscription and recipient lists, 1-15

system privilege

granting, 9-48

revoking, 9-51

system privileges

granting, 13-39

revoking, 13-40

system-level access control, 8-2, 12-16

text message, 12-28

time specification, 1-17

delay, 8-45, 12-59

expiration, 8-48, 12-60

tnsnames.ora file

example, 18-9

modifying, 18-8

topic

connection factory, JDBC connection parameters, 13-23

connection factory, with JDBC URL, 13-21

publish-subscribe, creating, 13-37

topic privilege

granting, publish-subscribe, 13-42

revoking, publish-subscribe, 13-44

topic publisher, 12-48

tracking and event journals, 1-9

transaction protection, 1-19

transformation. See message format transformation, 1-7, 1-24

transformations, 18-23

example, 18-24

tuning. See database tuning, 5-2

type_name, 2-2

types

object, 4-3, 4-17

unloading

Messaging Gateway, 18-12

unregistering

non-Oracle queues, 18-19

example, 18-20

queue/topic connection factory in LDAP, 13-13, 13-15

unscheduling

propagation, 13-64

user authentication, 17-51

user authorization, 17-52

user queue, 1-22

user role, 4-2

USER_ATTRIBUTE_TRANSFORMATIONS, 10-39

USER_TRANSFORMATIONS, 10-38

users

administration, 18-11

agent, 18-11

view, 10-1

attributes, 10-1

views, 10-2

statistics, 8-35

visibility, 2-9

Visual Basic. See Oracle Objects for OLE(OO4O)

wait, 2-9

waiting

for message arrival, 8-75

Web server

setup, 17-56

XML, 17-1

components, 17-10

schema, 17-33

servlet, 17-48, 17-54

servlet, HTTP, 17-58