[frs-172] When using builtin Macromedia/ColdFusion database drivers with CF6 and CF7 using SelectMethod=cursor, killing a request manually or with Crash Protection causes the request to hang indefinitely


Problem

You may not be able to kill a request which is performing database activity using the Macromedia (DataDirect) drivers supplied as the builtin drivers for CF6.1/MX, CF7/7.01 and/or JRun4.

Symptoms

  • Crash Protection Timeout Protection fires, and attempts to kill the request, marking it as in state "Killing", or,
  • You manually kill the request using FusionReactor's 'kill' feature
  • The request is, however, not killed, and continues indefinitely.

Due to a previous issue in revisions of FusionReactor prior to 2.5, the request would be removed from the Running Requests list, even though it was still running. This bug has been solved in 2.5, but has unmasked this prior issue, which existed in all revisions of FusionReactor.

This issue only occurs when using database cursors with SQL Server datasources (this is not the default mode for SQL Server datasources), i.e. the JDBC URL contains the phrase selectMethod=cursor. The issue does not occur when using Direct mode (the default mode).

The issue does not occur on ColdFusion 8.

Solution

Adobe has provided updated drivers for all affected revisions of ColdFusion and JRun. These are available at Adobe, at techote 42dcb10a.

We recommend that customers upgarde to these latest database drivers as a matter of course, since they bring stability and speed enhancements, as well as alleviating the problems outlined in this technote.

Note: These drivers alter the way ODBC datasources are managed by ColdFusion. For customers using ODBC datasources, or a mixture of ODBC and JDBC soruces, this new driver package is not a drop-in replacement. Please thoroughly read the Adobe technote to ensure you understand the repercussions of implementing this fix.

As far as we're aware, customers in a pure JDBC environment should be able to drop in this replacement without any adverse effects, but please do read the technote thoroughly first.

Issue Details

Type: Technote
Issue Number: FRS-172
Components: Crash Protection, JDBC, Request Managment
Environment:
Resolution: Fixed
Last Updated: 07/Sep/07 5:18 PM
Affects Version: 1.0, 2.0, 2.0.3, 2.0.4, 3.0
Fixed Version:
Server: ColdFusion 6, ColdFusion 7
Platform:
Related Issues: