JDBC Step in Flow Designer displays error "Given SQL statement is not SINGLE SQL statement" Issue The flow will return an error message "Given SQL statement is not SINGLE SQL statement" when a SQL query with a semicolon (;) is used in between the values in the JDBC configuration of a JDBC step however the same SQL statement in the database editor works well. - For example, using a SQL query like the one below ( there is no; in-between) in the JDBC step will work as expected INSERT into tb_wires_log(wire_type,reason) VALUES('Fed Wire','home purchase') - However, if the above query is replaced like the below SQL query ( with a semicolon; in between the values of a string), it will return an error "Given SQL statement is not SINGLE SQL statement".Refer to the Error Message section in the below flow execution details. INSERT into tb_wires_log(wire_type,reason) VALUES('Fed Wire','home; purchase')Resolution- Add the MID server property "mid.property.validate_single_statement_jdbc" with the value 'true', keeping the MID server field value as NULL in the property ( so that the changes are applicable for all the active MID servers) and restarting the MID server should resolve the issue of executing SQL query with a semicolon used in between the values of strings via the JDBC rest step, as it should allow ";" inside quotes. - To add a new property in the MID Server Property [ecc_agent_property] table, navigate to MID Server ➜ Properties Related LinksMID Server properties