System information

CONFIGURING AND ADMINISTERING COLDFUSION 9

Data Source Management

Last updated 2/21/2012

DataDirect Connect JDBC Support

ColdFusion 9 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 9 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.

A new admin API method, setMySQL_DD has been added, which lets you create a MySQL DataDirect data source.

New querytimeout connection option

As part of the DataDirect upgrade, the querytimeout option has been added in the Advanced Settings panel of the

Edit DSN page. The

querytimeout connection option sets the default query timeout values for a DSN.

Following is the description of querytimeout and pagetimeout from the DataDirect documentation:

"When the page time-out is much higher and the query times out, an exception is thrown to indicate that the query

has timed out. Similarly, if the query timeout is much higher and page times out, an exception is thrown to indicate

the page has timed out. However, when a page times out while a query is executing, the page times out only after the

query's execution is complete."

A new argument qtimeout has been added to the following methods in the Administrator API:

• setDB2()

• setMySQL_DD()