Connecting to JNDI data sources

Use the settings in the following table to connect ColdFusion to JNDI data sources that are defined for a J2EE application server (multiserver and J2EE configurations only):

Setting

Description

CF Data Source Name

The data source name (DSN) that ColdFusion uses to connect to the data source.

JNDI Name

The JNDI location in which the J2EE application server stores the data source.

User name

The user name that ColdFusion passes to JNDI to connect to JNDI if a ColdFusion application does not supply a user name (for example, in a cfquery tag).

Password

The password that ColdFusion passes to JNDI 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.

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.

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