Ant: The Definitive Guide

Name

sql

Synopsis

Executes SQL statements using JDBC.

Attributes

autocommit (all, boolean, N)

If true, set the JDBC autocommit flag. Defaults to false.

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 row and normal. Defaults to normal, meaning that any occurrence of the delimiter terminates the SQL command. row means 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 to System.out.

password (all, String, Y)

The database password.

print (all, boolean, N)

If true, print all result sets. Defaults to false.

rdbms (all, String, N)

Specifies an RDBMS brand, and restricts execution of this task to that RDBMS. This should equal the value returned from ...