ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Hatcher <>
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, 

> 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! 
> Get your own FREE, personal Netscape Mail account today at 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> For additional commands, e-mail:

View raw message