93
CONFIGURING AND ADMINISTERING COLDFUSION 10
Data Source Management
L
ast
u
p
dated
7/9/2
01
2
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):
Note:
The ColdFusion Administrator does not display the JNDI data source option when running in the server
configuration.
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.
Validation query
Called when a connection from the pool is resued. This can slow query response time because an
additional query is generated. Specify the validation query before restarting the database to verify all
connections, but remove the validation query after restarting the database to avoid any performance
loss.
Client Hostname
The host name from where the query is executed.
Client Username
The user name if the user is logged in using the <cflogin> tag.
Application Name
The application name specified in the application.cfc.
Prefix
If specified, the value is prefixed with the application name specified in application.cfc.
Enable connection validation
Check if to validate the connection.
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.
Setting
Description