« Return to Thread: using ij in an ant task to create a database and nothing else

Re: using ij in an ant task to create a database and nothing else

by Andrew McIntyre-2 :: Rate this Message:

Reply to Author | View in Thread

On Fri, Jun 12, 2009 at 5:04 PM, Kathey
Marsden<kmarsdenderby@...> wrote:
> Someone asked me today how to create a database with ij in an ant task by
> just using ij.database if they don't have any script to execute.  He had
> implemented the following workaround to create a temporary file with just
> "quit;" in it.

What about using Ant's sql task? I checked and this created the
database without needing to touch any files:

<sql driver="org.apache.derby."
    url="jdbc:derby:mydb;create=true"
    userid=""
    password="">
set schema app;
</sql>

It requires that you have *some* sql in there, so a set schema works nicely.

andrew

 « Return to Thread: using ij in an ant task to create a database and nothing else