Database considerations for BRBeans

The following relational databases are supported by Business Rule Beans (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. The following are general considerations for relational databases that are supported by BRBeans:

Large character data

There are several attributes in the BRBeans Rule enterprise beans that might contain large amounts of data. This includes fields such 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. Whenever possible, the values 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 of the enterprise beans accessed in a transaction must specify the same isolation level. If your application contains enterprise beans that are used in the same transaction as the rules, you must do one of the following:


Related concepts
Overview of Business Rule Beans
Oracle considerations
Sybase considerations
Informix considerations



Searchable topic ID:   cbrb_dbase
Last updated: Jun 21, 2007 8:07:48 PM CDT    WebSphere Business Integration Server Foundation, Version 5.0.2
http://publib.boulder.ibm.com/infocenter/wasinfo/index.jsp?topic=/com.ibm.wasee.doc/info/ee/brb/concepts/cbrb_dbase.html

Library | Support | Terms of Use | Feedback