Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

TAJDINMar 14 2015 — edited Mar 24 2015

Sir,

jasper test.gif

Me trying to run a jasper report in my adf application but getting the message

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

net.sf.jasperreports.engine.JRException: Error executing SQL statement for : empReport

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240)

at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1114)

at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691)

at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1314)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:931)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:873)

at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:87)

at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:457)

at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:864)

at view.JasperBean.runReport(JasperBean.java:90)

at view.JasperBean.runReportAction(JasperBean.java:39)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:606)

at com.sun.el.parser.AstValue.invoke(AstValue.java:254)

at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)

at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)

at org.apache.myfaces.trinidad.component.MethodExpressionMethodBinding.invoke(MethodExpressionMethodBinding.java:46)

at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)

at org.apache.myfaces.trinidad.component.UIXCommand.broadcast(UIXCommand.java:190)

at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)

at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._invokeApplication(LifecycleImpl.java:1074)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:402)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:225)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829)

at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1270)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:5070)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1677)

at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:141)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)

... 66 more

<Mar 14, 2015 1:13:20 PM PKT> <Error> <javax.enterprise.resource.webcontainer.jsf.application> <BEA-000000> <Error Rendering View[/Welcome]

java.lang.IllegalStateException: strict servlet API: cannot call getWriter() after getOutputStream()

at weblogic.servlet.internal.ServletResponseImpl.getWriter(ServletResponseImpl.java:334)

at javax.servlet.ServletResponseWrapper.getWriter(ServletResponseWrapper.java:148)

at com.sun.faces.context.ExternalContextImpl.getResponseOutputWriter(ExternalContextImpl.java:723)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

Truncated. see log file for complete stacktrace

>

<oracle.adf.controller> <AdfcExceptionHandler> <handleException> <NO_EXCEPTION_HANDLER>

java.lang.IllegalStateException: strict servlet API: cannot call getWriter() after getOutputStream()

at weblogic.servlet.internal.ServletResponseImpl.getWriter(ServletResponseImpl.java:334)

at javax.servlet.ServletResponseWrapper.getWriter(ServletResponseWrapper.java:148)

at com.sun.faces.context.ExternalContextImpl.getResponseOutputWriter(ExternalContextImpl.java:723)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at com.sun.faces.application.view.FaceletViewHandlingStrategy.createResponseWriter(FaceletViewHandlingStrategy.java:938)

at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:377)

at org.apache.myfaces.trinidad.view.ViewDeclarationLanguageWrapper.renderView(ViewDeclarationLanguageWrapper.java:101)

at org.apache.myfaces.trinidad.view.ViewDeclarationLanguageWrapper.renderView(ViewDeclarationLanguageWrapper.java:101)

at org.apache.myfaces.trinidadinternal.application.ViewDeclarationLanguageFactoryImpl$ChangeApplyingVDLWrapper.renderView(ViewDeclarationLanguageFactoryImpl.java:338)

at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:125)

at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:288)

at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:170)

at oracle.adfinternal.view.faces.lifecycle.ResponseRenderManager.runRenderView(ResponseRenderManager.java:52)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._renderResponse(LifecycleImpl.java:1095)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:389)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:255)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

<oracle.adf.view> <RichExceptionHandler> <_logUnhandledException> <ADF_FACES-60098:Faces lifecycle receives unhandled exceptions in phase RENDER_RESPONSE 6>

java.lang.IllegalStateException: strict servlet API: cannot call getWriter() after getOutputStream()

at weblogic.servlet.internal.ServletResponseImpl.getWriter(ServletResponseImpl.java:334)

at javax.servlet.ServletResponseWrapper.getWriter(ServletResponseWrapper.java:148)

at com.sun.faces.context.ExternalContextImpl.getResponseOutputWriter(ExternalContextImpl.java:723)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at com.sun.faces.application.view.FaceletViewHandlingStrategy.createResponseWriter(FaceletViewHandlingStrategy.java:938)

at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:377)

at org.apache.myfaces.trinidad.view.ViewDeclarationLanguageWrapper.renderView(ViewDeclarationLanguageWrapper.java:101)

at org.apache.myfaces.trinidad.view.ViewDeclarationLanguageWrapper.renderView(ViewDeclarationLanguageWrapper.java:101)

at org.apache.myfaces.trinidadinternal.application.ViewDeclarationLanguageFactoryImpl$ChangeApplyingVDLWrapper.renderView(ViewDeclarationLanguageFactoryImpl.java:338)

