User Guide

Chapter 4: Managing Data Sources 85
Verifying ColdFusion Data Sources
The ColdFusion Administrator includes a facility for verifying data sources configured
for ColdFusion, that is, making sure that a data source has been correctly configured
and is available to your ColdFusion application pages.
Note You may need to supply a username and password for the data sources
you want to verify. To define a username and password for a data source,
edit the properties for the data source.
Connection timeout Specify the maximum amount of time after the database
connection is made (in minutes) you want ColdFusion to
cache a connection after it is used.
This is different from the server setting to Limit database
connection inactive time. This latter setting is server wide
and only releases cached connections that have been
inactive (not used) for the specified period of time. The
Connection Timeout setting does not return a connection
to the cache after a specified period of time no matter how
frequently or infrequently it has been used. The default is ""
or 0 which means the connection timeout is never
enforced.
Restrict SQL Operations Select the SQL operations you want to restrict for the
current data source. ColdFusion will not execute the SQL
operations you select in this list.
Enable retrieval of long
text
Retrieves all the data for a long text field. ColdFusion
retrieves the column with the long text field and any
subsequent columns in the select statement as unbound
data. Unbound data takes longer to retrieve than bound
data; therefore, enabling this setting can affect
performance. If you use this setting, you should order the
columns in your select statement with the long text fields
referenced last.
Long Text Buffer Size Specifies the number of characters to retrieve from a long
text field if "Enable retrieval of long text" is not set. In this
case, ColdFusion binds text columns to a buffer whose size
you specify in this field. If you specify a size that is not
supported by your database, an SQL execution error occurs
when you try to retrieve the data.
ColdFusion Data Source Settings (Continued)
Option Description