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

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

adding a subscriber, 9-61

administrative interface, 4-4, 9-1

basic operations, 13-2

JMS, 13-4

use cases, 13-2

view, 10-2

views, 10-1

Adt message, 12-27

Advanced Queuing

operations over the Internet, 17-2

agent, 1-22

identifying, 2-3, 2-4

agent. See AQ agent, 9-97

AQ agent

altering, 9-97

creating, 9-94

dropping, 9-99

registering, 17-50

AQ servlet, 17-2

AQ XML

document, 17-6

requests, using SMTP, 17-53

schema, 17-33, 17-35

servlet, 17-47, 17-52

AQ XML servlet

registering for notifications, 8-106

AQ_TM_PROCESSES, 2-10

AQjmsQueueConnectionFactory, B-78

AQXmlPublish method, 17-7

AQXmlReceive method, 17-21

AQXmlSend method, 17-7

asynchronous notification, 1-17, 8-97

asynchronously receiving message, 12-74

BooksOnLine sample application, 8-1

using JMS, 12-2

bytes message, 12-25

C. See Oracle Call Interface (OCI)

Class - AQjmsQueueConnectionFactory, B-78

Class - oracle.AQ.AQQueueTableProperty, B-93

Class - oracle.jms.AQjmsAdtMessage, B-61

Class - oracle.jms.AQjmsAgent, B-62

Class - oracle.jms.AQjmsBytesMessage, B-63

Class - oracle.jms.AQjmsConnection, B-64

Class - oracle.jms.AQjmsConstants, B-66

Class - oracle.jms.AQjmsDestination, B-68

Class - oracle.jms.AQjmsDestinationProperty, B-70

Class - oracle.jms.AQjmsFactory, B-71

Class - oracle.jms.AQjmsMapMessage, B-72

Class - oracle.jms.AQjmsObjectMessage, B-74

Class - oracle.jms.AQjmsOracleDebug, B-75

Class - oracle.jms.AQjmsProducer, B-76

Class - oracle.jms.AQjmsQueueBrowser, B-77

Class - oracle.jms.AQjmsSession, B-79

Class - oracle.jms.AQjmsStreamMessage, B-82

Class - oracle.jms.AQjmsTextMessage, B-83

Class - oracle.jms.AQjmsTopicConnectionFactory, B-84

Class oracle.jms.AQjmsException, B-85

classes, B-2

Classes, JMS, B-6

commit response, 17-32

commit transaction, 17-26

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

compositing, 7-15

connection factory

registering queue/topic, 13-5

unregistering in LDAP through database, 13-16

unregistering in LDAP through LDAP, 13-18

consumers, 7-3

correlation identifier, 1-15

creating

queue, 9-22

queue tables and queues, examples, A-4

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-101

database session, 17-51

DBA_ATTRIBUTE_TRANSFORMATIONS, 10-41

DBA_QUEUE_TABLES, 10-5, 10-7, 10-23

DBA_QUEUES, 10-8

DBA_TRANSFORMATIONS, 10-40

DBMS_AQADM package, 4-2

DBMS_AQADM.DROP_QUEUE, 9-20

delay, 2-9

time specification, 12-57

delay interval

retry with, 8-77

time specification, 8-46

dequeue

client request for, 17-21

dequeue mode, 2-9

dequeue of messages after preview, A-33

dequeue request

server response, 17-29

dequeuing, 11-47

features, 8-58

message navigation, 8-66

methods, 8-59

modes, 1-18, 8-70

multiple-consumer dequeuing of one message, 7-6

navigation of messages, 1-18

same message, multiple-consumer, 7-6

using HTTP, 8-107

destination-level access control, 12-15

disabling

propagation schedule, 9-91

dropping

queue table, 9-19

dropping AQ objects, A-66

durable subscriber, 12-43

email server, 17-2

setup, 17-54

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-5, 11-13

features, 8-36

specify message properties, 11-10

specify options, 11-7

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-81, 12-78

Exception Handling During Propagation, 12-93, 12-94

exception handling during propagation, 12-90, 12-91

Exception javax.jms.InvalidDestinationException, B-47

Exception javax.jms.InvalidSelectorException, B-48

Exception javax.jms.JMSException, B-49

Exception javax.jms.MesageNotWriteableException, B-53

Exception javax.jms.MessageEOFException, B-50

Exception javax.jms.MessageFormatException, B-51

Exception javax.jms.MessageNotReadableException, B-52

Exception oracle.jms.AQjmsInvalidDestinationException, B-86

Exception oracle.jms.AQjmsInvalidSelectorException, B-87

Exception oracle.jms.AQjmsMessageEOFException, B-88

