ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Hatcher <jakarta-...@ehatchersolutions.com>
Subject Re: Does SQL task support a single transaction for multiple sql files?
Date Tue, 18 Feb 2003 00:10:30 GMT
Would <concat>'enating the files together do the trick for you?


On Monday, February 17, 2003, at 06:56  PM, davexmail@netscape.net 
wrote:

> Hi,
>
> We are using ANT for our deployments and want to automate the database 
> updates as well. We have multiple sql files for a single release to 
> make it easier to maintain them.
>
> When we do a deployment I want to run all the scripts in a single 
> transaction so that if any go wrong I can roll them all back. 
> Unfortunately the SQL task says that it creates a new transaction for 
> each file, this means that if one fails it won't roll back them all. 
> It needs to be all or nothing when it comes to the database as the new 
> code we deploy will expect all the changes there and if we roll back, 
> the old code will expect none of the changes.
>
> Any suggestions?
> Do I need to create my own custom task?
>
> Cheers Dave
>
> __________________________________________________________________
> The NEW Netscape 7.0 browser is now available. Upgrade now! 
> http://channels.netscape.com/ns/browsers/download.jsp
>
> Get your own FREE, personal Netscape Mail account today at 
> http://webmail.netscape.com/
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>
>


Mime
View raw message