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.