[Enterprise Extensions only]

Database considerations

The following relational databases are supported by BRBeans:

This documentation does not provide you with specific instructions on how to use any of these databases. For help with specific commands, consult the documentation that accompanied your database software . For installation and configuration instructions, refer to the documentation for Advanced Edition (InfoCenter).

Large character data

There are several attributes in the BRBeans Rule EJB that may contain large amounts of data. This would include such fields as: businessIntent, dependentRules, description, firingParameters, initParameters, originalReq, and userDefinedData. The value for these attributes is stored in a character type column within a database table. When possible, they are stored in large character fields like LONG VARCHAR (for DB2) and TEXT (for Sybase).

There are several cases where the use of large character fields is problematic, mostly in terms of a lack of query support. Refer to each of the supported database sections for details on the column type used for storing the values in these attributes.

Isolation level

All EJBs accessed in a transaction must specify the same isolation level. If your application contains EJBs that are used in the same transaction as the rules, you must do one of the following:

  1. Change the BRBeans EJBs (Rule, RuleFolder, and RuleHelper) to the same isolation level as your beans.
  2. Change your beans to the same isolation level as the BRBeans EJBs.

    Place the BRBeans EJBs in a different database than your EJBs, and configure the application to run two phase. This causes the beans to run in a different transactions, thereby removing the restriction that they need to have the same isolation level.