Jaspersoft ETL

Hi, I've been with an error that I can not solve, I hope you can help me.

I am trying to execute the following routine in one ("tMySqlRow")

"SET @ID = (select min (ID) from execution
                       where PERIOD = concat (year (now ()), LPAD (month (now ()), 2, 0))
                           and IDINDICATOR = 1);
delete from execution
where id = @ID "

but I always get the following error:

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 'delete from ejecucion
where id = @ID' at line 4

any ideas? I do not know how to solve it.

ingcrengifo's picture
Joined: Mar 23 2018 - 6:28am
Last seen: 5 years 6 months ago

1 Answer:

can't have multiple commands in one sqlrow component by default. 


Try adding this in the component: 

Update Additional JDBC Parameters to include "allowMultiQueries=true".

jbridge's picture
Joined: Feb 4 2013 - 10:20am
Last seen: 5 years 6 months ago