Jason van Zyl <[EMAIL PROTECTED]> writes:
> On 5 Feb 2001, Daniel Rall wrote:
>
> > "Randall G. Alley" <[EMAIL PROTECTED]> writes:
> >
> > > Jason reminds me that the scripts to insert the SQL are probably
> > > database dependent as well. Perhaps you could manually insert the SQL as
> > > well.
> > > The SQL files appear in:
> > >
> > > webapps\yourapp\web-inf\src\sql
> >
> > What do you guys think about having Java code perform the database
> > build?
>
> Right now the <sql> task to run the SQL scripts ...
That could be very useful in combination with another task (outlined
below).
> > JDBC provides a nicely portable API. I think that that would
> > obviate the need for multiple scripts, as they would all simply call
> > an Ant task (or some such).
>
> JDBC has an API for creating databases?
No specific API, but you can split the content of the SQL schema file
into statements and execute them via JDBC. This would alleviate the
need to have both a shell and batch file to insert the SQL for each
database type (though we'd still have to generate SQL specific to each
database).
--
Daniel Rall <[EMAIL PROTECTED]>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
