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:
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.