tracker issue : CF-3123054

Duplicate ID:	CF-3043838

Problem Description:
When trying to insert or update any field in the DB2 database, the following exception is thrown –
java.lang.NullPointerException at coldfusion.sql.CFNoResultSetTable.<init>(CFNoResultSetTable.java:46)
Despite this, the data gets inserted / updated as desired. This suggests that it is an error with the DB2 driver.

Steps to Reproduce:
Use a cfquery tag with a select / insert SQL such as the following -
UPDATE <TABLE_NAME> SET <COLUMN_NAME> = '<VALUE>' WHERE <CONDITION>

Actual Result:
The database gets updated as expected, but an exception is thrown, as below -
java.lang.NullPointerException at coldfusion.sql.CFNoResultSetTable.<init>(CFNoResultSetTable.java:46) at coldfusion.sql.Executive.getRowSet(Executive.java:606) at coldfusion.sql.Executive.executeQuery(Executive.java:1383) at coldfusion.sql.Executive.executeQuery(Executive.java:1127) at coldfusion.sql.Executive.executeQuery(Executive.java:1058) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590) at cftest2ecfm1527822005.runPage(D:\Websites\PCACS\wwwroot\zAjit\test.cfm:10) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:360) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:94) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126) at coldfusion.CfmServlet.service(CfmServlet.java:200) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) 

Expected Result:
No  exception would be thrown

Any Workarounds:
Catch the exception silently and discard

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3123054

External Customer Info:
External Company:  
External Customer Name: Ajit S Warrier
External Customer Email:  
External Test Config: My Hardware and Environment details:

ColdFusion 9,0,0,251028

DB2  version 9

Attachments:

Comments: