Skip to main content
Participant
September 11, 2008
Answered

Error Executing Database Query, Network problem

  • September 11, 2008
  • 2 replies
  • 4433 views
I am getting the following error when trying to run an Oracle stored procedure that returns a ref cursor using CF MX 7.0.2.142559:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed.

I am connecting to the database through an ODBC Socket DSN. The CF DSN was created without error. I have verified that the ODBC DSN is connecting without error.

I am getting the following in the application log:
"Error","jrpp-0","09/11/08","11:25:31","Surplus","Error Executing Database Query.[Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed. The specific sequence of files included or processed is: C:\Inetpub\wwwroot\assocproducts\ken.cfm, line: 14 "

I am getting the following in the exception log:
"Error","jrpp-0","09/11/08","11:25:31","Surplus","Error Executing Database Query.[Macromedia][SequeLink JDBC Driver]Network problem, session aborted due to internal error in remote procedure call, connection closed. The specific sequence of files included or processed is: C:\Inetpub\wwwroot\assocproducts\ken.cfm, line: 14 "
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:201)
at cfCategory_Procs2ecfc417114750$funcGETCATEGORYLIST.runFunction(C:\Inetpub\wwwroot\assocproducts\includes\Category_Procs.cfc:14)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)
at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:290)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169)
at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:1807)
at cfken2ecfm1820770350.runPage(C:\Inetpub\wwwroot\assocproducts\ken.cfm:14)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:225)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:27)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

I can't find anything on the net that helps me resolve this. I tried using the Oracle JDBC driver as well, but got cryptic errors with that as well.

Any help on this greatly appreciated.

Thanks!
Ken
This topic has been closed for replies.
Correct answer KenJohnson
I found the solution to my problem. I updated my JDBC drivers ( new drivers) and used the dedicated Oracle CF DSN and everything is working fine.

2 replies

Participating Frequently
October 22, 2008
Congratulations, i'm really impressed. Great job!
Participating Frequently
September 11, 2008
You can't access ref cursor result sets using the Oracle Thin Client which would explain the Oracle JDBC problem. Which ODBC driver did you use? Microsoft or Oracle? Back when I used Oracle 8 and ColdFusion 4.5, the Microsoft ODBC would not work with returning results sets with ref cursors, but the Oracle ODBC from worked fine. I haven't used ODBC since CF 4.5 so I'm not sure if this is still correct, but you might consider downloading the Oracle ODBC from Oracle ODBC Driver

Phil
Participant
September 11, 2008
Hi Phil -

Thanks for the quick response. I was originally using the Microsoft Oracle ODBC driver (2.576.3959.00). I pointed my CF DSN to a newly created ODBC DSN using the Oracle ODBC driver (10.02.00.03).

I am still getting the same error.

Are there any other connection options that I can use to connect to my Oracle 10g database?

Thanks!
Ken
KenJohnsonAuthorCorrect answer
Participant
September 11, 2008
I found the solution to my problem. I updated my JDBC drivers ( new drivers) and used the dedicated Oracle CF DSN and everything is working fine.