Select ColdFusion Settings

If you click CF Settings while configuring a data source, additional fields appear on your configuration screen. To select ColdFusion Settings:

  1. Complete the fields as described in the following table. Note that the Simple button returns you to your main Create Data Source page.

 

Setting

Description

Default

Login Timeout

Enter the number of seconds before ColdFusion times out the connection login page.

30

Limit Connections

To limit simultaneous connections to the data source, enable this option and enter the number of connections allowed.

 

Note: If you enable this option without specifying a limit, ColdFusion defaults to unlimited connections.

Unlimited

ColdFusion Login/Username and Password

To limit access to the data source to trusted users, enter a username and password. Any username specified in a cfquery or other data access tag overrides values specified here.

 

Also, when you create a data source using a native database driver, use the username and password options to pass login information to the database.

 

Note: A common reason for verification failure of a data source is a missing username and password.

Disabled

Disable database connections

Enable this option if you want to disable connections to the data source. Use this setting when you perform administrative tasks on the database. You cannot establish new connections to a disabled data source.

 

ColdFusion automatically disconnects any idle connections, and notifies any connection currently in use to stop as soon as the current transaction is complete.

 

Be sure to disable this setting to restore the data source connection when you finish with administrative tasks.  

Disabled

Maintain database connections

ColdFusion establishes a connection to a data source for every operation that requires it. Enable this option to improve performance by caching the database connection.

Enabled

Connection Timeout

Enter the maximum number of minutes after the database connection is made that you want ColdFusion to cache a connection after it is used.

 

This option is different from the server setting "Limit database connection inactive time," which is server-wide and releases only cached connections that have been inactive for the specified period.

 

This  "Connection Timeout" setting does not return a connection to the cache after a specified time no matter how often it is used.

"" or 0 to indicate that the connection timeout is never enforced

Restrict SQL Operations

Select the SQL operations that you want to restrict for the current data source. To allow all SQL operations, clear all check boxes. To allow specific SQL operations, select the check boxes.

Disabled

Enable retrieval of long text

Enable this option to retrieve all the data for a long text field. If you use this setting, order the columns in your Select statement with the long text fields referenced last.

 

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, this setting can slow performance speed.

Disabled

Long Text Buffer Size

Enter the maximum number of characters to retrieve from a long text field if you do not select "Enable retrieval of long text." In this case, ColdFusion binds text columns to a buffer with the size you specify here.

 

If you specify a size that is not supported by the database, a SQL execution error occurs when you try to retrieve data. If you activate the  "Enable retrieval of long text" option,  ColdFusion uses this buffer size to retrieve the unbound text column until all data is returned.

65,000 characters

Connection String

Enter any connection attributes that cannot be included in the ODBC data source definition. For details, see Use Connection String options.

Blank

 

  1. Click Create. ColdFusion Administrator verifies automatically that it can connect to the data source. If verification succeeds, the Data Source page displays with the new data source highlighted. If the verification fails, an error message displays.

Related topics