Name
sql
Synopsis
Executes SQL statements using JDBC.
Attributes
-
autocommit(all, boolean, N) If
true, set the JDBCautocommitflag. Defaults tofalse.-
classpath(all, Path, N) The classpath to use when loading the JDBC driver.
-
classpathref(all, Reference, N) A reference to a classpath defined elsewhere in the buildfile.
-
delimiter(1.4, String, N) A string separating SQL statements. Defaults to "
;“.-
delimitertype(1.4, Enum, N) Legal values are
rowandnormal. Defaults tonormal, meaning that any occurrence of the delimiter terminates the SQL command.rowmeans the delimiter must appear on a line by itself.-
driver(all, String, Y) The class name of the JDBC driver.
-
onerror(all, Enum, N) Controls what happens when a statement fails. Defaults to
abort. Legal values are as follows:-
continue This task attempts to continue executing statements even after one or more statements fail.
-
abort The transaction is explicitly rolled back by the task when errors occur, just prior to aborting the build.
-
stop The build fails without attempting to rollback a failed transaction. Nonetheless, the database should roll back the transaction once the JVM exits.
-
-
output(all, File, N) The output file for result sets when
print=true. Defaults toSystem.out.-
password(all, String, Y) The database password.
-
print(all, boolean, N) If
true, print all result sets. Defaults tofalse.-
rdbms(all, String, N) Specifies an RDBMS brand, and restricts execution of this task to that RDBMS. This should equal the value returned from ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access