To Set Up the IEP Database

1. If you are using Oracle, do the following. These steps are not necessary for other database platforms.

   1. Copy the Oracle driver (ojdbc14.jar) from your Oracle installation to GlassFish_Home/lib. Restart the GlassFish server.

   2. Create an Oracle database instance using the administrative tools provided by Oracle.

   3. Create the IEP user as described in To Create the IEP User in the Oracle Database in Designing Intelligent Event Processor (IEP) Projects.

2. Launch the GlassFish Admin Console.

3. Create and configure two connection pools for the database, one for XA transactions and one for non-XA transactions. Point both connection pools to the same database using the same user name and password.

   ---

   Note –

   For Derby, you can use the connection pools that are automatically created when IEP is installed.

   ---

   • Select Allow Non Component Callers.

   • For a Derby database, enter the following properties:

     • Host (can be localhost)

     • PortNumber (1527 is the default Derby port)

     • DatabaseName

     • User

     • Password

     • connectionAttributes (set this to ;create=true to automatically create the Derby database)

   • For an Oracle database, enter the following properties:

     • URL (the format for the URL is jdbc:oracle:thin:@hostName:portNumber:databaseName)

     • user

     • password

4. Create and configure two JDBC resources for the database, one for XA transactions and one for non-XA transactions. After you enter the name and connection pool, do the following:

   1. Under Available Targets, select the cluster and click Add.

   2. Click OK.

      This adds the resource to the cluster and enables the resource on the cluster.

5. To create the database tables, complete the steps under Adding the IEP Service Engine to the Cluster.