Problem
When you execute an SQL task that includes multiple SQL commands, the following error message (for example) may display:
INSERT INTO uc_demo (name, value) values ('A', 'F');
INSERT INTO uc_demo (name, value) values ('B', 'S');
INSERT INTO uc_demo (name, value) values ('C', 'F');
Solution
Multiple queries, by default, are disabled for MySQL. To enable multiple queries, append the following string to the Connection URL field in the Database Connections resource definition:
?allowMultiQueries=true
The following example is a URL connection string for a MySQL Database Connection resource definition:
jdbc:mysql://localhost:3306/uc?allowMultiQueries=true