On 6 Feb 2001, Daniel Rall wrote:
> 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).
The SQL is actually inserted via the <sql> task so there
are no DB specific scripts for insert the SQL, but there
are scripts generated via Torque to create the databases.
jvz.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
