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.
- 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.
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.
|Components:||Crash Protection, JDBC, Request Managment|
|Last Updated:||07/Sep/07 5:18 PM|
|Affects Version:||1.0, 2.0, 2.0.3, 2.0.4, 3.0|
|Server:||ColdFusion 6, ColdFusion 7|