Exception oracle.jms.AQjmsMessageFormatException, B-89

Exception oracle.jms.AQjmsMessageNotReadableException, B-90

Exception oracle.jms.AQjmsMesssageNotWriteableException, B-91

exception queue, 1-22

exceptions, B-2

expiration, 2-9

time specification, 8-49

exporting

incremental, 4-6

queue table data, 4-5

fanning-out of messages, 7-15

FAQs. See frequently asked questions, 6-1

features, new, lvii

frequently asked questions, 6-1

general questions, 6-1

installation questions, 6-10

Internet access questions, 6-7

JMS questions, 6-6

Oracle Internet Directory, 6-9

performance questions, 6-10

transformation questions, 6-9

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

global agents, 6-9

global events, 6-9

global queues, 6-9

granting

system privilege, 9-50

grouping

message, 12-60

HTTP, 1-12, 17-2, 17-6, 17-49, 17-50, 17-58

accessing AQ XML servlet, 17-56

AQ operations over, 17-2

headers, 17-5

propagation, 17-60

response, 17-6

HTTPS

propagation, 17-60

IDAP, 17-33

body, 17-4

envelope, 17-4

headers, 17-4

message structure, 17-4

method invocation, 17-5

transmitted over Internet, 17-1

IDAP schema, 17-34

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

INIT.ORA parameter, 2-9

Interface - javax.jms.BytesMessage, B-18

Interface - javax.jms.Connection, B-19

Interface - javax.jms.ConnectionFactory, B-20

Interface - javax.jms.ConnectionMetaData, B-21

Interface - javax.jms.DeliveryMode, B-22

interface - javax.jms.Destination, B-23

Interface - javax.jms.MapMessage, B-24

Interface - javax.jms.Message, B-25

Interface - javax.jms.MessageConsumer, B-27

Interface - javax.jms.MessageListener, B-28

Interface - javax.jms.MessageProducer, B-29

Interface - javax.jms.ObjectMessage, B-30

Interface - javax.jms.Queue, B-31

Interface - javax.jms.QueueBrowser, B-32

Interface - javax.jms.QueueConnection, B-33

Interface - javax.jms.QueueConnectionFactory, B-34

Interface - javax.jms.QueueReceiver, B-35

Interface - javax.jms.QueueSender, B-36

Interface - javax.jms.QueueSession, B-37

Interface - javax.jms.Session, B-38

Interface - javax.jms.StreamMessage, B-39

Interface - javax.jms.TextMessage, B-40

Interface - javax.jms.Topic, B-41

Interface - javax.jms.TopicSession, B-45

Interface - javax.jms.TopicSubscriber, B-46

Interface - oracle.AQ.AQQueueTable, B-92

Interface - oracle.jms.AdtMessage, B-54

Interface - oracle.jms.AQjmsConnectionMetadata, B-65

Interface - oracle.jms.AQjmsConsumer, B-67

Interface - oracle.jms.AQjmsQueueReceiver, B-55

Interface - oracle.jms.AQjmsQueueSender, B-56

Interface - oracle.jms.AQjmsTopicPublisher, B-57

Interface - oracle.jms.AQjmsTopicReceiver, B-60

Interface - oracle.jms.AQjmsTopicSubscriber, B-59

Interface - oracle.jms.TopicReceiver, B-58

interfaces, classes, and exceptions, B-2

Internet

access, 8-36

Advanced Queuing operations, 17-2

Advanced Queuing operations over, 17-1

AQ operations over, li, 1-2, 1-12

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

Java API, 2-10

Java. See JDBC

javax.jms.BytesMessage, B-18

javax.jms.Connection, B-19

javax.jms.ConnectionFactory, B-20

javax.jms.ConnectionMetaData, B-21

javax.jms.DeliveryMode, B-22

javax.jms.Destination, B-23

javax.jms.InvalidDestinationException, B-47

javax.jms.InvalidSelectorException, B-48

javax.jms.JMSException, B-49

javax.jms.MapMessage, B-24

javax.jms.MesageNotWriteableException, B-53

javax.jms.Message, B-25

javax.jms.MessageConsumer, B-27

javax.jms.MessageEOFException, B-50

javax.jms.MessageFormatException, B-51

javax.jms.MessageListener, B-28

javax.jms.MessageNotReadableException, B-52

javax.jms.MessageProducer, B-29

javax.jms.ObjectMessage, B-30

javax.jms.Queue, B-31

javax.jms.QueueBrowser, B-32

javax.jms.QueueConnection, B-33

javax.jms.QueueConnectionFactory, B-34

javax.jms.QueueReceiver, B-35

javax.jms.QueueSender, B-36

javax.jms.QueueSession, B-37

