ColdFusion Enterprise and J2EE Editions include DataDirect Technologies JDBC type IV driver for Oracle. This high-performance database connectivity component from the leading Oracle JDBC driver vendor supports the latest Oracle database enhancements and the full JDBC 3.0 specification, including pooling enhancements, BLOB/CLOB updates including read/write support, support for Multiple Open Results Sets, and savepoints. No special ColdFusion Server configuration is required to use this driver.Note: Oracle Ref Cursors are only supported with the DataDirect Technologies Oracle JDBC Driver.
Customers may, however, choose instead to use the Oracle JDBC Type IV thin driver to connect to Oracle databases. This driver is distributed by Oracle and is included with the Oracle client software. It is also available by download at otn.oracle.com/software/content.html, under the Technologies, Utilities, and Drivers tab (This link requires a login to Oracle TechNet, which is free).
Note: For JDK versions 1.2 or 1.3, classes12.jar should be used. For JDK 1.4, ojdbc14.jar should be used.
This TechNote describes how to configure ColdFusion MX to use the Oracle JDBC Type IV thin driver. NOTE: The Oracle thin driver does not comply to the JDBC 3.0 specification.
Configuring ColdFusion MX to use the Oracle JDBC thin driver