Add a new executeMultiple() method to Client and Transaction. This method accepts a string with SQL statements separated by semicolons, and does not support parameters and does not return any rows.
Client.executeMultiple() opens a new database connection and executes the statements on them. It does not open a transaction, but the SQL script can contain transaction-control statements such as BEGIN and COMMIT. If a statement fails, further statements are not executed.
Transaction.executeMultiple() executes the statements in the database connection that belongs to the transaction. If a statement fails, further statements are not executed, but the transaction is not rolled back.
Add a new
executeMultiple()method toClientandTransaction. This method accepts a string with SQL statements separated by semicolons, and does not support parameters and does not return any rows.Client.executeMultiple()opens a new database connection and executes the statements on them. It does not open a transaction, but the SQL script can contain transaction-control statements such asBEGINandCOMMIT. If a statement fails, further statements are not executed.Transaction.executeMultiple()executes the statements in the database connection that belongs to the transaction. If a statement fails, further statements are not executed, but the transaction is not rolled back.