In some situations, multiple commands need to be executed during with the ODBC CPM plugin.
IE: for MySQL when issuing the following:
UPDATE mysql.user SET Password=PASSWORD('%NEWPASSWORD%') WHERE User = '%USER%';
The command works but the password cannot be used because flush privileges is required.
Flush Privileges is a separate command so in order to run this Batch processing is needed so multiple command can be issued on the same command line.
IE:
UPDATE mysql.user SET Password=PASSWORD('%NEWPASSWORD%') WHERE User = '%USER%'; FLUSH PRIVILEGES;
Steps
In the Platform add the batch processing option to the connection string.
Note: This will only be successful if the ODBC driver in use supports batch processing. You should refer to the driver's documentation for confirmation.
([Edit Plaform] -> Automatic Password Management -> Additional Policy Settings)
Property: ConnectionCommand
Update Command to include option 67108864 (batch processing)
IE:
OOB (SSL_Enforce and FOUND_ROWS enabled):
Driver={MySQL ODBC 3.51 Driver};server=%ADDRESS%;user=%USER%;option=3;port=%PORT%;Password=%LOGONPASSWORD%
Batch processing enabled:
Driver={MySQL ODBC 3.51 Driver};server=%ADDRESS%;user=%USER%;option=67108864;port=%PORT%;Password=%LOGONPASSWORD%
SSL_Enforce, FOUND_ROWS, and Batch processing enabled:
Driver={MySQL ODBC 3.51 Driver};server=%ADDRESS%;user=%USER%;option=67108867;port=%PORT%;Password=%LOGONPASSWORD%