at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:125)

at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:288)

at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:170)

at oracle.adfinternal.view.faces.lifecycle.ResponseRenderManager.runRenderView(ResponseRenderManager.java:52)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._renderResponse(LifecycleImpl.java:1095)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:389)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:255)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

<Mar 14, 2015 1:13:20 PM PKT> <Error> <HTTP> <BEA-101020> <[ServletContext@285463113[app:JasperTest module:JasperTest-ViewController-context-root path:null spec-version:3.0]] Servlet failed with an Exception

java.lang.IllegalStateException: strict servlet API: cannot call getWriter() after getOutputStream()

at weblogic.servlet.internal.ServletResponseImpl.getWriter(ServletResponseImpl.java:334)

at javax.servlet.ServletResponseWrapper.getWriter(ServletResponseWrapper.java:148)

at com.sun.faces.context.ExternalContextImpl.getResponseOutputWriter(ExternalContextImpl.java:723)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

Truncated. see log file for complete stacktrace

>

<Mar 14, 2015 1:13:20 PM PKT> <Notice> <Diagnostics> <BEA-320068> <Watch "UncheckedException" in module "Module-FMWDFW" with severity "Notice" on server "DefaultServer" has triggered at Mar 14, 2015 1:13:20 PM PKT. Notification details:

WatchRuleType: Log

WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))

WatchData: DATE = Mar 14, 2015 1:13:20 PM PKT SERVER = DefaultServer MESSAGE = [ServletContext@285463113[app:JasperTest module:JasperTest-ViewController-context-root path:null spec-version:3.0]] Servlet failed with an Exception

java.lang.IllegalStateException: strict servlet API: cannot call getWriter() after getOutputStream()

at weblogic.servlet.internal.ServletResponseImpl.getWriter(ServletResponseImpl.java:334)

at javax.servlet.ServletResponseWrapper.getWriter(ServletResponseWrapper.java:148)

at com.sun.faces.context.ExternalContextImpl.getResponseOutputWriter(ExternalContextImpl.java:723)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at javax.faces.context.ExternalContextWrapper.getResponseOutputWriter(ExternalContextWrapper.java:669)

at com.sun.faces.application.view.FaceletViewHandlingStrategy.createResponseWriter(FaceletViewHandlingStrategy.java:938)

at com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:377)

at org.apache.myfaces.trinidad.view.ViewDeclarationLanguageWrapper.renderView(ViewDeclarationLanguageWrapper.java:101)

at org.apache.myfaces.trinidad.view.ViewDeclarationLanguageWrapper.renderView(ViewDeclarationLanguageWrapper.java:101)

at org.apache.myfaces.trinidadinternal.application.ViewDeclarationLanguageFactoryImpl$ChangeApplyingVDLWrapper.renderView(ViewDeclarationLanguageFactoryImpl.java:338)

at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:125)

at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:288)

at org.apache.myfaces.trinidadinternal.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:170)

at oracle.adfinternal.view.faces.lifecycle.ResponseRenderManager.runRenderView(ResponseRenderManager.java:52)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._renderResponse(LifecycleImpl.java:1095)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executePhase(LifecycleImpl.java:389)

at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:255)

at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:346)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:192)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.adfinternal.view.faces.webapp.rich.RegistrationFilter.doFilter(RegistrationFilter.java:105)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at oracle.adfinternal.view.faces.activedata.AdsFilter.doFilter(AdsFilter.java:60)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl$FilterListChain.doFilter(TrinidadFilterImpl.java:502)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl._doFilterImpl(TrinidadFilterImpl.java:327)

at org.apache.myfaces.trinidadinternal.webapp.TrinidadFilterImpl.doFilter(TrinidadFilterImpl.java:229)

at org.apache.myfaces.trinidad.webapp.TrinidadFilter.doFilter(TrinidadFilter.java:92)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:137)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:120)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:217)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:81)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:220)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:79)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3436)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3402)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)

at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2285)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2201)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1572)

at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:255)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:311)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:263)

SUBSYSTEM = HTTP USERID = <WLS Kernel> SEVERITY = Error THREAD = [ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)' MSGID = BEA-101020 MACHINE = TANVIR-PC TXID = CONTEXTID = 9e95b0a0-9417-4bdd-a665-16c85bcbc70c-00000094 TIMESTAMP = 1426320800208

WatchAlarmType: AutomaticReset

