Adobe Community : All Content - All Communities

[macromedia][Oracle JDBC Driver]Object has been closed message when calling oracle package with no parameters using cfstoredproc.

forums_noreply@adobe.com — Mon, 09 Jun 2014 17:50:52 GMT

I'm experiencing a Object has been closed message when calling an oracle package with no parameters using cfstoredproc.

I am running ColdFusion 11.

It looks like the issue is the way the call is made. It's doing a call to the package without creating () at the end of it.

spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> Connection[20].prepareCall(String sql)
spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> sql = {call PACK_UT_HOT_NEWS.USP_DEL_UT_HOT_NEWS}
spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> OK (CallableStatement[9])

spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> CallableStatement[9].setMaxFieldSize(int max)
spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> max = 64000
spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> OK

spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> CallableStatement[9].execute()
spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> java.sql.SQLException: [macromedia][Oracle JDBC Driver]Object has been closed. ErrorCode=0 SQLState=HY000
java.sql.SQLException: [macromedia][Oracle JDBC Driver]Object has been closed.
at macromedia.jdbc.oraclebase.ddcr.b(Unknown Source)
at macromedia.jdbc.oraclebase.ddcr.a(Unknown Source)
at macromedia.jdbc.oraclebase.ddcq.b(Unknown Source)
at macromedia.jdbc.oraclebase.ddcq.a(Unknown Source)
at macromedia.jdbc.oraclebase.ddd2.p(Unknown Source)
at macromedia.jdbc.oraclebase.ddd2.execute(Unknown Source)
at macromedia.jdbcspyoracle.SpyPreparedStatement.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
at coldfusion.sql.Executive.executeCall(Executive.java:1075)
at coldfusion.sql.Executive.executeCall(Executive.java:948)
at coldfusion.sql.Executive.executeCall(Executive.java:898)
at coldfusion.sql.SqlImpl.executeCall(SqlImpl.java:528)
at coldfusion.tagext.sql.StoredProcTag.executeQuery(StoredProcTag.java:340)
at coldfusion.tagext.sql.StoredProcTag.doEndTag(StoredProcTag.java:288)
at cfdebugOraProcCall2ecfm688480773.runPage(E:\inetpub\wwwroot\CR\debugOraProcCall.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:734)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:570)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:487)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:141)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:2 8)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:219)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42 )
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j ava:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:422)
at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:198)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.jav a:607)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)

spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> CallableStatement[9].close()
spy(ajp-bio-8014-exec-9)(2014/06/09 12:47:29.565)>> OK

Any workaround for this?

Unable to initalize a flash form. The mxml.cfswf file is returing a 404.

forums_noreply@adobe.com — Thu, 05 Jun 2014 18:03:25 GMT

I am running ColdFusion 11 on IIS 8.5 and attempting to display a simple flex form. It generates the infrastruction for the form in the browser. However, when it attempts to access the <unique number>.mxml.cfswf file I see a 404 in the IIS log.

Any help in troubleshooting this issue would be appreciated.

IIS 8.5 features needed for ColdFusion 11

forums_noreply@adobe.com — Mon, 19 May 2014 17:21:56 GMT

What are the required IIS 8.5 features need to run ColdFusion 11?

Would the following install the correct features? Should something be added or removed from this list?

add-windowsfeature Web-Server,Web-WebServer,Web-Common-Http,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsi ng,Web-Http-Errors,Web-App-Dev,Web-ISAPI-Ext,Web-ISAPI-Filter,Web-Health,Web-Http-Logging, Web-Request-Monitor,Web-Security,Web-Filtering,Web-Performance,Web-Stat-Compression,Web-Mg mt-Tools,Web-Mgmt-Console

Reader 10.1.9 does not recognize printer duplex defaults when printing from command line

forums_noreply@adobe.com — Mon, 12 May 2014 15:32:42 GMT

Adobe does not seem to recognize printer default settings when printing from the command line ie AcroRd32.exe /p /h <filename> or used the right click print menu.

If the pdf is open and then printed from reader it prints correctly.

Is there a known bug why reader is ignoring the printer defaults when a document is sent directory to the printer? Is there a known workaround for this issue?

Error could not access a java object field called allowAppDataInServContext after Applying Security

forums_noreply@adobe.com — Tue, 18 Dec 2012 21:43:11 GMT

After applying the security patch 12-26 I am getting the error "Could not access a java object field called allowAppDataInServContext". When I removed the update the error goes away. When I read the update it returns.

The error states it occurred in the following line: cfapplication name="somename" clientmanagement="No" sessionmanagement="Yes" setclientcookies="Yes"

Does ColdFusion : Security Bulletin APSB10-11 apply to MX 7.0.2

forums_noreply@adobe.com — Thu, 13 May 2010 17:46:24 GMT

I contacted adobe phone support and was directed to post my question to the forum because adobe doesn't provide phone support for server products.

So, Does ColdFusion : Security Bulletin APSB10-11 apply to MX 7.0.2?

In the Security Bulleting it reads like it does:

Summary

Important vulnerabilities have been identified in ColdFusion 8.0, 8.0.1, 9.0 and earlier versions for Windows, Macintosh and UNIX. The vulnerabilities could lead to cross-site scripting and information disclosure.

source: http://www.adobe.com/support/security/bulletins/apsb10-11.html

However, there are no solutions in the technote:

Issue

Note: This technote and the attachments have been updated on 05/13/2010. All ColdFusion users should review the technote again. An issue when this security fix was applied with Cumulative Hot Fix 4 for ColdFusion 8.0.1 has been identified and resolved. The issue was caused by a naming conflict.

ColdFusion 9.0, 8.0.1 and 8.0 are affected with the issue mentioned in the security bulletin APSB10-11. This technote provides fixes for the security issues along with the installation instructions.

source: http://kb2.adobe.com/cps/841/cpsid_84102.html

Additionally, does anyone know if Cold Fusion MX 7.0.2 is a supported product?

Thank you any help will be benifitial.