| Class: com.sybase.djc.ant.IsqlTask (Isql Task) | EAServer 6.3 Help |
|---|
| Description | Executes a SQL statement on a specified data source. |
|---|---|
| Configuration |
Example:
<isql dataSource="default" ifDatabaseType="Sybase_ASE"> create table my_table (my_blob image) </isql> <isql dataSource="default" ifDatabaseType="Oracle"> create table my_table (my_blob blob) </isql> |
| Task Parameters | autoCommit, dataSource, ifDatabaseType, proceedOnFail, sql, src |
| Property: autoCommit (Auto Commit) | |
|---|---|
| Description | Enables JDBC auto-commit for the data source before executing the SQL statement. |
| Default Value | false |
| Legal Values | false, true |
| Property: dataSource (Data Source) | |
|---|---|
| Description | Name of a configured data source. |
| Property: ifDatabaseType (If Database Type) | |
|---|---|
| Description | Comma separated list of database types. The SQL statement is only executed if the database type for the selected data source is included in this list. |
| Property: proceedOnFail (Proceed On Fail) | |
|---|---|
| Description | Allows build to proceed if execution of the SQL statement fails. |
| Default Value | false |
| Legal Values | false, true |
| Property: sql (SQL Statement) | |
|---|---|
| Description |
SQL statement to be executed against the selected data source.
If this is not specified, the src property must be specified.
The SQL statement can also be specified between the <isql> and </isql> tags. |
| Property: src (SQL File) | |
|---|---|
| Description | Name of file containing SQL statement to be executed against the selected data source. If this is not specified, the sql property must be specified. |