Jump to content
Changes to the Jaspersoft community edition download ×

problem in stored procedure ?


jani99harsh

Recommended Posts

this stored procedure code work on mysql terminal but it does not work on jrxml file. it gives errorDELIMITER //DROP PROCEDURE IF EXISTS try//CREATE PROCEDURE try()BEGINdeclare s_query varchar(255);    declare done bool default false;    declare c_queries cursor for           SELECT `Demo`.`Qcol` FROM ``.`QC`;    declare continue handler for not found set done = true;    open c_queries;    read_loop: loop        fetch c_queries into s_query;        if done then            leave read_loop;        end if;        -- run the query        set @sql = s_query;        prepare stmt from  @sql;        execute stmt;        deallocate prepare stmt;    end loop;END //DELIMITER ;CALL try();[/code]

this stored procedure code work on mysql terminal but it does not work on jrxml file. it gives error 

..insert your code here..net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: 123.    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.fillReport(ReportControler.java:548)    at com.jaspersoft.studio.editor.preview.view.control.ReportControler.access$20(ReportControler.java:523)    at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:404)    at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: 123.    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:344)    at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1245)    at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:723)    at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:438)    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:550)    at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:123)    at java.lang.Thread.run(Thread.java:745)Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER //DROP PROCEDURE IF EXISTS try//CREATE PROCEDURE try()BEGINdecla' at line 1    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)    at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)    at com.mysql.jdbc.Util.getInstance(Util.java:408)    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501)    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)    at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310)    ... 6 more[/code]

help me.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...