Example of show report in java web project using oracle

Stimulsoft Reports.JAVA discussion
Post Reply
zzzz
Posts: 19
Joined: Thu Apr 09, 2015 3:30 am

Re: Example of show report in java web project using oracle

Post by zzzz »

Thanks,It works! but there have been a new problem.

Code: Select all

2015-4-10 15:08:08 com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet processing
严重: 
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at com.stimulsoft.webviewer.StiWebViewer.renderPageParameters(StiWebViewer.java:428)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:549)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:504)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.processing(StiWebViewerActionServlet.java:51)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.doPost(StiWebViewerActionServlet.java:43)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.EpointJWebFilter.doFilter(Unknown Source)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.base.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.__doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
Vadim_Matveev wrote:Hello.
You must change servlet mapping to:

Code: Select all

<servlet>
		<servlet-name>StimulsoftResource</servlet-name>
		<servlet-class>com.stimulsoft.web.servlet.StiWebResourceServlet</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>StimulsoftResource</servlet-name>
		<url-pattern>/stimulsoft_web_resource/*</url-pattern>
	</servlet-mapping>
zzzz wrote:when i used *-2014.3-trial.jar report looked like that Image
after i use *-2014.3.18-trial.jar(FXJAVA_2015.03.23_Trial folder) report looks like that,all button disabled. Image
Top
Vadim
Posts: 409
Joined: Tue Apr 23, 2013 11:23 am

Re: Example of show report in java web project using oracle

Post by Vadim »

Hello.
It seems that your report does not contains rendered pages, maybe you didn't render report before display in viewer. You should run render report:

Code: Select all

report.Render(false);
zzzz wrote:Thanks,It works! but there have been a new problem.

Code: Select all

2015-4-10 15:08:08 com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet processing
严重: 
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at com.stimulsoft.webviewer.StiWebViewer.renderPageParameters(StiWebViewer.java:428)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:549)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:504)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.processing(StiWebViewerActionServlet.java:51)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.doPost(StiWebViewerActionServlet.java:43)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.EpointJWebFilter.doFilter(Unknown Source)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.base.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.__doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
Top
zzzz
Posts: 19
Joined: Thu Apr 09, 2015 3:30 am

Re: Example of show report in java web project using oracle

Post by zzzz »

I want to pass a parameter named rowguid to my report for the query condition,what should i do. Best regards.
How can i add oracle connection in designer.

Code: Select all

<%
	        StiReport report = StiSerializeManager.deserializeReport(new File(
	                "D:/EpointJWeb8.0/EpointJWeb/WebContent/reports/abc_ora.mrt"));
	        report.Compile();
	        report.getDictionary().getVariables().get("RowGuid").setValue("123");
	        report.getVariables().put("RowGuid", "123");
	        pageContext.setAttribute("report", report);
	        
	%>
	<stiwebviewer:webviewer report="${report}" />

Code: Select all

2015-4-13 8:43:37 com.stimulsoft.web.servlet.StiWebResourceServlet processing
警告: Resource null not found
java.lang.NullPointerException
	at com.stimulsoft.web.servlet.StiWebResourceServlet.processing(StiWebResourceServlet.java:176)
	at com.stimulsoft.web.servlet.StiWebResourceServlet.doGet(StiWebResourceServlet.java:144)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:84)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.EpointJWebFilter.doFilter(Unknown Source)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.base.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.__doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:926)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:988)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
2015-4-13 8:43:37 com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet processing
严重: 
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at com.stimulsoft.webviewer.StiWebViewer.renderPageParameters(StiWebViewer.java:428)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:549)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:504)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.processing(StiWebViewerActionServlet.java:51)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.doPost(StiWebViewerActionServlet.java:43)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.EpointJWebFilter.doFilter(Unknown Source)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.base.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.__doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
Attachments
7M~RWC}SS`VC(2S1X]S[$[N.png
7M~RWC}SS`VC(2S1X]S[$[N.png (6.94 KiB) Viewed 5771 times
Top
Vadim
Posts: 409
Joined: Tue Apr 23, 2013 11:23 am

Re: Example of show report in java web project using oracle

Post by Vadim »

Hello.
You must use next code:

Code: Select all

StiReport report = StiSerializeManager.deserializeReport(new File( "D:/EpointJWeb8.0/EpointJWeb/WebContent/reports/abc_ora.mrt"));
report.getDictionary().getVariables().get("RowGuid").setValue("123");
report.getVariables().put("RowGuid", "123");
report.Render(false);
pageContext.setAttribute("report", report);
It seems that Oracle is disabled in your designer, try to enable it by setup attribute

Code: Select all

Designer.Database.AdapterOracle=True
As in \Samples\webfx\src\my\servlet\ApplicationInitializer.java
stiConfig.getProperties().setProperty("Engine.Type", "Java");
zzzz wrote:I want to pass a parameter named rowguid to my report for the query condition,what should i do. Best regards.
How can i add oracle connection in designer.

Code: Select all

<%
	        StiReport report = StiSerializeManager.deserializeReport(new File(
	                "D:/EpointJWeb8.0/EpointJWeb/WebContent/reports/abc_ora.mrt"));
	        report.Compile();
	        report.getDictionary().getVariables().get("RowGuid").setValue("123");
	        report.getVariables().put("RowGuid", "123");
	        pageContext.setAttribute("report", report);
	        
	%>
	<stiwebviewer:webviewer report="${report}" />

Code: Select all

2015-4-13 8:43:37 com.stimulsoft.web.servlet.StiWebResourceServlet processing
警告: Resource null not found
java.lang.NullPointerException
	at com.stimulsoft.web.servlet.StiWebResourceServlet.processing(StiWebResourceServlet.java:176)
	at com.stimulsoft.web.servlet.StiWebResourceServlet.doGet(StiWebResourceServlet.java:144)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:84)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.EpointJWebFilter.doFilter(Unknown Source)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.base.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.__doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:926)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:988)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
2015-4-13 8:43:37 com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet processing
严重: 
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at com.stimulsoft.webviewer.StiWebViewer.renderPageParameters(StiWebViewer.java:428)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:549)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:504)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.processing(StiWebViewerActionServlet.java:51)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.doPost(StiWebViewerActionServlet.java:43)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.EpointJWebFilter.doFilter(Unknown Source)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.base.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.__doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
Top
zzzz
Posts: 19
Joined: Thu Apr 09, 2015 3:30 am

Re: Example of show report in java web project using oracle

Post by zzzz »

Thanks,i've already seen the oracle connection,but when i add an oracle connection,there is a connection error you can see through the screenshot attachment,I'm sure the datebase is ok,is the connection string right.

When i use the next code,nothing show in the viewer and no error in console.

Code: Select all

	<%
	        StiReport report = StiSerializeManager.deserializeReport(new File(
	                "D:/EpointJWeb8.0/EpointJWeb/WebContent/reports/abc_ora.mrt"));
	        report.getDictionary().getVariables().get("RowGuid").setValue("123");
	        report.getVariables().put("RowGuid", "123");
	        report.Render(false);
	        pageContext.setAttribute("report", report);
	        
	%>
	<stiwebviewer:webviewer report="${report}" />
Vadim_Matveev wrote:Hello.
You must use next code:

Code: Select all

StiReport report = StiSerializeManager.deserializeReport(new File( "D:/EpointJWeb8.0/EpointJWeb/WebContent/reports/abc_ora.mrt"));
report.getDictionary().getVariables().get("RowGuid").setValue("123");
report.getVariables().put("RowGuid", "123");
report.Render(false);
pageContext.setAttribute("report", report);
It seems that Oracle is disabled in your designer, try to enable it by setup attribute

Code: Select all

Designer.Database.AdapterOracle=True
As in \Samples\webfx\src\my\servlet\ApplicationInitializer.java
stiConfig.getProperties().setProperty("Engine.Type", "Java");
zzzz wrote:I want to pass a parameter named rowguid to my report for the query condition,what should i do. Best regards.
How can i add oracle connection in designer.

Code: Select all

<%
	        StiReport report = StiSerializeManager.deserializeReport(new File(
	                "D:/EpointJWeb8.0/EpointJWeb/WebContent/reports/abc_ora.mrt"));
	        report.Compile();
	        report.getDictionary().getVariables().get("RowGuid").setValue("123");
	        report.getVariables().put("RowGuid", "123");
	        pageContext.setAttribute("report", report);
	        
	%>
	<stiwebviewer:webviewer report="${report}" />

Code: Select all

2015-4-13 8:43:37 com.stimulsoft.web.servlet.StiWebResourceServlet processing
警告: Resource null not found
java.lang.NullPointerException
	at com.stimulsoft.web.servlet.StiWebResourceServlet.processing(StiWebResourceServlet.java:176)
	at com.stimulsoft.web.servlet.StiWebResourceServlet.doGet(StiWebResourceServlet.java:144)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:735)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:84)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.EpointJWebFilter.doFilter(Unknown Source)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.base.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.__doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:926)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:988)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:635)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
2015-4-13 8:43:37 com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet processing
严重: 
java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
	at java.util.ArrayList.RangeCheck(ArrayList.java:547)
	at java.util.ArrayList.get(ArrayList.java:322)
	at com.stimulsoft.webviewer.StiWebViewer.renderPageParameters(StiWebViewer.java:428)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:549)
	at com.stimulsoft.webviewer.StiWebViewer.viewerEventResult(StiWebViewer.java:504)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.processing(StiWebViewerActionServlet.java:51)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.doPost(StiWebViewerActionServlet.java:43)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:669)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1336)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:60)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:46)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.a.doFilter(Unknown Source)
	at com.epoint.web.session.EpointJWebFilter.doFilter(Unknown Source)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at com.epoint.base.filter.EncodingFilter.doFilter(EncodingFilter.java:46)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1307)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:453)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:560)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231)
	at org.eclipse.jetty.server.handler.ContextHandler.__doHandle(ContextHandler.java:1072)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:382)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1006)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116)
	at org.eclipse.jetty.server.Server.handle(Server.java:365)
	at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:485)
	at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:937)
	at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:998)
	at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:856)
	at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235)
	at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:628)
	at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:52)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)
	at java.lang.Thread.run(Thread.java:662)
Attachments
UUSP`U0D@F])Y9)30FD6`{T.png
UUSP`U0D@F])Y9)30FD6`{T.png (19.18 KiB) Viewed 5756 times
Top
Vadim
Posts: 409
Joined: Tue Apr 23, 2013 11:23 am

Re: Example of show report in java web project using oracle

Post by Vadim »

Hello.
You should use connections string like: ulr=jdbc:mysql://localhost:3306/;user=root;password=terra2;database=sakila
zzzz wrote:Thanks,i've already seen the oracle connection,but when i add an oracle connection,there is a connection error you can see through the screenshot attachment,I'm sure the datebase is ok,is the connection string right.
Top
zzzz
Posts: 19
Joined: Thu Apr 09, 2015 3:30 am

Re: Example of show report in java web project using oracle

Post by zzzz »

Hello.
I have used your connection string.I tried both ulr and url,message as shown in attachment.Thank you for your patience to answer.
Vadim_Matveev wrote:Hello.
You should use connections string like: ulr=jdbc:mysql://localhost:3306/;user=root;password=terra2;database=sakila
zzzz wrote:Thanks,i've already seen the oracle connection,but when i add an oracle connection,there is a connection error you can see through the screenshot attachment,I'm sure the datebase is ok,is the connection string right.
Attachments
oracle message
oracle message
oracle.png (20.21 KiB) Viewed 5744 times
mysql message
mysql message
mysql.png (15.15 KiB) Viewed 5744 times
Top
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Example of show report in java web project using oracle

Post by HighAley »

Hello.

Unfortunately, due technical restrictions AIR Designer does not support Oracle connection.
It's possible to add this type of connection for further use in other our Deisngers or Viewers.
The AIR Designer support XML and MySQL data sources only.

Thank you.
Top
zzzz
Posts: 19
Joined: Thu Apr 09, 2015 3:30 am

Re: Example of show report in java web project using oracle

Post by zzzz »

Hello.
When I create a mysql connection, Error # 2031 appears,how it was?
Aleksey Andreyanov wrote:Hello.

Unfortunately, due technical restrictions AIR Designer does not support Oracle connection.
It's possible to add this type of connection for further use in other our Deisngers or Viewers.
The AIR Designer support XML and MySQL data sources only.

Thank you.
Top
Vadim
Posts: 409
Joined: Tue Apr 23, 2013 11:23 am

Re: Example of show report in java web project using oracle

Post by Vadim »

Hello.
Do you have Java error stack trace, plase send it to us.
zzzz wrote:Hello.
When I create a mysql connection, Error # 2031 appears,how it was?
Top
Post Reply

Return to “Stimulsoft Reports.JAVA”