System information

55
CONFIGURING AND ADMINISTERING COLDFUSION 9
Data Source Management
Last updated 2/21/2012
Connection string Specify one connection string for the first connection, and then modify it for use in subsequent
connections, as follows:
1 On the initial connection, specify LocationName, CollectionId, CreateDefaultPackage, and
sendStringParametersAsUnicode (with no spaces) as the following example shows:
LocationName=SAMPLE;CollectionId=DEFAULT;CreateDefaultPackage=TRUE;sendStringParametersAs
Unicode=false
Note: If the database uses Unicode, specify true for the sendStringParametersAsUnicode parameter.
2 On subsequent connections, specify LocationName, CollectionId, and sendStringParametersAsUnicode, as the
following example shows:
LocationName=SAMPLE;CollectionId=DEFAULT;sendStringParametersAsUnicode=false
Note: DB2 OS/390 refers to all supported versions of DB2 on OS/390 and z/OS platforms. DB2 iSeries refers to all
supported versions of DB2 on iSeries and AS/400.
For more information on DB2, see “Connecting to DB2 Universal Database” on page 39.
Connecting to PostgreSQL
To see a list of PostgreSQL versions that ColdFusion supports, go to www.adobe.com. Use the settings in the following
table to connect ColdFusion to PostgreSQL data sources:
Setting Description
CF Data Source Name The data source name (DSN) that ColdFusion uses to connect to the data source.
Database The database to which this data source connects.
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. This name must be either a fully qualified domain name (resolvable through
DNS) or an IP address. It cannot be a netbios name (even if you are running NBT), or an alias you set up
using the client connectivity wizard (both of these approaches worked in earlier ColdFusion versions).
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).
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.
Timeout (min) The number of minutes that ColdFusion MX maintains an unused connection before destroying it.
Interval (min) The time (in minutes) that the server waits between cycles to check for expired data source connections
to close.