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.
