Issue about java report with oracle Stored Procedure
Re: Issue about java report with oracle Stored Procedure
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
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
Re: Issue about java report with oracle Stored Procedure
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
Re: Issue about java report with oracle Stored Procedure
Hello.
Here is sample, based on https://www.stimulsoft.com/en/samples/j ... e-database
Here is sample, based on https://www.stimulsoft.com/en/samples/j ... e-database
- Attachments
-
- StimulsoftOracleStoredProcedureSample.zip
- (2.51 MiB) Downloaded 379 times
Issue about java report with oracle Stored Procedure calling
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
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 (174.41 KiB) Viewed 8360 times
Re: Issue about java report with oracle Stored Procedure
Hello.
Can you send us full stack trace from Tomcat ?
Can you send us full stack trace from Tomcat ?
Re: Issue about java report with oracle Stored Procedure
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
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
Re: Issue about java report with oracle Stored Procedure
Hello.
Flash version not support refcursor, please use Web version as in example https://www.stimulsoft.com/en/samples/j ... e-database
Flash version not support refcursor, please use Web version as in example https://www.stimulsoft.com/en/samples/j ... e-database