If you can't find any other options, you can always try Antrun and <sql> tags...
Here's an example using in-line sql commands (this goes in the
build-plugin-tasks section):
<sql classpathref="pgsqldriver.class.path"
driver="org.postgresql.Driver"
url="jdbc:postgresql://${pgsql.host}:${pgsql.port}/${pgsql.service}"
userid="${pgsql.user}" password="${pgsql.user.password}"
onerror="continue"><![CDATA[
DROP TABLE RAW_DATA;
DROP TABLE ERROR_LOG;
DROP TABLE CHANGE_LOG;
COMMIT;
]]></sql>
Give this a try?
Wayne
On 2/21/06, andrew cooke <[EMAIL PROTECTED]> wrote:
>
> no, they're just databases (SQL) (by schema i mean definitions of tables
> and stored procedures)
>
> andrew
>
> PiÃ(c)roni Raphaël wrote:
> > Do your database schema use Torque oà r hibernate ?
> >
> > Raphaël
> >
> > 2006/2/21, andrew cooke <[EMAIL PROTECTED]>:
> >>
> >>
> >> Hi,
> >>
> >> I have a DB schema that defines a database. I'd like Maven to manage
> >> this
> >> (so that I can delete/re0create the database before tests, for example).
> >> How do I do this?
> >>
> >> Thanks,
> >> Andrew
> >>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
