ColdFusion MX support for Oracle OCI JDBC driver

ColdFusion MX provides only limited support for the Oracle OCI JDBC driver. This TechNote describes the problems with the OCI driver and any workarounds for OCI issues.

Oracle's OCI driver is a Type 2 JDBC driver. It implements the JDBC interface and uses the OCI (Oracle Call Interface) native driver to interact with the database. This requires that you install the Oracle client software on the same machine. Because OCI is not a pure Java JDBC driver (Type 4 drivers are pure Java), it requires Oracle-specific JDBC calls for performing some database operations. These non-standard JDBC calls make the OCI driver not fully compatible with ColdFusion MX.

The following database operations are not supported in ColdFusion MX with the Oracle OCI JDBC driver.

Cannot SELECT/UPDATE/INSERT/DELETE columns with the data type BLOB.

Cannot SELECT/UPDATE/INSERT/DELETE columns with the data type CLOB.

Cannot use Oracle Ref Cursors.

The following database operations have limited support in ColdFusion MX with the Oracle OCI JDBC driver.

OCI driver can not be used for database storage of client variables. Note, this functionality is planned to be added in Updater Release 3.

SELECT/UPDATE/INSERT/DELETE with the following data types:

VARCHAR2
NUMBER
DATE
LONG

If you encounter a problem executing SQL with other datatypes, please try the code using the Oracle Thin Client driver or the Macromedia Oracle Driver provided with ColdFusion MX Enterprise. Both the Oracle Thin Client and the Macromedia Oracle drivers are Type 4 JDBC drivers which makes them better suited for use with ColdFusion MX.

If you have other questions or concerns please contact Macromedia Technical Support.

Subtotal
Promotions
Estimated Shipping
VAT	Calculated at checkout

Total

ColdFusion MX support for Oracle OCI JDBC driver

Products Affected

Additional Information

Products

Download

Support & Learning

Buy

Company