83
CONFIGURING AND ADMINISTERING COLDFUSION 10
Data Source Management
L
ast
u
p
dated
7/9/2
01
2
DataDirect Connect JDBC Support
ColdFusion supports the latest version of DataDirect drivers for database operations. These drivers improve
performance and provide support for additional databases.
DataDirect driver features
ColdFusion transacts with the database server using the DataDirect drivers that are available as packaged JAR files.
Upgrade the JAR files to the latest version to be able to use the new features and performance enhancements.
ColdFusion supports DataDirect driver version 4.0 SP 1, which provides the following features to enhance database
operations:
•
Support for MySQL (Enterprise and Commercial), Oracle11g, DB2v9.5, Informix 11, SQL Server 2008
Note:
For Oracle databases, if you want to filter the retrieval of column names or indexes for a particular schema, then
the schema name must be provided along with the table name in the
table
attribute. In this case, the format of the
table
attribute value is:
schemaname.tablename
.
•
Improved performance
•
IPv6 Address Support
•
Querytimeout connection option to set default query timeout value. For details, see
New querytimeout connection
option
.
Creating a data source in MySQL
To create a MySQL Enterprise ColdFusion data source, select the driver type as
MySQL(Datadirect)
from the drivers
pop up menu in ColdFusion Administrator.
Note:
The MySQL5 Enterprise database sometimes requires access permission for all users who try to connect to it, if the
access permission is not specified during configuration.
To grant the required permission, you can use the command:
grant all on *.* to 'root'@'%' identified by
'admin';
.
Replace
root
and admin by MYSQL username and MYSQL password, respectively.
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.
Validation query
Called when a connection from the pool is resued. This can slow query response time because an
additional query is generated. You should specify this just before restarting the database to verify all
connections, but remove the validation query after restarting the database to avoid any performance
loss.
Setting
Description