Oracle considerations

Large character data

The preferred Oracle data type for storing large character objects is CLOB. However, Oracle does not allow a CLOB to be queried. Because of this, a data type of VARCHAR2 is used by Business Rule Beans (BRBeans). A specific length must be specified when specifying VARCHAR2. The maximum length for a VARCHAR2 is 4000 bytes.

To determine the default size of VARCHAR2, look in the table.ddl file that was generated when you deployed the code. If the default size is not acceptable for your application, you can do one of the following:

Increase the size of the columns
Keep in mind that maximum size for a VARCHAR2 in Oracle is 4000. Increase the column size either by changing the value in the create table statement or by changing the schema mapping and deploying the BRBeans JAR file.
Change the schema mapping to specify CLOB
Do this for any of the attributes that you do not wish to query and then deploy the BRBeans JAR file.

Isolation level

The default isolation level is REPEATABLE_READ. Oracle does not support this isolation level. Therefore, the IBM WebSphere runtime environment converts this to the next highest isolation level, which in this case is SERIALIZED. Be aware that this isolation level tends to be overly restrictive as it prevents two clients from reading data at the same time. The BRBeansOracle.jar file specifies an isolation level of READ_COMMITTED.


Related concepts
Database considerations for BRBeans



Searchable topic ID:   cbrb_oracle
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_oracle.html

Library | Support | Terms of Use | Feedback