74
CONFIGURING AND ADMINISTERING COLDFUSION 10
Data Source Management
L
ast
u
p
dated
7/9/2
01
2
Note:
When you add an Apache Derby Embedded data source, ensure that the specified directory does not exist.
Connecting to DB2 Universal Database
For information on defining data sources that work with DB2 for OS/390 or iSeries, see “
Connecting to other data
sources
” on page 89. To see a list of DB2 versions that ColdFusion supports, go to
www.adobe.com/go/learn_cfu_cfsysreqs_en
.
Note:
DB2 Universal Database (UDB) refers to all versions of DB2 running on Windows, UNIX, and Linux/s390
platforms.
Use the settings in the following table to connect ColdFusion to DB2:
BLOB
Returns the entire contents of any BLOB/Image columns in the database for this data source. If deselected,
ColdFusion retrieves the number of characters specified in the BLOB Buffer setting. BLOBs are not supported on
UDB 7.1 and 7.2.
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.
Validation query
Called when a connection from the pool is resued. This can slow query response time because an additional query
is generated.Specify the validation query just before restarting the database to verify all connections, but remove
the validation query after restarting the database to avoid any performance loss.
Setting
Description
CF Data Source Name
The data source name (DSN) that ColdFusion uses to connect to the data source.
Database
The name of the database.
Server
The name of the server that hosts the database that you want to use. 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.
User name
The user name that ColdFusion 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).
The user name must have CREATE PACKAGE privileges for the database, or the database administrator must create
a package. Consult the database administrator when configuring this type of data source.
Password
The password that ColdFusion 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 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, enable the
Limit Connections option.
Maintain Connections
ColdFusion 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.
Setting
Description