Issue

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:

  1. 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.
  2. Unzip the Instant Client package according to the documentation (for example, C:\instantclient10_1). Be sure to configure the library path in your appropriate environment variable (PATH on Windows; LD_LIBRARY_PATH on Unix).
  3. Place the appropriate Oracle Instant Client Java libraries in the ColdFusion MX Class Path field:
    • Server Configuration: Place the ojdbc14.jar incf_root/wwwroot/WEB-INF/lib
    • J2EE Configuration: Place the ojdbc14.jar incf_web_root/WEB-INF/lib
  4. Restart ColdFusion MX.
  5. Access the ColdFusion MX Administrator Data Sources screen to configure a data source for Oracle:

    For example:
    1. Name the data source ps_db when it will connect to the ps-db Oracle database.
    2. Select other in the driver field to tell ColdFusion you will describe another type of driver.
    3. Click Add to add the data source and display the default driver window for this driver.
  6. 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).

  7. Enter the following in the Driver Class field:



    oracle.jdbc.OracleDriver



    Note: The information in this field is case-sensitive.
  8. Enter a valid username and password in the Username and Password fields.



    Where the username and password are defined as user account information on the database server.
  9. (Optional) Enter the name of the driver in the Driver Name field.
  10. Click submit to apply the changes to the data source.

Additional Information

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License  Twitter™ and Facebook posts are not covered under the terms of Creative Commons.

Legal Notices   |   Online Privacy Policy