Stimulsoft Business Intelligence System | Forum

Hello.

Attach an attachment(screenshot from your example:https://www.stimulsoft.com/en/samples/j ... e-database):
We need a java demo project(use stiwebviewer), Include a mrt file using oracle Stored Procedure
Thanks

Hello.

You could find a sample on the GitHub.

Thank you.

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.

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

Thank you

Hello.
Here is sample, based on https://www.stimulsoft.com/en/samples/j ... e-database

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

Hello.
Can you send us full stack trace from Tomcat ?

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

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