javax.jms.Session, B-38

javax.jms.StreamMessage, B-39

javax.jms.TextMessage, B-40

javax.jms.Topic, B-41

javax.jms.TopicConnection, B-42

javax.jms.TopicSession, B-45

javax.jms.TopicSubscriber, B-46

JDBC, 3-6

connection parameters, registering through LDAP, 13-11

connection parameters, registering through the database, 13-6

JDBC URL

registering through LDAP, 13-14

registering through the database, 13-8

JMS

administrative interface, 13-4

examples payload, 12-29

JMS classes, B-2

JMS exceptions, B-2

JMS Extension, 3-8

JMS interfaces, B-2

JMS Type queues/topics, 17-10

JMS types, 17-10

JMSClasses, B-6

JOB_QUEUE_PROCESSES parameter, 2-10

LDAP

registering, 13-10, 13-14

unregistering, 13-16, 13-18

LDAP server, 17-2

with an AQ XML Servlet, 17-52

listen capability, 8-90

map message, 12-26

message

error, AQ XML servlet, D-1

error, JMS, D-1

fanning-out, 7-15

grouping, 8-52

history, 8-28

navigation in dequeue, 8-66

ordering, 8-39, 12-54

priority and ordering, 8-39, 12-54

propagation, 7-15

recipient, 7-6

message enqueuing, 11-5

message format transformation, 1-7

message grouping, 1-16, 12-60

message history and retention, 12-16

message navigation in receive, 12-67

message payloads, 17-9

message producer features, 12-53, 12-91

message_grouping, 2-9

messages

producers and consumers, 1-22

messages, definition, 1-21

modeling

queue entities, 7-2

modeling and design, 7-1

multiple recipients, 1-18

navigation, 2-9

new features, lvii

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

creating, 9-28

normal queues. See user queue, 1-22

notification, 17-32

asynchronous, 8-97

object message, 12-26

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-9, 17-2

Oracle JMSClasses, B-6

Oracle object (ADT) type queues, 17-9

Oracle Real Application Clusters, 1-11, 8-31, 12-17

oracle.AQ.AQQueueTable, B-92

oracle.AQ.AQQueueTableProperty, B-93

oracle.jms.AdtMessage, B-54

oracle.jms.AQjmsAdtMessage, B-61

oracle.jms.AQjmsAgent, B-62

oracle.jms.AQjmsBytesMessage, B-63

oracle.jms.AQjmsConnection, B-64

oracle.jms.AQjmsConstants, B-66

oracle.jms.AQjmsConsumer, B-67

oracle.jms.AQjmsDestination, B-68

oracle.jms.AQjmsDestinationProperty, B-70

oracle.jms.AQjmsException, B-85

oracle.jms.AQjmsFactory, B-71

oracle.jms.AQjmsInvalidDestinationException, B-86

oracle.jms.AQjmsInvalidSelectorException, B-87

oracle.jms.AQjmsMapMessage, B-72

oracle.jms.AQjmsMessageEOFException, B-88

oracle.jms.AQjmsMessageFormatException, B-89

oracle.jms.AQjmsMessageNotReadableException, B-90

oracle.jms.AQjmsMesssageNotWriteableException, B-91

oracle.jms.AQjmsObjectMessage, B-74

oracle.jms.AQjmsOracleDebug, B-75

oracle.jms.AQjmsProducer, B-76

oracle.jms.AQjmsQueueBrowser, B-77

oracle.jms.AQjmsQueueReceiver, B-55

oracle.jms.AQjmsQueueSender, B-56

oracle.jms.AQjmsSession, B-79

oracle.jms.AQjmsStreamMessage, B-82

oracle.jms.AQjmsTextMessage, B-83

oracle.jms.AQjmsTopicBrowser, B-96

oracle.jms.AQjmsTopicConnectionFactory, B-84

oracle.jms.AQjmsTopicPublisher, B-57

oracle.jms.AQjmsTopicReceiver, B-60

oracle.jms.AQjmsTopicSubscriber, B-59

oracle.jms.TopicBrowser, B-95

oracle.jms.TopicReceiver, B-58

payload, 17-9

structured, 8-10

performance, 5-2

persistent queue, 1-22

ping period for Exception Listener, 16-123, 16-125

PL/SQL, 3-2

priority and ordering of messages, 12-54

privileges, 4-4

revoking, A-67

producers, 7-3

programmatic environments, 2-7, 3-2

propagation, 1-16, 2-10, 8-107, 12-81, 17-60

exception handling, 12-90, 12-91, 12-93

exception handling during, 12-90

failures, 4-12

features, 8-107

issues, 4-11

LOB attributes, 8-111

message, 4-5, 7-15