WatchAlarmResetPeriod: 30000

>

<oracle.dfw.impl.incident.DiagnosticsDataExtractorImpl> <DiagnosticsDataExtractorImpl> <createADRIncident> <incident 56 created with problem key "DFW-99998 [java.lang.IllegalStateException][oracle.adfinternal.view.faces.lifecycle.ResponseRenderManager.runRenderView][JasperTest]">

My code is

jsp page

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE html>

<f:view xmlns:f="http://java.sun.com/jsf/core" xmlns:af="http://xmlns.oracle.com/adf/faces/rich">

\<af:document title="Welcome.jsf" id="d1">

    \<af:messages id="m1"/>

    \<af:form id="f1">

        \<af:button text="Run Report" id="b1" partialSubmit="false" action="#{Jasper.runReportAction}"/>

        \<af:table value="#{bindings.EmpView1.collectionModel}" var="row" rows="#{bindings.EmpView1.rangeSize}"

                  emptyText="#{bindings.EmpView1.viewable ? 'No data to display.' : 'Access Denied.'}"

                  rowBandingInterval="0" selectedRowKeys="#{bindings.EmpView1.collectionModel.selectedRow}"

                  selectionListener="#{bindings.EmpView1.collectionModel.makeCurrent}" rowSelection="single"

                  fetchSize="#{bindings.EmpView1.rangeSize}" id="t1">

            \<af:column headerText="#{bindings.EmpView1.hints.EmpId.label}" id="c1">

                \<af:outputText value="#{row.EmpId}" shortDesc="#{bindings.EmpView1.hints.EmpId.tooltip}" id="ot1"/>

            \</af:column>

            \<af:column headerText="#{bindings.EmpView1.hints.PhoneNo.label}" id="c2">

                \<af:outputText value="#{row.PhoneNo}" shortDesc="#{bindings.EmpView1.hints.PhoneNo.tooltip}"

                               id="ot2"/>

            \</af:column>

            \<af:column headerText="#{bindings.EmpView1.hints.Desig.label}" id="c3">

                \<af:outputText value="#{row.Desig}" shortDesc="#{bindings.EmpView1.hints.Desig.tooltip}" id="ot3"/>

            \</af:column>

            \<af:column headerText="#{bindings.EmpView1.hints.LName.label}" id="c4">

                \<af:outputText value="#{row.LName}" shortDesc="#{bindings.EmpView1.hints.LName.tooltip}" id="ot4"/>

            \</af:column>

            \<af:column headerText="#{bindings.EmpView1.hints.MName.label}" id="c5">

                \<af:outputText value="#{row.MName}" shortDesc="#{bindings.EmpView1.hints.MName.tooltip}" id="ot5"/>

            \</af:column>

            \<af:column headerText="#{bindings.EmpView1.hints.FName.label}" id="c6">

                \<af:outputText value="#{row.FName}" shortDesc="#{bindings.EmpView1.hints.FName.tooltip}" id="ot6"/>

            \</af:column>

            \<af:column headerText="#{bindings.EmpView1.hints.BankAc.label}" id="c7">

                \<af:outputText value="#{row.BankAc}" shortDesc="#{bindings.EmpView1.hints.BankAc.tooltip}"

                               id="ot7"/>

            \</af:column>

        \</af:table>

    \</af:form>

\</af:document>

\<!--oracle-jdev-comment:preferred-managed-bean-name:Jasper-->

</f:view>

report code

<?xml version="1.0" encoding="UTF-8"?>

<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="empReport" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="b049c1d2-c175-4a8b-b9af-65bcdc99a573">

<property name="ireport.zoom" value="1.0"/>

<property name="ireport.x" value="0"/>

<property name="ireport.y" value="0"/>

<queryString>

<![CDATA[SELECT

 \*

FROM

 "SCHOOL"."EMP" EMP\]\]>

</queryString>

<field name="EMP_ID" class="java.lang.String"/>

<field name="PHONE_NO" class="java.lang.String"/>

<field name="DESIG" class="java.lang.String"/>

<field name="L_NAME" class="java.lang.String"/>

<field name="M_NAME" class="java.lang.String"/>

<field name="F_NAME" class="java.lang.String"/>

<field name="BANK_AC" class="java.lang.String"/>

<background>

<band splitType="Stretch"/>

</background>

<title>

<band height="79" splitType="Stretch"/>

</title>

<pageHeader>

