Uploaded image for project: 'Lucee Development'
  1. LDEV-413

Oracle JDBC Not working properly with cfstoredproc and cfprocresult

    Details

    • Type: Bug
    • Status: Deployed
    • Priority: New
    • Resolution: Fixed
    • Affects Version/s: 4.5.1.014
    • Fix Version/s: 5.0.0.235
    • Labels:
      None
    • Environment:

      Windows - Express - Lucee 4.5.0.042 final

      Description

      Receiving the following error when executing code that works perfectly fine with ACF and everything seems to match the documentation...

      Lucee 4.5.0.042 Error (java.lang.IndexOutOfBoundsException)
      Message Index: 19, Size: 11
      Cause java.lang.IndexOutOfBoundsException
      Stacktrace The Error Occurred in
      C:\Users\John\Downloads\lucee\webapps\ROOT\WEB-INF\lucee\customtags\n_get_messages.cfm: line 423
      421: <cfprocparam cfsqltype="CF_SQL_VARCHAR" value="#inHowHeardID#" type="In">
      422: <cfprocresult name="msgResults">
      423: </cfstoredproc>
      424: </cfif>
      425:

      called from C:\Users\John\Downloads\lucee\webapps\ROOT\cfcs\messages.cfc: line 77
      called from C:\Users\John\Downloads\lucee\webapps\ROOT\WEB-INF\lucee\customtags\header.cfm: line 313
      called from C:\Users\John\Downloads\lucee\webapps\ROOT\oncology\news.cfm: line 332
      called from C:\Users\John\Downloads\lucee\webapps\ROOT\oncology\index.cfm: line 1
      called from C:\Users\John\Downloads\lucee\webapps\ROOT\Application.cfc: line 1339
      Java Stacktrace Index: 19, Size: 11
      at java.util.ArrayList.rangeCheckForAdd(Unknown Source):-1
      at java.util.ArrayList.add(Unknown Source):-1
      at lucee.runtime.tag.StoredProc.returnValue(Unknown Source):-1
      at lucee.runtime.tag.StoredProc.doEndTag(Unknown Source):-1
      at n_get_messages_cfm$cf.call(C:\Users\John\Downloads\lucee\webapps\ROOT\WEB-INF\lucee\customtags\n_get_messages.cfm:423):423
      at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
      at lucee.runtime.tag.CFTag.doInclude(Unknown Source):-1
      at lucee.runtime.tag.CFTag.cfmlStartTag(Unknown Source):-1
      at lucee.runtime.tag.CFTag.doStartTag(Unknown Source):-1
      at cfcs.messages_cfc$cf.udfCall1(C:\Users\John\Downloads\lucee\webapps\ROOT\cfcs\messages.cfc:77):77
      at cfcs.messages_cfc$cf.udfCall(C:\Users\John\Downloads\lucee\webapps\ROOT\cfcs\messages.cfc):-1
      at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
      at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
      at lucee.runtime.type.UDFImpl.callWithNamedValues(Unknown Source):-1
      at lucee.runtime.ComponentImpl._call(Unknown Source):-1
      at lucee.runtime.ComponentImpl._call(Unknown Source):-1
      at lucee.runtime.ComponentImpl.callWithNamedValues(Unknown Source):-1
      at lucee.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(Unknown Source):-1
      at lucee.runtime.PageContextImpl.getFunctionWithNamedValues(Unknown Source):-1
      at header_cfm$cf.call(C:\Users\John\Downloads\lucee\webapps\ROOT\WEB-INF\lucee\customtags\header.cfm:313):313
      at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
      at lucee.runtime.tag.CFTag.doInclude(Unknown Source):-1
      at lucee.runtime.tag.CFTag.cfmlStartTag(Unknown Source):-1
      at lucee.runtime.tag.CFTag.doStartTag(Unknown Source):-1
      at oncology.news_cfm$cf.call(C:\Users\John\Downloads\lucee\webapps\ROOT\oncology\news.cfm:332):332
      at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
      at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
      at oncology.index_cfm$cf.call(C:\Users\John\Downloads\lucee\webapps\ROOT\oncology\index.cfm:1):1
      at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
      at lucee.runtime.PageContextImpl.doInclude(Unknown Source):-1
      at application_cfc$cf.udfCall(C:\Users\John\Downloads\lucee\webapps\ROOT\Application.cfc:1339):1339
      at lucee.runtime.type.UDFImpl.implementation(Unknown Source):-1
      at lucee.runtime.type.UDFImpl._call(Unknown Source):-1
      at lucee.runtime.type.UDFImpl.call(Unknown Source):-1
      at lucee.runtime.ComponentImpl._call(Unknown Source):-1
      at lucee.runtime.ComponentImpl._call(Unknown Source):-1
      at lucee.runtime.ComponentImpl.call(Unknown Source):-1
      at lucee.runtime.listener.ModernAppListener.call(Unknown Source):-1
      at lucee.runtime.listener.ModernAppListener._onRequest(Unknown Source):-1
      at lucee.runtime.listener.MixedAppListener.onRequest(Unknown Source):-1
      at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
      at lucee.runtime.PageContextImpl.execute(Unknown Source):-1
      at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(Unknown Source):-1
      at lucee.loader.servlet.CFMLServlet.service(Unknown Source):-1
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:725):725
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291):291
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239):239
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206):206
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219):219
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106):106
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501):501
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142):142
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79):79
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610):610
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88):88
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537):537
      at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1085):1085
      at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658):658
      at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222):222
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1556):1556
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1513):1513
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source):-1
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
      at java.lang.Thread.run(Unknown Source):-1

      Timestamp 6/29/15 10:14:40 PM EDT

        Attachments

          Activity

            People

            • Assignee:
              michaeloffner Michael Offner
              Reporter:
              jceci John Ceci
            • Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: