Problem while compiling jrxml file having MySQL procedure with parameters?

0

Hi friends,

       My procedure is

                          CALL GET_LOST_PROPERTY_Info_DETAILS1($P{PropertyRegNo},$P{LangCd})

      My database is MySQL.

     I am unable to compile my jrxml file.

     I am using SQL query language and parameters types are BIGINT and INT in database.

    I am new to use procedures in iReport.

Please let me know the steps to get result of procedure in a report.

Exception is as fallows in IReport.

java.lang.ArrayIndexOutOfBoundsException: -1
 at java.util.Vector.elementAt(Vector.java:430)
 at javax.swing.JTabbedPane.getTitleAt(JTabbedPane.java:1091)
 at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.updateHtmlViews(BasicTabbedPaneUI.java:3564)
 at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.componentAdded(BasicTabbedPaneUI.java:3699)
 at java.awt.Container.processContainerEvent(Container.java:2067)
 at java.awt.Container.processEvent(Container.java:2038)
 at java.awt.Component.dispatchEventImpl(Component.java:4630)
 at java.awt.Container.dispatchEventImpl(Container.java:2099)
 at java.awt.Component.dispatchEvent(Component.java:4460)
 at java.awt.Container.addImpl(Container.java:1085)
 at javax.swing.JTabbedPane.insertTab(JTabbedPane.java:703)
 at javax.swing.JTabbedPane.addTab(JTabbedPane.java:777)
 at javax.swing.JTabbedPane.add(JTabbedPane.java:814)
 at com.jaspersoft.ireport.designer.logpane.IRConsoleTopComponent.updateLogTabs(IRConsoleTopComponent.java:87)
 at com.jaspersoft.ireport.designer.logpane.IRConsoleTopComponent.createNewLog(IRConsoleTopComponent.java:202)
 at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:237)
 at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)
[catch] at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

 

 

javianjava's picture
Joined: Sep 28 2013 - 12:12am
Last seen: 5 years 4 months ago

2 Answers:

0
are you using java code to compile jrxml file ?
netti royala's picture
Joined: Oct 28 2013 - 11:43pm
Last seen: 4 years 6 months ago
0
I changed bigint to varchar.it is working fine, in my procedure.
javianjava's picture
Joined: Sep 28 2013 - 12:12am
Last seen: 5 years 4 months ago
Feedback