Designing Intelligent Event Processor (IEP) Projects

ProcedureTo Create the XA Connection Pool

  1. In the left navigation panel of the Admin Console, expand Resources and JDBC, and then select Connection Pools.

  2. Click New.

    The New JDBC Connection Pool page appears.

  3. For step 1 of the connection pool, do the following:

    1. In the Name field, specify a name for the XA connection pool (for example, iepseOraclePoolXA).

    2. In the Resource Type field, select javax.sql.XADataSource.

    3. In the Database Vendor field, select Oracle.

    4. Click Next.

  4. For step 2 of the connection pool, do the following:

    1. Scroll down to the Connection Validation section.

    2. Select the Enabled check box that appears to the right of the Allow Non Component Callers label.

    3. Scroll down to the Additional Properties table.

    4. In the User row, enter the user name of the IEP user (for example, IEPSEDB).

    5. In the Password row, enter the password of the IEP user (for example, IEPSEDB).

    6. In the URL row, enter the string for connecting to the database (for example, jdbc:oracle:thin:@myserver:1521:orcl).

  5. Click Finish.

    The connection pool is created.

  6. Click the connection pool that you just created.

    The Edit Connection Pool page appears.

  7. Click Ping.

    The Admin Console attempts to connect to the database. If the connection does not succeed, check to see whether the database is running, and verify the connectivity parameters, such as the URL string.