Creating reports and dashboards | Stimulsoft community forum

Reporting tool and data analytics tools for creating reports and dashboards in ASP.NET, ASP.NET MVC, .NET Core, Blazor, Angular, PHP, Python, WPF, JavaScript, and Java applications.
https://forum.stimulsoft.com/

Example of show report in java web project using oracle

https://forum.stimulsoft.com/viewtopic.php?t=40003

Page 2 of 3

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

Posted: Fri Apr 10, 2015 7:12 am
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

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

Posted: Fri Apr 10, 2015 10:14 am
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)

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

Posted: Sun Apr 12, 2015 11:30 am
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)

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

Posted: Mon Apr 13, 2015 11:05 am
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)

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

Posted: Tue Apr 14, 2015 1:07 am
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)

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

Posted: Tue Apr 14, 2015 10:54 am
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.

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

Posted: Wed Apr 15, 2015 1:33 am
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.

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

Posted: Wed Apr 15, 2015 5:49 am
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.

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

Posted: Wed Apr 15, 2015 5:55 am
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.

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

Posted: Wed Apr 15, 2015 6:01 am
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?
All times are UTC
Page 2 of 3

Powered by phpBB® Forum Software © phpBB Limited