cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
search
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0
Upvote

Oracle JDBC error No more data available to read.

joseph.yan
Explorer ,
Jul 01, 2015 Jul 01, 2015

Copy link to clipboard

Copied

Hi All,

I am using Oracle connected to Coldfusion 10,0,15,292620 and suddenly I got JDBC Oracle error saying "No more data available to read".

I am using Fusion Reactor and suddenly the query is taking 6844 ms from normal time about 160ms.

Try for the second time and it is fine. So I am just wondering is this Coldfusion Oracle JDBC bug.

Thanks

Joseph.

The error detail:

java.sql.SQLNonTransientConnectionException: [Macromedia][Oracle JDBC Driver]No more data available to read.

[Macromedia][Oracle JDBC Driver]No more data available to read.

The query statement:

UPDATE sectors_slots

SET

     xdoc_ids = <cfqueryparam cfsqltype="cf_sql_clob" value="#local.xDocIDs#" />,

     latest_version = <cfqueryparam cfsqltype="cf_sql_blob" value="#local.binaryJSON#" />,

     version_date = <cfqueryparam cfsqltype="cf_sql_timestamp" value="#local.dateNow#" />

WHERE

     sector_id = <cfqueryparam cfsqltype="cf_sql_integer" value="#local.sectorID#" /> AND time_slot = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.sectorSlot#" />

JDBC stack trace:

macromedia.jdbc.oraclebase.ddcr.b(null:???)
macromedia.jdbc.oraclebase.ddcr.a(null:???)
macromedia.jdbc.oraclebase.ddcq.b(null:???)
macromedia.jdbc.oraclebase.ddcq.a(null:???)
macromedia.jdbc.oraclebase.ddcq.a(null:???)
macromedia.jdbc.oracle.net8.ddk.c(null:???)
macromedia.jdbc.oracle.ddam.t(null:???)
macromedia.jdbc.oraclebase.dde3.w(null:???)
macromedia.jdbc.oraclebase.dde3.s(null:???)
macromedia.jdbc.oraclebase.dddz.execute(null:???)
macromedia.jdbc.oraclebase.ddd2.execute(null:???)
com.intergral.fusionreactor.jdbc.PreparedStatementSurrogate.execute(PreparedStatementSurrogate.java:224)
coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
coldfusion.sql.Executive.executeQuery(Executive.java:1467)
coldfusion.sql.Executive.executeQuery(Executive.java:1201)
coldfusion.sql.Executive.executeQuery(Executive.java:1131)
coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
cfModuleService2ecfc494738733$funcPREPARESECTORPUBLISH.runFunction(/var/www/html/com/industryintel/services/xdoc/ModuleService.cfc:590)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
cfAlertListener2ecfc1660993880$funcPREPARESECTORS.runFunction(/var/www/html/commons/listeners/AlertListener.cfc:3379)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:660)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:469)
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:402)
cfEventInvoker2ecfc1458357037$funcINVOKELISTENER.runFunction(/var/www/html/supportCfusion/MachII/framework/invokers/EventInvoker.cfc:94)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
cfNotifyCommand2ecfc269113347$funcEXECUTE.runFunction(/var/www/html/supportCfusion/MachII/framework/commands/NotifyCommand.cfc:95)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
cfEventHandler2ecfc1598006774$funcHANDLEEVENT.runFunction(/var/www/html/supportCfusion/MachII/framework/EventHandler.cfc:88)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
cfRequestHandler2ecfc1121342851$funcHANDLEEVENT.runFunction(/var/www/html/supportCfusion/MachII/framework/RequestHandler.cfc:386)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
cfRequestHandler2ecfc1121342851$funcHANDLENEXTEVENT.runFunction(/var/www/html/supportCfusion/MachII/framework/RequestHandler.cfc:334)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
cfRequestHandler2ecfc1121342851$funcPROCESSEVENTS.runFunction(/var/www/html/supportCfusion/MachII/framework/RequestHandler.cfc:278)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
cfRequestHandler2ecfc1121342851$funcHANDLEREQUEST.runFunction(/var/www/html/supportCfusion/MachII/framework/RequestHandler.cfc:208)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2428)
cfmach2dii2ecfc39383740$funcHANDLEREQUEST.runFunction(/var/www/html/supportCfusion/MachII/mach-ii.cfc:210)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2655)
cfmach2dii2ecfc39383740$funcONREQUESTSTART.runFunction(/var/www/html/supportCfusion/MachII/mach-ii.cfc:121)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:518)
coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:2620)
coldfusion.runtime.SuperScope.invoke(SuperScope.java:18)
coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2369)
cfApplication2ecfc929761844$funcONREQUESTSTART.runFunction(/var/www/html/i2report/Application.cfc:55)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:405)
coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:278)
coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:419)
coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
coldfusion.CfmServlet.service(CfmServlet.java:219)
coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
sun.reflect.GeneratedMethodAccessor89.invoke(null:???)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:97)
com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:472)
com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:312)
com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:192)
com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:507)
com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
sun.reflect.GeneratedMethodAccessor88.invoke(null:???)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:79)
sun.reflect.GeneratedMethodAccessor87.invoke(null:???)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:53)
com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:???)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:199)
org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314)
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
java.lang.Thread.run(Thread.java:662)

Views

1.3K

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation
Resources
Documentation
ColdFusion User Guide
Copyright © 2023 Adobe. All rights reserved.
Using the Community Experience League Terms of Use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices