...
When you execute an SQL task that includes multiple SQL commands, the following error message (for example) may display:
| Panel |
|---|
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:
| Panel |
|---|
?allowMultiQueries=true |
The following example is a URL connection string for a MySQL Database Connection resource definition:
| Panel |
|---|
jdbc:mysql://localhost:3306/uc?allowMultiQueries=true |