Issue about java report with oracle Stored Procedure

Stimulsoft Reports.JAVA discussion
Jia Sheng
Posts: 49
Joined: Thu Jul 04, 2013 7:59 am

Re: Issue about java report with oracle Stored Procedure

Post by Jia Sheng »

Hello.

Attach an attachment(screenshot from your example:https://www.stimulsoft.com/en/samples/j ... e-database):
000000.png
000000.png (65.96 KiB) Viewed 10202 times

We need a java demo project(use stiwebviewer), Include a mrt file using oracle Stored Procedure
Thanks
HighAley
Posts: 8430
Joined: Wed Jun 08, 2011 7:40 am
Location: Stimulsoft Office

Re: Issue about java report with oracle Stored Procedure

Post by HighAley »

Hello.

You could find a sample on the GitHub.

Thank you.
Jia Sheng
Posts: 49
Joined: Thu Jul 04, 2013 7:59 am

Re: Issue about java report with oracle Stored Procedure

Post by Jia Sheng »

HighAley wrote:Hello.

You could find a sample on the GitHub.

Thank you.
Hello.

Although the example says oracle connection, but the code shows the mysql connection.
000000.png
000000.png (119.56 KiB) Viewed 10176 times


And what we want is an example of the oracle stored procedure (including the mrt report file).

Thank you
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: Issue about java report with oracle Stored Procedure

Post by Vadim »

Attachments
StimulsoftOracleStoredProcedureSample.zip
(2.51 MiB) Downloaded 352 times
MGS2516
Posts: 10
Joined: Fri Nov 08, 2019 11:04 am

Issue about java report with oracle Stored Procedure calling

Post by MGS2516 »

Hello,

While calling procedure through stimulsoft report.fx for java with refcursor i''m facing missing expression throwing.

kindly help on this.
for your reference below i'm attaching the image also
Attachments
Screenshot_Procedure.png
Screenshot_Procedure.png (174.41 KiB) Viewed 7831 times
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: Issue about java report with oracle Stored Procedure

Post by Vadim »

Hello.
Can you send us full stack trace from Tomcat ?
MGS2516
Posts: 10
Joined: Fri Nov 08, 2019 11:04 am

Re: Issue about java report with oracle Stored Procedure

Post by MGS2516 »

Hi,

Thanks for the kind reply,below stack trace i'm getting from tomcat.

kindly do the needful asap.

must override this method to specify your own Localizations
must override this method to specify your own LocalizationDir
must override this method to specify your own load repotr
::::::::::::::::::::::::: ___/home/yoga/Desktop/Gopi/21102019/dsfsdfsdfsdfs/Samples-Java-master/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/webfx/reports/TransactionReport.mrt
Nov 19, 2019 5:53:07 PM com.stimulsoft.flex.utils.StiSaveLoadFileReport getReport
INFO: Load file report '/home/yoga/Desktop/Gopi/21102019/dsfsdfsdfsdfs/Samples-Java-master/.metadata/.plugins/org.eclipse.wst.server.core/tmp0/wtpwebapps/webfx/reports/TransactionReport.mrt'
must override this method to specify your own connection
com.stimulsoft.base.exception.StiException: com.stimulsoft.base.exception.StiException: java.sql.SQLException: ORA-00936: missing expression

at com.stimulsoft.flex.events.StiReturnColumns.processLoadData(StiReturnColumns.java:87)
at com.stimulsoft.flex.events.StiReturnColumns.process(StiReturnColumns.java:52)
at com.stimulsoft.web.events.StiAbstractAction.run(StiAbstractAction.java:19)
at com.stimulsoft.web.servlet.StiServlet.runAction(StiServlet.java:23)
at com.stimulsoft.web.servlet.StiDesignerFxServlet.processingParam(StiDesignerFxServlet.java:68)
at com.stimulsoft.web.servlet.StiDesignerFxServlet.processing(StiDesignerFxServlet.java:48)
at com.stimulsoft.web.servlet.StiDesignerFxServlet.doPost(StiDesignerFxServlet.java:36)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.stimulsoft.base.exception.StiException: java.sql.SQLException: ORA-00936: missing expression

at com.stimulsoft.report.utils.data.StiDataColumnsUtil.getFields(StiDataColumnsUtil.java:256)
at com.stimulsoft.flex.StiLoadDataAction.getSqlFields(StiLoadDataAction.java:106)
at com.stimulsoft.flex.events.StiReturnColumns.processLoadData(StiReturnColumns.java:84)
... 27 more
Caused by: java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1264)
at com.stimulsoft.report.utils.data.StiDataColumnsUtil.getFields(StiDataColumnsUtil.java:249)
... 29 more
Nov 19, 2019 6:16:31 PM com.stimulsoft.web.servlet.StiServlet error
SEVERE: Error
com.stimulsoft.base.exception.StiException: com.stimulsoft.base.exception.StiException: java.sql.SQLException: ORA-00936: missing expression

at com.stimulsoft.flex.events.StiReturnColumns.processLoadData(StiReturnColumns.java:87)
at com.stimulsoft.flex.events.StiReturnColumns.process(StiReturnColumns.java:52)
at com.stimulsoft.web.events.StiAbstractAction.run(StiAbstractAction.java:19)
at com.stimulsoft.web.servlet.StiServlet.runAction(StiServlet.java:23)
at com.stimulsoft.web.servlet.StiDesignerFxServlet.processingParam(StiDesignerFxServlet.java:68)
at com.stimulsoft.web.servlet.StiDesignerFxServlet.processing(StiDesignerFxServlet.java:48)
at com.stimulsoft.web.servlet.StiDesignerFxServlet.doPost(StiDesignerFxServlet.java:36)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:603)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.stimulsoft.base.exception.StiException: java.sql.SQLException: ORA-00936: missing expression

at com.stimulsoft.report.utils.data.StiDataColumnsUtil.getFields(StiDataColumnsUtil.java:256)
at com.stimulsoft.flex.StiLoadDataAction.getSqlFields(StiLoadDataAction.java:106)
at com.stimulsoft.flex.events.StiReturnColumns.processLoadData(StiReturnColumns.java:84)
... 27 more
Caused by: java.sql.SQLException: ORA-00936: missing expression

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1264)
at com.stimulsoft.report.utils.data.StiDataColumnsUtil.getFields(StiDataColumnsUtil.java:249)
... 29 more
Vadim
Posts: 362
Joined: Tue Apr 23, 2013 11:23 am

Re: Issue about java report with oracle Stored Procedure

Post by Vadim »

Hello.
Flash version not support refcursor, please use Web version as in example https://www.stimulsoft.com/en/samples/j ... e-database
Post Reply