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