Whenever I try a delete in the Cold Fusion page with the cfquery tag, I get
the following error:
JZ0CU: getUpdateCount can only be called once after a successful call to
getMoreResult, or execute methods.
It's a very simple delete. Queries seem to work fine. Please email me
with any repsonses.
Thanks for any help.
Jim Ward
jim....@us.army.mil
pv
Jim_Ward wrote:
> Here is the stack trace. I'm not quite sure what you mean by what
> implementation.
>
> java.sql.SQLException: JZ0CU: getUpdateCount can only be called once after
> a successful call to getMoreResult, or execute methods.
> at
> com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
> at
> com.sybase.jdbc2.jdbc.SybStatement.getUpdateCount(SybStatement.java:806)
> at jrun.sql.JRunStatement.getUpdateCount(JRunStatement.java:428)
> at coldfusion.sql.Executive.getRowSet(Unknown Source)
If you can send the coldfusion.sql.Executive.getRowSet.class file,
it will be easy to determine whether it is written to commit the error the
driver claims it is doing. Alternately, if you are comfortable with decompilers
you can decompile the sybase driver class to print out when getUpdateCount()
is called, and when getMoreResults() is called. Recompile and use your
version, and you will see whether the coldfusion class does what the driver
claims.
Joe Weinstein at BEA
>
> at coldfusion.sql.Executive.executeQuery(Unknown Source)
> at coldfusion.sql.Executive.executeQuery(Unknown Source)
> at coldfusion.sql.SqlImpl.execute(Unknown Source)
> at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
> at
> cfdelete_test2ecfm2109839780.runPage(D:\CFusionMX\wwwroot\Evaluations\delete_test.cfm:8)
> at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
> at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
> at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
> at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
> at coldfusion.filter.PathFilter.invoke(Unknown Source)
> at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
> at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown
> Source)
> at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
> at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
> at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
> at coldfusion.CfmServlet.service(Unknown Source)
> at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
> at
> jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
> at
> jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
> at
> jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
> at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
> at
> jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
> at
> jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
> at
> jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
> at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
java.sql.SQLException: JZ0CU: getUpdateCount can only be called once after
a successful call to getMoreResult, or execute methods.
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
at
com.sybase.jdbc2.jdbc.SybStatement.getUpdateCount(SybStatement.java:806)
at jrun.sql.JRunStatement.getUpdateCount(JRunStatement.java:428)
at coldfusion.sql.Executive.getRowSet(Unknown Source)
It will be included in the next CFMX maintenance release or you can contact
Macromedia Tech Support.
<jerry> wrote in message
news:730A84F496EA9BFB0038BE7185256D35.005D414D85256D1E@webforums...