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.