The PDOSQLExecTask
executes SQL statements using PDO.
Note
The combination of large SQL files and
delimitertype
set to normal
can trigger segmentation faults with large files.
Table 112. Attributes
Name | Type | Description | Default | Required |
---|---|---|---|---|
url |
String |
PDO connection URL (DSN) | none | Yes |
userid |
String |
Username for connection (if it cannot be specified in URL) | none | No |
password |
String |
The password to use for the connection (if it cannot be specified in URL) | none | No |
src |
File | A single source file of SQL statements to execute. | none | No |
onerror |
String |
The action to perform on error (continue, stop, or abort) | abort | No |
delimiter |
String |
The delimeter to separate SQL statements (e.g. "GO" in MSSQL) | ; | No |
delimitertype |
String |
The delimiter type ("normal", "row" or "none"). Normal means that any occurence of the delimiter terminate the SQL command whereas with row, only a line containing just the delimiter is recognized as the end of the command. None disables all delimiter detection. | none | No |
autocommit |
Boolean |
Whether to auto (implicitly) commit every single statement, disabling transactions. | false |
No |
encoding |
String |
Encoding to use for read SQL files | none | No |