TechNote

ColdFusion MX 7.0.2: JDBC hot fix for SQL update using third party Informix and Sybase drivers

Issue

This TechNote provides a hot fix for the following issues:

64229 - ColdFusion MX 7.0.2 throws "Method can be only called once" exception for any SQL update when using third party Informix and Sybase drivers. This issue does not occur with the drivers shipped with ColdFusion. This is a regression in 7.0.2 and it does not appear in previous versions of the product. Here is a partial stack trace of the exception:

 java.sql.SQLException: Method can be called only once.  at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:349)  at com.informix.jdbc.IfxStatement.getUpdateCount(IfxStatement.java:653)  at coldfusion.server.j2ee.sql.JRunStatement.getUpdateCount(JRunStatement.java:231)  at coldfusion.sql.Executive.getRowSet(Executive.java:293)  at coldfusion.sql.Executive.executeQuery(Executive.java:755)  at coldfusion.sql.Executive.executeQuery(Executive.java:674)  at coldfusion.sql.Executive.executeQuery(Executive.java:635)  at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)  at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:499)

64430 - ColdFusion returns same ResultSet when a query is called twice, first with MaxRows attribute set to specific value and later with no value. ColdFusion should return all rows when MaxRows attribute is not set.
66761 - ColdFusion 7.02 hangs after cfquery inserts or updates. Cfquery does not hang after a select statement. This behavior is seen with various database connections including Sequellink ODBC and various JDBC drivers. Note: This hotfix should be installed after installing either cumulative hot chf7020001 or chf702002 to resolve this last issue.

Solution

A hot fix has been created to correct the two issues above. Please follow the instructions below to apply the hot fix.

Installation Instructions

ColdFusion MX 7.0.2

Download and unzip the hot fix. (12K)
Open the ColdFusion MX Administrator and select the System Information page. Next to the Update File field, either:
- Type in the file path and click Submit.
  
  OR
- Select the Browse Button and browse to the downloaded file. Select the file and click apply.
Restart ColdFusion MX.

The ColdFusion MX 7 hot fix JAR file does not need to be retained after installing it with the ColdFusion Administrator. The file has been copied into the correct location.

The ColdFusion MX 7 hot fix JAR file will appear as a new entry in the System Information list.