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. |
Username |
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 required by the JNDI data source. Use comma separated list of name/value pair. For example if you must specify a username 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. |