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.
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
Configuring ColdFusion MX to use the Oracle JDBC thin driver
Enter the class path in the Class Path field on the ColdFusion MX Administrator's Java and JVM page.
For example, C:\Oracle\ora81\jdbc\lib\classes12.zip, where the Oracle Client is installed in C:\Oracle and the classes12.zip file is located in C:\Oracle\ora81\jdbc\lib.
Note: Use a comma (,) to separate class paths when this field contains multiple values.
Use the ColdFusion MX Administrator Data Source page to add a new data source for the thin client:
Enter the following in the JDBC URL field:
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).
Note: The information in this field is case-sensitive.