To Run the Database Scripts (Databases Other Than Derby)

1. Open the jbi_rt.jar file in the JavaCAPS-install-dir/appserver/jbi/lib directory.

2. Extract the SQL scripts for your database type.

3. If you are using Oracle, then create the tablespace and user that will be used to persist alerts.

   1. Open the create_event_store_user.sql script and make any changes needed to match your database configuration.

   2. Run the create_event_store_user.sql script.

4. Create the table that will be used to persist alerts.

   1. Open the create_event_store_schema.sql script and make any changes needed to match your database configuration.

      Ensure that the table name matches the value in the eventmanagement.properties file.

   2. Run the create_event_store_schema.sql script.