Oracle8i Application Developer's Guide - Advanced Queuing Release 8.1.5 A68005-01 |
|
This Guide describes features of application development on the Oracle Server having to do with Oracle Advanced Queuing, Release 8.1.5. Information in this Guide applies to versions of the Oracle Server that run on all platforms, and does not include system-specific information.
The Preface includes the following sections:
Oracle Advanced Queueing (Oracle AQ) provides message queuing as an integrated part of the Oracle server. Oracle AQ provides this functionality by integrating the queuing system with the database, thereby creating a message-enabled database. By providing an integrated solution Oracle AQ frees application developers to devote their efforts to their specific business logic rather than having to construct a messaging infrastructure.
The Oracle8i Application Developer's Guide - Advanced Queuing is intended for programmers developing new applications that use Oracle Advanced Queuing, as well as those who have already implemented this technology and now wish to take advantage of new features.
The increasing importance of Oracle AQ has led to its being presented as an independent volume within the Oracle Application Developers documentation set.
For information about the differences between Oracle8 and the Oracle8 Enterprise Edition and the features and options that are available to you, see Getting to Know Oracle8i.
Use the PL/SQL User's Guide and Reference to learn PL/SQL and to get a complete description of this high-level programming language, which is Oracle Corporation's procedural extension to SQL.
The Oracle Call Interface (OCI) is described in:
You can use the OCI to build third-generation language (3GL) applications that access the Oracle Server.
Oracle Corporation also provides the Pro* series of precompilers, which allow you to embed SQL and PL/SQL in your application programs. If you write 3GL application programs in Ada, C, C++, COBOL, or FORTRAN that incorporate embedded SQL, refer to the corresponding precompiler manual. For example, if you program in C or C++, refer to the Pro*C/C++ Precompiler Programmer's Guide.
For SQL information, see the Oracle8i SQL Reference and Oracle8i Administrator's Guide. For basic Oracle concepts, see Oracle8i Concepts.
The Application Developer's Guide - Advanced Queuing contains seven chapters and an appendix. A brief summary of what you will find in each chapter follows:
This chapter 'sets the bar' by describing the requirements for optimal messaging systems. Although Oracle AQ is a relatively new technology, and not all these goals have been realized, you can get an overview of the underlying design and a clear idea of the intended direction.
This chapter describes features already present in Oracle AQ under three headings: General Features, Enqueue Features, and Dequeue Features.
This chapter describes the primary queuing entities (message, queue, queue table, agent, queue monitor), and the basics of connecting single/multiple producers of messages with single/multiple consumers of messages. Of particular interest is the way messages can directed toward specific subscribers implicitly, explicitly or on the basis of rules.
As its title indicates, this chapter presents the basic operations underlying the Administrative interface, such as Create
Queue
Table
, Create
Queue
, Grant
Queue
Privilege
, Add
a
Subscriber
, and Schedule
a
Propagation
. We have introduced a new way of presenting this information that utilizes the Unified Modelling Language (detailed notes are included below). On-line users will additionally be able to make use of hypertext links and image-based hot links
This chapter is dedicated to the various views that Oracle has provided for administrators and users that are projected as a result of queries, such as Select
All
Queue
Tables
in
the
Database
, Select
Messages
in
a
Queue
Table
, and Select
Queue
Subscribers
and
their
Rules
.
We here describe the essentials of the operational interface in terms of the basic operations concerned with enqueuing a message, dequeuing a message, registering for messages based on defined rules, and listening to one or more queues for messages.
This chapter introduces and details the Java Application Programmer's Interface for Advanced Queuing.
As you can see by examining the Table of Contents, small examples are interspersed throughout the text, but this chapter is dedicated solely to providing examples in both PL/SQL and OCI.
This appendix has the scripts for implementing the sample application, BooksOnLine
.
This release introduces the Universal Modeling Language (UML) as a way of explaining the technology that we hope will help you develop applications. A full presentation of the UML is beyond the scope of this documentation set, however we do provide a description of the subset of UML notation that we use in a chapter devoted to visual modelling inOracle8i Application Developer's Guide - Fundamentals. What follows here is a selection from that chapter of those elements that are used in this book.
The following notational and text formatting conventions are used in this guide:
Square brackets indicate that the enclosed item is optional. Do not type the brackets.
Braces enclose items of which only one is required.
A vertical bar separates items within braces, and may also be used to indicate that multiple values are passed to a function parameter.
In code fragments, an ellipsis means that code not relevant to the discussion has been omitted.
SQL or C code examples are shown in monospaced font.
Italics are used for OCI parameters, OCI routines names, file names, and data fields.
Uppercase is used for SQL keywords, like SELECT
or UPDATE
.
This guide uses special text formatting to draw the reader's attention to some information. A paragraph that is indented and begins with a bold text label may have special meaning. The following paragraphs describe the different types of information that are flagged this way.
Note: The "Note" flag indicates that the reader should pay particular attention to the information to avoid a common problem or increase understanding of a concept.
Warning: An item marked as "Warning" indicates something that an OCI programmer must be careful to do or not do in order for an application to work correctly.
See Also: Text marked "See Also" points you to another section of this guide, or to other documentation, for additional information about the topic being discussed.
We value and appreciate your comment as an Oracle user and reader of our manuals. As we write, revise, and evaluate our documentation, your opinions are the most important feedback we receive.
You can send comments and suggestions about this manual to the following e-mail address:
If you prefer, you can send letters or faxes containing your comments to the following address:
Server Technologies Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood Shores, CA 94065
Fax: (650) 506-7228