I use Ant to build the database and pre-load data into the
database. I do this by creating a SQL script (flat file of SQL
commands) then use the external execution command for Ant to load
the SQL file using ISQL (command below). You have to break this
command up in the Ant "exec" tag - or, instead, create a .cmd or .sh
file to execute.

isql -input my_data_load.sql



--- In Firebird-Java@yahoogroups.com, Laurent Duperval
<laurent.duperval@f...> wrote:

> Hi,
>
> I want to run 'CREATE DATABASE' statements from ant. Does Jaybird
> support this? When i run it, I get this error:
>
> org.firebirdsql.jdbc.FBSQLException: Resource Exception. I/O error

for

> file %.0s"CreateFile (open)"
> null
> Error while trying to open file
> null
> Reason: I/O error for file %.0s"CreateFile (open)"
> null
> Error while trying to open file
> null
>
> I'm assuming it's because the URL given to the driver points to a
> non-existing file. Kind of a chicken/egg situation.
>
> L