Problem while compiling jrxml file having MySQL procedure with parameters?

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(
 at javax.swing.JTabbedPane.getTitleAt(
 at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.updateHtmlViews(
 at javax.swing.plaf.basic.BasicTabbedPaneUI$Handler.componentAdded(
 at java.awt.Container.processContainerEvent(
 at java.awt.Container.processEvent(
 at java.awt.Component.dispatchEventImpl(
 at java.awt.Container.dispatchEventImpl(
 at java.awt.Component.dispatchEvent(
 at java.awt.Container.addImpl(
 at javax.swing.JTabbedPane.insertTab(
 at javax.swing.JTabbedPane.addTab(
 at javax.swing.JTabbedPane.add(
 at com.jaspersoft.ireport.designer.logpane.IRConsoleTopComponent.updateLogTabs(
 at com.jaspersoft.ireport.designer.logpane.IRConsoleTopComponent.createNewLog(
 at org.openide.util.RequestProcessor$
[catch] at org.openide.util.RequestProcessor$



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

2 Answers:

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