Designing Intelligent Event Processor (IEP) Projects

ProcedureTo Create the Non-XA Connection Pool

  1. Log in to the GlassFish Admin Console.

  2. In the left navigation panel, expand Resources and JDBC, and then select Connection Pools.

  3. Click New.

    The New JDBC Connection Pool page appears.

  4. Do the following:

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

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

    3. In the Database Vendor field, select Oracle.

    4. Click Next.

  5. Scroll down to the Additional Properties table, and then do the following:

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

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

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

  6. Click Finish.

    The connection pool is created.

  7. Click the connection pool that you just created.

    The Edit Connection Pool page appears.

  8. 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 database connectivity properties, such as the URL string.