Java Components - oracle.AQ

The following sections describe the common Java interfaces and classes that are based on current PL/SQL interfaces.

• The common interfaces are prefixed with "AQ". These interfaces will have different implementations in Oracle8i and Oracle Lite.

• In this document we describe the common interfaces and their corresponding Oracle8i implementations, which are in turn prefixed with "AQOracle".

Location of Java AQ Classes

The Java AQ classes are located in $ORACLE_HOME/rdbms/jlib/aqapi.jar. These classes can be used with any Oracle8i JDBC driver.

If your application uses the OCI8 or thin JDBC driver, for JDK 1.2 you must include $ORACLE_HOME/rdbms/jlib/aqapi.jar in the CLASSPATH; for JDK 1.1 you must include $ORACLE_HOME/rdbms/jlib/aqapi11.jar in the CLASSPATH.

If the application is using the Oracle Server driver and accessing the java AQ API from java stored procedures, the Java files are generally automatically pre-loaded in a Java-enabled database. If they are not loaded, you must first load the aqapi.jar and jmscommon.jar files into the database using the "loadjava" utility.

Appendix A, "Oracle Advanced Queuing by Example" contains the following examples:

• Enqueue and Dequeue of Object Type Messages (CustomDatum interface) Using Java

• Enqueue and Dequeue of Object Type Messages (using SQLData interface) Using Java

• Create a Queue Table and Queue Using Java

• Create a Queue and Start Enqueue/Dequeue Using Java

• Create a Multi-Consumer Queue and Add Subscribers Using Java

• Enqueue of RAW Messages using Java

• Dequeue of Messages Using Java

• Dequeue of Messages in Browse Mode Using Java

• Enqueue of Messages with Priority Using Java

• Enqueuing and Dequeuing Object Type Messages That Contain LOB Attributes Using Java

Set up for the test_aqjava class is described in Oracle8i Supplied Java Packages Reference "Setup for oracle.AQ Examples" section.