System information

CONFIGURING AND ADMINISTERING COLDFUSION 9

Data Source Management

Last updated 2/21/2012

Note: The ColdFusion Administrator does not display the JNDI data source option when running in the server

configuration.

Connecting to an external JDBC Type 4 data source

To use a JDBC driver that is not included with ColdFusion (such as SQLAnywhere) configure the JDBC driver and

add a data source for it.

Connect to an external JDBC data source:

1 Copy the database driver .jar file to one of the following directories:

• (server configuration only) cf_root/lib

• (multiserver or J2EE configuration) cf_webapp_root/WEB-INF/cfusion/lib

2 Restart ColdFusion.

Note: In Windows, ensure that you restart all of the ColdFusion 9 services.

3 In the ColdFusion Administrator, add the other JDBC Type 4 data source, selecting Other from the Driver drop-

down list.

For more information, see the chapter on data source management in Configuring and Administering ColdFusion.

You can now connect to an external JDBC Type 4 data source.

Description (Optional) A description for this connection.

JNDI Environment Settings Specifies additional JNDI environment settings, if necessary by the JNDI data source. Use comma-

separated list of name-value pair. For example if you must specify a user name and password to connect

to JNDI, specify the following:

SECURITY_PRINCIPAL="myusername",SECURITY_CREDENTIALS="mypassword"

CLOB Select to return the entire contents of any CLOB/ Text columns in the database for this data source. If not

selected, ColdFusion retrieves the number of characters specified in the Long Text Buffer setting.

BLOB Select to return the entire contents of any BLOB/ Image columns in the database for this data source. If

not selected, ColdFusion retrieves the number of characters specified in the BLOB Buffer setting.

LongText Buffer The default buffer size; used if Enable Long Text Retrieval (CLOB) is not selected. The default value is

64000 bytes.

BLOB Buffer 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.

Setting Description