Macromedia ColdFusion MX Enterprise edition includes the DataDirect Technologies JDBC type IV driver for Oracle. This high-performance database connectivity component 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 Instant Client supplied by Oracle. The Oracle Instant Client provides drivers for supporting JDBC, OCCI, OCI, ODBC, and Pro*C applications. Customers can download the Oracle Instant Client at no cost from the Oracle Technet site. Once installed, ColdFusion customers can use JDBC URLs to integrate with Oracle databases using the JDBC and OCI libraries.
Follow these steps to configure ColdFusion MX with the Oracle Instant Client:
Download the latest version of the Oracle Instant Client packages for the appropriate 32-bit platform.
Note: The latest version (as of 1/30/2006) is 10.2.0.1, which is backwards compatible with Oracle 8.1.7, 9.0.1.x, 9.2.x, and 10.0.x.
Access the ColdFusion MX Administrator Data Sources screen to configure a data source for Oracle:
Enter one of the following in the JDBC URL:
- For Oracle Thin client:jdbc:oracle:thin:@ps-db:1521:pubs
- For Oracle OCI client:jdbc:oracle:oci:@ps-db:1521/pubs
Where ps-db is the name of the database server.
Where 1521 is the port number for the data source connection (assuming the Oracle default port 1521).
Where pubs is the Oracle System Identifier (SID).