![]() |
|
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 datatype of LVARCHAR
is used by BRBeans. The maximum
length for an Informix LVARCHAR
is 2K. If 2K is not acceptable,
and your application does not need to query these datatypes, you can change
the schema mapping to specify CLOB
. Then deploy the BRBeans
jar file.
Custom properties for the datasource
When configuring the datasource for your application, you must specify the following properties:
ifxIFXHOST=Name of the physical machine on which the Informix instance
is installed
serverName=Informix instance name
portNumber=Port number for which the Informix instance is configured
informixLockModeWait=500
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.
Related concepts... | |
Parent: Database considerations | |
Oracle considerations | |
Sybase considerations | |
View PDF file... | |
To view a PDF file containing this article and related articles, click: | |
![]() | |
![]() |