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