<band height="35" splitType="Stretch"/>

</pageHeader>

<columnHeader>

<band height="61" splitType="Stretch">

<staticText>

<reportElement x="218" y="2" width="100" height="20" uuid="da36d8a4-5af2-40f1-9c0e-06970db5131d"/>

<text><![CDATA[EMP_ID]]></text>

</staticText>

</band>

</columnHeader>

<detail>

<band height="125" splitType="Stretch">

<textField>

<reportElement x="218" y="36" width="100" height="20" uuid="0c47bb5c-e96f-4544-8686-8e19f677cee6"/>

<textFieldExpression><![CDATA[$F{EMP_ID}]]></textFieldExpression>

</textField>

</band>

</detail>

<columnFooter>

<band height="45" splitType="Stretch"/>

</columnFooter>

<pageFooter>

<band height="54" splitType="Stretch"/>

</pageFooter>

<summary>

<band height="42" splitType="Stretch"/>

</summary>

</jasperReport>

bean code is

package view;

import java.io.ByteArrayOutputStream;

import java.io.InputStream;

import java.sql.Connection;

import java.util.HashMap;

import java.util.Map;

import javax.faces.context.FacesContext;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.servlet.ServletContext;

import javax.servlet.ServletOutputStream;

import javax.servlet.http.HttpServletResponse;

import javax.sql.DataSource;

import net.sf.jasperreports.engine.JasperExportManager;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.engine.JasperReport;

import net.sf.jasperreports.engine.type.WhenNoDataTypeEnum;

import net.sf.jasperreports.engine.util.JRLoader;

import oracle.adf.model.BindingContext;

import oracle.adf.model.binding.DCIteratorBinding;

import oracle.binding.BindingContainer;

public class JasperBean {

public JasperBean() {

}

public String runReportAction() {

    // Add event code here...

    DCIteratorBinding empIter = (DCIteratorBinding) getBindings().get("EmpView1Iterator");

                String empId = empIter.getCurrentRow().getAttribute("EmpId").toString();

                Map m = new HashMap();

                m.put("employeeId", empId);

                try

                {

                  runReport("empReport.jasper", null);

                }

                catch (Exception e)

                {

                }

    return null;

}

public BindingContainer getBindings()

     {

       return BindingContext.getCurrent().getCurrentBindingsEntry();

     }

     public Connection getDataSourceConnection(String dataSourceName)

         throws Exception

       {

         Context ctx = new InitialContext();

         DataSource ds = (DataSource)ctx.lookup(dataSourceName);

         return ds.getConnection();

       }

     private Connection getConnection() throws Exception

     {

       return getDataSourceConnection("hrDS");

     }

     public  ServletContext getContext()

       {

         return (ServletContext)getFacesContext().getExternalContext().getContext();

       }

     public  HttpServletResponse getResponse()

       {

         return (HttpServletResponse)getFacesContext().getExternalContext().getResponse();

       }

     public static FacesContext getFacesContext()

       {

         return FacesContext.getCurrentInstance();

       }

     public void runReport(String repPath, java.util.Map param) throws Exception

     {

       Connection conn = null;

       try

       {

         HttpServletResponse response = getResponse();

         ServletOutputStream out = response.getOutputStream();

         response.setHeader("Cache-Control", "max-age=0");

         response.setContentType("application/pdf");

         ServletContext context = getContext();

         InputStream fs = context.getResourceAsStream("/reports/" + repPath);

         JasperReport template = (JasperReport) JRLoader.loadObject(fs);

         template.setWhenNoDataType(WhenNoDataTypeEnum.ALL\_SECTIONS\_NO\_DETAIL);

         conn = getConnection();

         JasperPrint print = JasperFillManager.fillReport(template, param, conn);

         ByteArrayOutputStream baos = new ByteArrayOutputStream();

         JasperExportManager.exportReportToPdfStream(print, baos);

         out.write(baos.toByteArray());

         out.flush();

         out.close();

         FacesContext.getCurrentInstance().responseComplete();

       }

       catch (Exception jex)

       {

         jex.printStackTrace();

       }

       finally

       {    

         close(conn);

       }

     }

     public void close(Connection con)

      {

        if (con != null)

        {

          try

          {

            con.close();

          }

          catch (Exception e)

          {

          }

        }

      }

}

Regards

This post has been answered by TAJDIN on Mar 24 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2015
Added on Mar 14 2015
5 comments
1,288 views