Enabling Oracle Advanced Queueing

If you did not install support for Oracle Advanced Queueing, but want to use it, you can install support from the command line after Java CAPS is installed. Whether you install support for Advanced Queueing while or after installing Java CAPS, you need to run the provided script, JavaCAPS_Home\appserver\addons\caps\oracleaq\jdbcwrappers.sp against the Advanced Queue database in order to allow Enterprise Manager to delete messages from the Oracle Advanced Queue destinations.

To Create the Java CAPS Advanced Queue User

1. Make sure the Advanced Queueing database is running.
2. Log in to the Advanced Queueing database from SQL*Plus as the system user as sysdba.
3. Create a Java CAPS user for the Advanced Queuing database by running the following commands:

   DROP USER user CASCADE;
   CREATE USER user IDENTIFIED BY password QUOTA UNLIMITED ON USERS;
   GRANT CONNECT, AQ_ADMINISTRATOR_ROLE, AQ_USER_ROLE TO     user;

4. Grant the Java CAPS user the following permissions:

   GRANT SELECT ON V$XATRANS$ TO user;
   GRANT SELECT ON PENDING_TRANS$ TO user;
   GRANT SELECT ON DBA_2PC_PENDING TO user;
   GRANT SELECT ON DB1_PENDING_TRANSACTIONS TO user;

To Install Advanced Queueing Support After Installing Java CAPS

You can also use this procedure to install Advanced Queueing support on a new domain that you create after Java CAPS is installed. This procedure creates a lifecycle module on the GlassFish server.

1. Make sure the GlassFish server is running.
2. From a command prompt, navigate to JavaCAPS_Home\appserver\bin.
3. Type asadmin.
4. From the asadmin prompt, enter a command similar to the following:

   create_oracleaq --oracleaqhost hostname --oracleaqsid SIDname --oracleaqusername --oracleaqpassword OracleAdvanceQueueName

   ---

   Tip - For complete information about running create-oracleaq, type help create-oracleaq from the asadmin command prompt.

   ---

5. Restart the GlassFish application server.

   ---

   Note - Running create-oracleaq configures Enterprise Manager with a lifecycle module with the name specified at the end of the command. OracleAQ is prepended to the name you specify. You can modify the properties for the module from the GlassFish Admin Console on the Applications > Lifecycle Modules > ModuleName page. Running the command also copies the aqapi.jar file to the domain's \lib directory.

   ---

To Allow Enterprise Manager to Delete Advanced Queue Messages

1. Make sure the Advanced Queueing database is running.
2. Log in to the Advanced Queueing database from SQL*Plus as the system user.
3. Run the following script:

   @JavaCAPS_Home\appserver\addons\caps\oracleaqjdbcwrappers.sp

4. Grant the Java CAPS user the following permission:

   GRANT EXECUTE ON JDBC_PURGE_QUEUE_TABLE TO user;