72
CONFIGURING AND ADMINISTERING COLDFUSION 10
Data Source Management
L
ast
u
p
dated
7/9/2
01
2
•
Data source names can contain only letters, numbers, hyphens, and the underscore character (_).
•
Data source names must not contain special characters or spaces.
•
Although data source names are not case sensitive, use a consistent capitalization scheme.
•
Depending on the JDBC driver, connection strings and JDBC URLs might be case sensitive.
•
Use the Administrator to verify that ColdFusion can connect to the data source.
•
A data source must exist in the ColdFusion Administrator before you use it on an application page to retrieve data.
Connection Issues
Executing a query when you restart a database can result in error during the first request. The error does not occur in
subsequent requests or if connection pooling is disabled. This is because, during the first request, the cached
connection is used to execute the query, leading to an exception. To overcome this issue, validate the connection before
executing the query.
Provide validationQuery (to validate the connection) before executing the query in the Advanced Settings page.
Note:
validationQuery has to be used with caution as it can result in performance issues.
Connecting to Apache Derby Client
Use the settings in the following table to connect ColdFusion to Apache Derby Client:
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.
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.
Timeout (min)
The number of minutes that ColdFusion MX maintains an unused connection before destroying it.
Disable Connections
If selected, suspends all client connections.
Login Timeout (sec)
The number of seconds before ColdFusion times out the attempt to log in to the data source connection.