发新话题
打印

简表的JDBC数据源能不能调用存储过程

简表的JDBC数据源能不能调用存储过程

最近有个项目中的报表模块中,数据的查询是用的存储过程,我把存储过程的语句:call proc_xx 放到简表的数据源中报错,请问管理员,简表中支不支持存储过程的调用,支持的话,怎么调用?

TOP

管理员同志,你回复下撒!!!可行的话,我们可以买你们的产品的嘛

TOP

本产品是免费产品,不需要购买。
可以调用的存储过程,你在jdbc程序中,如何调用,就在sql查询编辑框中,写这个调用。跟jdbc调用完全一致!

TOP

我的过程返回的是一个集合
调用方式:CALL proc_getCigBrandStats('2014-08-19')
报错信息:
sql 出错.Parameter number 1 is not an OUT parameter

java.sql.SQLException: Parameter number 1 is not an OUT parameter
        at com.mysql.jdbc.CallableStatement.checkIsOutputParam(CallableStatement.java:416)
        at com.mysql.jdbc.CallableStatement.registerOutParameter(CallableStatement.java:1448)
        at jatools.data.reader.sql.OtherStoredProcResultsFactory.createResultSet(OtherStoredProcResultsFactory.java:27)
        at jatools.data.reader.sql.SqlReader.readStart(SqlReader.java:248)
        at jatools.designer.data.DatasetTable.setDataSet(DatasetTable.java:82)
        at jatools.designer.data.DatasetPreviewer$1.windowOpened(DatasetPreviewer.java:91)
        at java.awt.AWTEventMulticaster.windowOpened(AWTEventMulticaster.java:322)
        at java.awt.Window.processWindowEvent(Window.java:1824)
        at javax.swing.JDialog.processWindowEvent(JDialog.java:633)
        at java.awt.Window.processEvent(Window.java:1785)
        at java.awt.Component.dispatchEventImpl(Component.java:4413)
        at java.awt.Container.dispatchEventImpl(Container.java:2116)
        at java.awt.Window.dispatchEventImpl(Window.java:2440)
        at java.awt.Component.dispatchEvent(Component.java:4243)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at jatools.designer.data.DatasetPreviewer.show(DatasetPreviewer.java:211)
        at jatools.designer.SqlReaderDialog.preview(SqlReaderDialog.java:92)
        at jatools.designer.SqlReaderDialog.access$0(SqlReaderDialog.java:87)
        at jatools.designer.SqlReaderDialog$1.actionPerformed(SqlReaderDialog.java:143)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6041)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
        at java.awt.Component.processEvent(Component.java:5806)
        at java.awt.Container.processEvent(Container.java:2058)
        at java.awt.Component.dispatchEventImpl(Component.java:4413)
        at java.awt.Container.dispatchEventImpl(Container.java:2116)
        at java.awt.Component.dispatchEvent(Component.java:4243)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
        at java.awt.Container.dispatchEventImpl(Container.java:2102)
        at java.awt.Window.dispatchEventImpl(Window.java:2440)
        at java.awt.Component.dispatchEvent(Component.java:4243)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
        at java.awt.Dialog$1.run(Dialog.java:1045)
        at java.awt.Dialog$3.run(Dialog.java:1097)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.Dialog.show(Dialog.java:1095)
        at jatools.designer.data.jdbc.SqlReaderFactory.edit(SqlReaderFactory.java:60)
        at jatools.designer.variable.action.DataSourceAction.modifyAction(DataSourceAction.java:246)
        at jatools.designer.variable.action.DataSourceAction.actionPerformed(DataSourceAction.java:100)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
        at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1220)
        at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1261)
        at java.awt.Component.processMouseEvent(Component.java:6041)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
        at java.awt.Component.processEvent(Component.java:5806)
        at java.awt.Container.processEvent(Container.java:2058)
        at java.awt.Component.dispatchEventImpl(Component.java:4413)
        at java.awt.Container.dispatchEventImpl(Container.java:2116)
        at java.awt.Component.dispatchEvent(Component.java:4243)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
        at java.awt.Container.dispatchEventImpl(Container.java:2102)
        at java.awt.Window.dispatchEventImpl(Window.java:2440)
        at java.awt.Component.dispatchEvent(Component.java:4243)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:121)

TOP

请教管理员上面这个存储过程调用的问题

TOP

发新话题