You can’t have multiple statements in a single query due to the JDBC driver. Either use a stored procedure in your database and call it from Ignition, or separate these into separate named queries
Just wan't to point out that you don't need a transaction in order to run an insert into multiple tables. That isn't what a transaction is for. That doesn't mean its a bad idea or that you shouldn't use it here. Just that wrapping it in a transaction wasn't going to make this a single operation.
Also, either you didn't include the entirety of you SQL or your syntax isn't correct because, just using a BEGIN - END doesn't create a transaction you would need BEGIN TRANSACTION
Also, perhaps you haven't made it that far yet, but why use a Transaction if you have no mechanism for deciding to either COMMIT or ROLLBACK?