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.