Subject Re: [Firebird-Java] Fixed one sql problem, found another
Author Roman Rokytskyy
> My DDL runs fine with isql, but I am getting an error with the sql
> command in ant.

Nothing will help you except a custom Ant task - the <sql/> task is too
"stupid" to respect the switch of the statement terminator in the SQL
script. And you must use ";" in the trigger and procedure body. In isql you
have something like SET TERM !!; and after the trigger body you have !! and
finally SET TERM ;!!.

You can find the simple script executor on our Wiki - it respects the SET
TERM command in the script. You can use that for your custom task. It would
be also great if you could contribute this task back to the project to help