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

Example of show report in java web project using oracle

Post by zzzz »

I havent found the type of oracle connection,how can i add an oracle connect in designer.After i get the report files(*.mrt),how can i show it in my project.Can you give me an example.
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 »

Code: Select all

2015-4-9 13:57:10 com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet processing
严重: 
java.lang.NullPointerException
	at com.stimulsoft.webviewer.helper.StiParametersClass.getVariables(StiParametersClass.java:489)
	at com.stimulsoft.webviewer.StiWebViewer.interactionResult(StiWebViewer.java:792)
	at com.stimulsoft.webviewer.StiWebViewer.interactionResult(StiWebViewer.java:766)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.processing(StiWebViewerActionServlet.java:54)
	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
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 can find samples web projects in \Samples\ forlder.
Also you can look at videos:
https://www.youtube.com/watch?v=y09g-BLN_nw
https://www.youtube.com/watch?v=dMm4i1YtbFg
https://www.youtube.com/watch?v=pKHK31MRQu8
zzzz wrote:I havent found the type of oracle connection,how can i add an oracle connect in designer.After i get the report files(*.mrt),how can i show it in my project.Can you give me an example.
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.
Plase use last product version.
zzzz wrote:

Code: Select all

2015-4-9 13:57:10 com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet processing
严重: 
java.lang.NullPointerException
	at com.stimulsoft.webviewer.helper.StiParametersClass.getVariables(StiParametersClass.java:489)
	at com.stimulsoft.webviewer.StiWebViewer.interactionResult(StiWebViewer.java:792)
	at com.stimulsoft.webviewer.StiWebViewer.interactionResult(StiWebViewer.java:766)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.processing(StiWebViewerActionServlet.java:54)
	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 »

hello,can you help me deal with this exception,i don't know what make it happend.This connectionString used in .net,not work in java.

Code: Select all

com.stimulsoft.base.exception.StiException: StiJDBCDatabase [connectionString=Data Source=orcl_192.168.200.129;Persist Security Info=True;User ID=EpointBid_TP;Password=oracletp6;, promptUserNameAndPassword=false, url=jdbc:oracle:thin:@localhost:1521:orcl_192.168.200.129, user=EpointBid_TP, password=oracletp6, driver=oracle.jdbc.OracleDriver, other={Persist Security Info=True}]
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.
Plase send full stack trace (with lines below)
zzzz wrote:hello,can you help me deal with this exception,i don't know what make it happend.This connectionString used in .net,not work in java.

Code: Select all

com.stimulsoft.base.exception.StiException: StiJDBCDatabase [connectionString=Data Source=orcl_192.168.200.129;Persist Security Info=True;User ID=EpointBid_TP;Password=oracletp6;, promptUserNameAndPassword=false, url=jdbc:oracle:thin:@localhost:1521:orcl_192.168.200.129, user=EpointBid_TP, password=oracletp6, driver=oracle.jdbc.OracleDriver, other={Persist Security Info=True}]
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 »

only this message

Code: Select all

com.stimulsoft.base.exception.StiException: StiJDBCDatabase [connectionString=Data Source=orcl_192.168.200.129;Persist Security Info=True;User ID=EpointBid_TP;Password=oracletp6;, promptUserNameAndPassword=false, url=jdbc:oracle:thin:@localhost:1521:orcl_192.168.200.129, user=EpointBid_TP, password=oracletp6, driver=oracle.jdbc.OracleDriver, other={Persist Security Info=True}]
Vadim_Matveev wrote:Hello.
Plase send full stack trace (with lines below)
zzzz wrote:hello,can you help me deal with this exception,i don't know what make it happend.This connectionString used in .net,not work in java.

Code: Select all

com.stimulsoft.base.exception.StiException: StiJDBCDatabase [connectionString=Data Source=orcl_192.168.200.129;Persist Security Info=True;User ID=EpointBid_TP;Password=oracletp6;, promptUserNameAndPassword=false, url=jdbc:oracle:thin:@localhost:1521:orcl_192.168.200.129, user=EpointBid_TP, password=oracletp6, driver=oracle.jdbc.OracleDriver, other={Persist Security Info=True}]
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.
Unfortunately with so low information we can't analyze your problem.
zzzz wrote:only this message

Code: Select all

com.stimulsoft.base.exception.StiException: StiJDBCDatabase [connectionString=Data Source=orcl_192.168.200.129;Persist Security Info=True;User ID=EpointBid_TP;Password=oracletp6;, promptUserNameAndPassword=false, url=jdbc:oracle:thin:@localhost:1521:orcl_192.168.200.129, user=EpointBid_TP, password=oracletp6, driver=oracle.jdbc.OracleDriver, other={Persist Security Info=True}]
Vadim_Matveev wrote:Hello.
Plase send full stack trace (with lines below)
zzzz wrote:hello,can you help me deal with this exception,i don't know what make it happend.This connectionString used in .net,not work in java.

Code: Select all

com.stimulsoft.base.exception.StiException: StiJDBCDatabase [connectionString=Data Source=orcl_192.168.200.129;Persist Security Info=True;User ID=EpointBid_TP;Password=oracletp6;, promptUserNameAndPassword=false, url=jdbc:oracle:thin:@localhost:1521:orcl_192.168.200.129, user=EpointBid_TP, password=oracletp6, driver=oracle.jdbc.OracleDriver, other={Persist Security Info=True}]
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 »

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
Even ChartAreas.mrt in Reports folder can not show.
here is my code,it worded in *-2014.3-trial.jar ChartAreas.mrt.

Code: Select all

<body>
	<h1 align="center">report</h1>
	<%
	        StiReport report = StiSerializeManager.deserializeReport(new File(
	                "D:/EpointJWeb8.0/EpointJWeb/WebContent/reports/aa_ora.mrt"));
	        //report.getVariables().put("RowGuid", "var1");
	        report.Render(false);
	        pageContext.setAttribute("report", report); 
	%>
	<stiwebviewer:webviewer report="${report}" />
</body>
Vadim_Matveev wrote:Hello.
Plase use last product version.
zzzz wrote:

Code: Select all

2015-4-9 13:57:10 com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet processing
严重: 
java.lang.NullPointerException
	at com.stimulsoft.webviewer.helper.StiParametersClass.getVariables(StiParametersClass.java:489)
	at com.stimulsoft.webviewer.StiWebViewer.interactionResult(StiWebViewer.java:792)
	at com.stimulsoft.webviewer.StiWebViewer.interactionResult(StiWebViewer.java:766)
	at com.stimulsoft.webviewer.servlet.StiWebViewerActionServlet.processing(StiWebViewerActionServlet.java:54)
	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
ph.png
ph.png (4.31 KiB) Viewed 7985 times
XD]XBZ)F~58MLGHNZXOEU)G.png
XD]XBZ)F~58MLGHNZXOEU)G.png (5.74 KiB) Viewed 7985 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 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
Post Reply

Return to “Stimulsoft Reports.JAVA”