
Connecting to Informix 49
Connecting to Informix
To see a list of Informix versions that ColdFusion MX supports, go to
www.macromedia.com/go/sysreqscf. Use the settings in the following table to connect
ColdFusion MX to Informix data sources:
LongText Buffer
(chr)
The default buffer size, used if the CLOB option is not selected. The default
value is
64000 bytes.
BLOB Buffer
(bytes)
The default buffer size, used if the BLOB option is not selected. The default
value is
64000 bytes.
Allowed SQL The SQL operations that can interact with the current data source.
Setting Description
CF Data Source
Name
The data source name (DSN) used by ColdFusion MX to connect to the data
source.
Database The database to which this data source connects.
Informix Server The name of the Informix database server to which you want to connect.
Server The name of the server that hosts the database. If the database is local, enclose
the word local in parentheses.
Port The number of the TCP/IP port that the server monitors for connections.
Username The user name that ColdFusion MX passes to the JDBC driver to connect to the
data source if a ColdFusion application does not supply a user name (for
example, in a
cfquery tag).
Password The password that ColdFusion MX passes to the JDBC driver to connect to the
data source if a ColdFusion application does not supply a password (for
example, in a
cfquery tag).
Description (Optional) A description for this connection.
Connection
String
A field that passes database-specific parameters, such as login credentials, to
the data source.
Limit
Connections
Specifies whether ColdFusion MX limits the number of database connections for
the data source. If you enable this option, use the Restrict Connections To field to
specify the maximum.
Restrict
Connections To
Specifies the maximum number of database connections for the data source. To
use this restriction, you must enable the Limit Connections option.
Maintain
Connections
ColdFusion MX establishes a connection to a data source for every operation
that requires one. Enable this option to improve performance by caching the data
source connection.
Max Pooled
Statements
Enables reuse of prepared statements (that is, stored procedures and queries
that use the
cfqueryparam tag). Although you tune this setting based on your
application, start by setting it to the sum of the following:
• Unique
cfquery tags that use the cfqueryparam tag
• Unique
cfstoredproc tags
Setting Description
Komentarze do niniejszej Instrukcji