Database scripts

Before you can use Rule Execution Server with database persistence, you must create some resources, such as tables and indexes, in the database. Each application server has it own way of handling these persistence services. For more information, see the documentation of your application server.

To create the database table, use the Installation Settings wizard or run SQL scripts:

  • Run the Installation Settings wizard from the Rule Execution Server console.

    If you use the Installation Settings wizard to update database schemas, the number of steps depends on the configuration combination.
    • Four steps if one repository uses file persistence and the other database persistence
    • Eight steps if both use database persistence
    Table 1. Steps in the Installation Settings wizard for ruleset- and XOM repositories
    Ruleset repository XOM repository
    jndi A file
    file A jndi A
    jndi A jndi B
    jndi A jndi A
  • Run SQL scripts provided in the distribution here <InstallDir>/executionserver/databases/xomrepository_<database>

The product distribution provided SQL scripts for you to create database tables. You can find these scripts in <InstallDir>/executionserver/databases/<database>. The databases directory also contains a readme file. You can use any tool that can handle SQL to import and run the scripts. The following table lists the tools available for the supported databases, in alphabetical order. For more information, see the documentation of these tools.

Table 2. Tools to access database tables
Database Tool
Apache H2 ij command line processor
IBM® Db2® command center or db2 command line processor
MySQL mysql command line processor
Original drivers (JDBC 3) PostgreSQL
Oracle sqlplus command line processor
SQL Server Query Tool