I’m trying to execute a basic SQL query
var bins = new query(sql=“SELECT TOP 1 * FROM bins WHERE is_assigned =
0;”).execute().getResult();
Its a nothing special query. It works about 90% of the time. However every
once and a while it throws the following error
No matching Method/Function for String.setResult(query) found
at lucee.runtime.reflection.Reflector.throwCall(Reflector.java:924):924
at lucee.runtime.reflection.Reflector.callMethod(Reflector.java:855):855
at lucee.runtime.type.util.MemberUtil.call(MemberUtil.java:106):106
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:752):752
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593
at
org.lucee.cfml.base_cfc$cf.udfCall1(/backup/lucee/ROOT/WEB-INF/lucee/components/org/lucee/cfml/Base.cfc:165):165
at
org.lucee.cfml.base_cfc$cf.udfCall(/backup/lucee/ROOT/WEB-INF/lucee/components/org/lucee/cfml/Base.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593
at
org.lucee.cfml.query_cfc$cf.udfCall(/backup/lucee/ROOT/WEB-INF/lucee/components/org/lucee/cfml/Query.cfc:53):53
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593
at
modules.slamweb.modules.slamwebajax.handlers.purchaseorder_cfc$cf.udfCall1(/backup/lucee/ROOT/modules/slamweb/modules/slamwebAJAX/handlers/purchaseorder.cfc:671):671
at
modules.slamweb.modules.slamwebajax.handlers.purchaseorder_cfc$cf.udfCall(/backup/lucee/ROOT/modules/slamweb/modules/slamwebAJAX/handlers/purchaseorder.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at
lucee.runtime.type.scope.ArgumentImpl.callWithNamedValues(ArgumentImpl.java:520):520
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at
lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1603):1603
at
modules.slamweb.modules.slamwebajax.handlers.home_cfc$cf.udfCall(/backup/lucee/ROOT/modules/slamweb/modules/slamwebAJAX/handlers/home.cfc:40):40
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at
lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at
lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1603):1603
at
coldbox.system.web.controller_cfc$cf.udfCall2(/backup/lucee/ROOT/coldbox/system/web/Controller.cfc:594):594
at
coldbox.system.web.controller_cfc$cf.udfCall(/backup/lucee/ROOT/coldbox/system/web/Controller.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at
lucee.runtime.type.scope.UndefinedImpl.callWithNamedValues(UndefinedImpl.java:775):775
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at
lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1603):1603
at
coldbox.system.web.controller_cfc$cf.udfCall2(/backup/lucee/ROOT/coldbox/system/web/Controller.cfc:425):425
at
coldbox.system.web.controller_cfc$cf.udfCall(/backup/lucee/ROOT/coldbox/system/web/Controller.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:216):216
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:643):643
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at
lucee.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1778):1778
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at
lucee.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1603):1603
at
coldbox.system.bootstrap_cfc$cf.udfCall1(/backup/lucee/ROOT/coldbox/system/Bootstrap.cfc:197):197
at
coldbox.system.bootstrap_cfc$cf.udfCall(/backup/lucee/ROOT/coldbox/system/Bootstrap.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.type.scope.UndefinedImpl.call(UndefinedImpl.java:766):766
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593
at
coldbox.system.bootstrap_cfc$cf.udfCall1(/backup/lucee/ROOT/coldbox/system/Bootstrap.cfc:353):353
at
coldbox.system.bootstrap_cfc$cf.udfCall(/backup/lucee/ROOT/coldbox/system/Bootstrap.cfc):-1
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at
lucee.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:743):743
at lucee.runtime.PageContextImpl.getFunction(PageContextImpl.java:1593):1593
at application_cfc$cf.udfCall(/backup/lucee/ROOT/Application.cfc:108):108
at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:111):111
at lucee.runtime.type.UDFImpl._call(UDFImpl.java:328):328
at lucee.runtime.type.UDFImpl.call(UDFImpl.java:229):229
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642
at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524
at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1761):1761
at
lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414
at
lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:133):133
at
lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2265):2265
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2228):2228
at
lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:456):456
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727):727
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220):220
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170):170
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98):98
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408):408
at
org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041):1041
at
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607):607
at
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313):313
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145):1145
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615
at java.lang.Thread.run(Thread.java:745):745
I am using ColdBox however this error appears to have nothing to do with
ColdBox.
I’m using Lucee 4.5.3.015 final on ubuntu
Any suggestions?