Re: [m2] Database/SQL plugin? Generating DB from schema?

2006-02-22 Thread andrew cooke
thanks. however, it seems the plugin is too restrictive still - http://mojo.codehaus.org/jdbc-maven-plugin/introduction.html andrew Wayne Fay wrote: > Looks like there's also a maven-jdbc-plugin that you could potentially > use. But I've never used it myself. > > This email thread has some more

Re: [m2] Database/SQL plugin? Generating DB from schema?

2006-02-21 Thread Wayne Fay
Looks like there's also a maven-jdbc-plugin that you could potentially use. But I've never used it myself. This email thread has some more info: http://mail-archives.apache.org/mod_mbox/maven-users/200509.mbox/[EMAIL PROTECTED] If you use it, and it works like you were expecting, please let us k

Re: [m2] Database/SQL plugin? Generating DB from schema?

2006-02-21 Thread andrew cooke
thanks everyone. looks like ant is the consensus view! (although we just moved to maven from ant to avoid people having arbitrary chunks of functionality during builds...) cheers, andrew Kenney Westerhof wrote: > On Tue, 21 Feb 2006, andrew cooke wrote: > > The simplest solution is to use the

Re: [m2] Database/SQL plugin? Generating DB from schema?

2006-02-21 Thread Wayne Fay
If you can't find any other options, you can always try Antrun and tags... Here's an example using in-line sql commands (this goes in the build-plugin-tasks section): Give this a try? Wayne On 2/21/06, andrew cooke <[EMAIL PROTECTED]> wrote: > > no, they're just databases (SQL) (by schema i

RE: Re: [m2] Database/SQL plugin? Generating DB from schema?

2006-02-21 Thread Kieran Brady
We use the ant sql task to do this in the build section of the pom, in conjunction with DBUnit tests: maven-antrun-plugin mysql mysql-connector-java

Re: [m2] Database/SQL plugin? Generating DB from schema?

2006-02-21 Thread Kenney Westerhof
On Tue, 21 Feb 2006, andrew cooke wrote: The simplest solution is to use the antrun plugin, and the task. Be sure to add an under the tag that defines antrun containing a dependency to the jdbc driver. But there might also be an sql plugin out there. -- Kenney > > no, they're just databases (

Re: [m2] Database/SQL plugin? Generating DB from schema?

2006-02-21 Thread andrew cooke
no, they're just databases (SQL) (by schema i mean definitions of tables and stored procedures) andrew Pié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

Re: [m2] Database/SQL plugin? Generating DB from schema?

2006-02-21 Thread Piéroni Raphaël
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? > > Thank

[m2] Database/SQL plugin? Generating DB from schema?

2006-02-21 Thread andrew cooke
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 PROTEC