messages with LOB attributes, 8-111

schedule, 12-86

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

using HTTP, 8-119

propagation schedule, 12-88

altering, 9-84

disabling, 9-91

enabling, 9-88

selecting, 10-10

selecting all, 10-10

selecting in user schema, 10-26

Propagation, Exception Handling During, 12-94

publish-subscribe, 7-12, 8-29

topic, 12-42

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

queue, 1-22

altering, 9-31

creating, 9-22

creating, example, A-4

dropping, 9-34

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

point-to-point, 12-36

selecting all, 10-8

selecting in user schema, 10-24

selecting, in user schema, 10-24

selecting, user has any privilege, 10-14

selecting, user has queue privilege, 10-16

staring, 9-44

starting, 9-44

stopping, 9-47

subscriber rules, 10-32

subscriber, selecting, 10-30

subscribers, 7-6

subscribers, selecting, 10-30

queue monitor, 1-24

queue monitor (QMN), 2-10

queue privilege

granting, 9-55

revoking, 9-58

queue propagation

scheduling, 9-74

unscheduling, 9-78

queue subscribers

selecting, rules, 10-32

queue table, 1-22

altering, 9-16

creating, 9-6

creating prioritized message, 9-25

creating, example, 9-10, 9-11, 9-24, 9-25

creating, example, XMLType attributes, 9-10

dropping, 9-19

messages, selecting, 10-18

selecting all, 10-4, 10-18

selecting messages, 10-18

selecting user tables, 10-6

queue table data

exporting, 4-5

queue tables

creating, example, A-4

selecting all in user schema, 10-22

queue type

verifying, 9-81

queue_type, 2-9

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

queue/topic

connection factory, registering, 13-5

connection factory, registering through LDAP, 13-10

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

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

queuing

basic, 7-3

basic, one producer, one consumer, 7-3

RAW queues, 17-9

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

receiving messages, 12-64

recipient, 1-23, 7-6

list, 2-4, 8-37, 12-48

local and remote, 1-18, 8-64

multiple, 8-63

register request

server response, 17-32

registering

AQ Agent, 17-50

JDBC connection parameters through LDAP, 13-11

JDBC URL through LDAP, 13-14

queue/topic connection factory, 13-5

queue/topic connection factory through LDAP, 13-10

through the database, JDBC connection parameters, 13-6

through the database, JDBC URL, 13-8

registration

client request for, 17-7

to a queue, 2-5

registration for notification vs. listener, 6-3

retention, 2-9

retention and message history, 1-9, 8-28, 12-16

retries with delays, 1-19

retry

delay interval, 8-77

revoking roles and privileges, A-67

role

revoking, A-67

user, 4-2

rollback a transaction, 17-27

rollback response, 17-32

rule, 1-24

selecting subscriber, 10-32

rule-based subscriber, 1-17

example, 9-64

rule-based subscription, 8-86

scheduling

propagation, 1-20, 12-86

schema

AQ XML, 17-33, 17-35

IDAP, 17-34

security, 4-2, 4-3

sender identification, 1-17

sequence_deviation, 2-9

servlet

AQ XML, 17-47, 17-52

queue table

creating, 9-15

SMTP, 1-12, 17-53

operations over the Internet, 17-2

SQL access, 1-8

state parameter, 2-9

statistics views, 8-35

statistics views support, 12-19

stream message, 12-24

structured payload, 1-9, 8-10

structured payload/message types, 12-19

subscriber, 2-4

adding, 9-61

altering, 9-67

durable, 12-43

removing, 9-71

rule-based, 1-17, 9-64

selecting, 10-30

subscription, 8-37

anonymous, 2-5

rule-based, 8-86

subscription and recipient list, 1-15

subscription and recipient lists, 1-15

system privilege

granting, 9-50

revoking, 9-53

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

text message, 12-26

time specification, 1-17

delay, 8-46, 12-57

expiration, 8-49, 12-58

topic publisher, 12-46

tracking and event journals, 1-10

transaction protection, 1-19

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

tuning. See database tuning, 5-2

type_name, 2-2

types

object, 4-3, 4-17

Unified Modeling Language (UML), E-i

unregistering

queue/topic connection factory in LDAP, 13-16, 13-18

use case diagrams, E-i

user authentication, 17-49

user authorization, 17-50

user queue, 1-22

user role, 4-2

USER_ATTRIBUTE_TRANSFORMATIONS, 10-40

USER_TRANSFORMATIONS, 10-39

view, 10-1, 10-2

attributes, 10-1

views

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-54

XML, 17-1

components, 17-10

document, 17-6

schema, 17-33, 17-35

servlet, 17-47, 17-52

servlet, HTTP, 17-56