TechNote

ColdFusion MX 6.1: Updated DataDirect drivers for 100% CPU utilization and other issues

Issue

This TechNote provides updated DataDirect JDBC version 3.3 drivers which resolve issues in earlier versions of the drivers. The new drivers provided in this TechNote should replace the 3.2 drivers shipped in ColdFusion MX 6.1 or the 3.1+ drivers previously available in this TechNote.

The DataDirect JDBC version 3.3 Drivers have been released in order to fix known bugs that were causing ColdFusion MX server stability issues. These DataDirect version 3.3 drivers also include two new features, Database Failover and SQL Server Windows Authentication support. These new features are not tested or supported with ColdFusion MX 6.1.

The DataDirect 3.3 drivers resolve the following issues:

All drivers

53947 - CFQUERY (timeout=) caused "DataDirect Connect Query Timeout-Thread" monitor threads to stack up under high load.

Oracle

49775 - Net8 Protocol error with large amounts of client variable data. (light load)
52262 - CLOB update with 2000+ chars failed with NLS_CharacterSet EL8MSWIN1253, JA16SJIS.
53182 - CLOBs of around 3-6MB returned 0 bytes.
53357 - CLOB retrieval returned 0 bytes from NLS_CharacterSet EL8MSWIN1253, JA16SJIS.
53357 - CLOB update fails with NLS_CharacterSet WE8ISO8859P15.
53366 - NLS_Characterset "ELM8MSWIN1253" hung while retrieving CLOBs.
53466 - CLOB select threw java.lang.ArrayIndexOutOfBoundsException with NLS_CharacterSet: JA16SJIS.
53477 - "No more data available to read" error when connected to Oracle 9i JA16SJIS database. (could be SELECT, UPDATE, INSERT)
53750 - Driver would not accept VARCHAR out params greater than 2000 characters.
53752 - Hang with CLOB retrieve and NLS_CharacterSet WE8ISO8859P15.
53758 - ArrayIndexOutOfBoundsException on CLOB SELECT on Oracle9i with NLS_CharacterSet JA16SJIS.

SQL Server

52851 - 100% CPU utilization when SQL server unexpectedly closes a connection.
53280, 53556 - ArrayIndexOutOfBoundsException 2048 char SQL Statement.
53492 - "Unhandled Token Type" under light load.

DB2

53347 - SQL statement needs to be on one line without tabs. (New œ>StripNewLines for DB2 not handling white space)

Informix

53592 - SELECT INTO TEMP fails.

Known issues with 3.3 drivers

51266 - SQL Server: Misleading "No more data available to read" thrown when database license maximum connections exceeded.
53588, 53366 - All drivers: Driver hangs in finalizer in some configurations.
DB2: Virtual storage or database resource is not available". Workaround: Increase the database configuration parameter (applheapsz) to allow a larger application heap.

Changes in behavior

54340 - Oracle: Change in behavior from 3.2, fetching numeric columns such as (7,4). 12.12 (3.2 drivers); 12.1200 (3.3 drivers).

Note: These drivers have been tested with ColdFusion MX 6.1 only. Use of these drivers with previous releases of ColdFusion MX is not supported and may produce undesirable results.

Solution

If affected by any of the conditions listed above, use the following steps to install the updated DataDirect drivers (version 3.3):

Server configuration and J2EE configuration with JRun:

Download the drivers.
Backup the existing macromedia_drivers.jar file located in /cf_root/lib.
Stop the ColdFusion process.
Using WinZip or the archive program of your choice, open the macromedia_drivers.zip file and extract the updated macromedia_drivers.jar file to the /cf_root/lib directory.
Restart ColdFusion.

Note: The workaround detailed in TechNote 18772 does not need to be implemented with the version 3.3 drivers, as the reverse lookup issue has been resolved in these drivers.

J2EE configuration other than JRun:

Download the drivers.
Backup the existing macromedia_drivers.jar file located in ./WEB-INF/cfusion/lib.
NOTE: Make sure the macromedia_driver.jar file you back up is saved outside of the jrun server tree to rule out the wrong driver jar being used.
Using WinZip or the archive program of your choice, open the macromedia_drivers.zip file and extract the updated macromedia_drivers.jar file to the ./WEB-INF/cfusion/lib directory.
Stop and restart the J2EE server for changes to take effect.
Repeat steps for each deployed instance of ColdFusion.