<sql>
The <sql> task enables you to execute SQL statements on a database via JDBC. You can either provide the SQL statement(s) within the tag, or via an external source file. The SQL statements may optionally contain comments using // or REM at the start of the lines.
Table 4.73 provides a full list of the task’s attributes.
| Attributes | Description |
|---|---|
| Required | |
| driver | The class name of the JDBC driver to be used. |
| password | Database password. |
| src (unless statement(s) enclosed within tags) | The name of a file containing the SQL statement(s) to execute. |
| url | Database connection URL. |
| userid | Database username. |
| Optional | |
| append | If true, output will be appended to an existing file rather than the file being overwritten. ... |
Get Ant Developer’s Handbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
