4.1.1.18 Creating a Connection to Oracle AQ

To create a connection to Oracle Advanced Queue (AQ):

1. On the Catalog page, click Create New Item
2. Hover the mouse over Connection and select JNDI from the submenu.
3. On the Type Properties screen, enter the following details:
   • Name: Enter a unique name for the connection. This is a mandatory field.
   • Display Name: Enter a display name for the connection. If left blank, the Name field value is copied.
   • Description
   • Tags
   • Connection Type: The selected connection is displayed.
4. Click Next.
5. On the Connection Details screen, enter the following details:

   • JNDI Provider: Select Oracle AQ as the JNDI service provider.

   • Server Url(s): Enter the server url(s) for the JNDI connection, in the format host1:port1, host2:port2.

   • Username: Enter the user name to authenticate the JNDI connection.

   • Password: Enter the password for the JNDI connection.

   • Jndi Other Properties: This value should always be:

     • sid=<sid>. For example, sid=XE

       or

     • service_name=<service_name> For example, service_name=slc.us.oracle.com.
6. Click Test Connection, to ensure that you have successfully created a connection.
7. Click Save.