Large character data
The preferred Informix data type for storing large character data is CLOB. However, Informix does not allow a CLOB to be queried. Because of this, a data type of LVARCHAR is used by BRBeans. The maximum length for an Informix LVARCHAR is 2,000 characters. If 2,000 characters is not acceptable and your application does not need to query these data types, you can change the schema mapping to specify CLOB. Then, deploy the BRBeans JAR file.
Custom properties for the data source
When configuring the data source for your application, you must specify the following properties:
A setting of 500 causes a connection to wait for up to 500 seconds for a lock. If you have a busy system, this wait can appear to be a system hang. This setting has the same effect as running SET LOCK MODE TO WAIT 500 on the connection.
Note: The previous configuration values are subject to change. Consult your Informix documentation for updates.