Return-Path: Delivered-To: apmail-ant-user-archive@www.apache.org Received: (qmail 99176 invoked from network); 5 Nov 2010 20:32:58 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 5 Nov 2010 20:32:58 -0000 Received: (qmail 85196 invoked by uid 500); 5 Nov 2010 20:33:29 -0000 Delivered-To: apmail-ant-user-archive@ant.apache.org Received: (qmail 85131 invoked by uid 500); 5 Nov 2010 20:33:28 -0000 Mailing-List: contact user-help@ant.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Ant Users List" Reply-To: "Ant Users List" Delivered-To: mailing list user@ant.apache.org Received: (qmail 85118 invoked by uid 99); 5 Nov 2010 20:33:28 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Nov 2010 20:33:28 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=10.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [194.25.41.13] (HELO smtpa2.mediabeam.com) (194.25.41.13) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 05 Nov 2010 20:33:22 +0000 Received: from UMS02-SMTP2 (balancer04.mediabeam.com [10.100.1.40]) by smtpa2.mediabeam.com (8.13.8/8.13.1) with ESMTP id oA5KWuUv020334 for ; Fri, 5 Nov 2010 21:32:56 +0100 Received: from [192.168.0.2] (95-88-148-226-dynip.superkabel.de [95.88.148.226] (may be forged)) (authenticated bits=0) by smtpa.mediabeam.com (8.13.8/8.13.1) with ESMTP id oA5KWt6o020326 for ; Fri, 5 Nov 2010 21:32:55 +0100 Message-ID: <4CD469F8.5040205@maksimo.de> Date: Fri, 05 Nov 2010 21:32:56 +0100 From: Gilbert Rebhan User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; de; rv:1.9.1.15) Gecko/20101026 SUSE/3.0.10 Thunderbird/3.0.10 MIME-Version: 1.0 To: Ant Users List Subject: Re: How to script database upgrade using ANT script References: <1288888082171-3250375.post@n5.nabble.com> <1288954104553-3251629.post@n5.nabble.com> In-Reply-To: <1288954104553-3251629.post@n5.nabble.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit -------- Original Message -------- Subject: Re: How to script database upgrade using ANT script From: Java Jboss To: user@ant.apache.org Date: 05.11.2010 11:48 > This is rather urgent so I would appreciate any assistance. I need to create > a recursive loop which I can't do and also some error checking module as > well as some how linking these modules together so that they depend on each > other etc... At the moment I have to run each target on its own. > > Please feel free to change my novice attempt at writing an ANT script. > > Thank you exec,exec,exec.. doesn't feel good IMO, i would try a JVM scripting language that works great with ant = Groovy here are some links to get you going = http://mauszeig.wordpress.com/2006/04/07/ant-groovy-and-the-database/ http://groovy.codehaus.org/Database+features http://groovy.codehaus.org/api/groovy/sql/Sql.html http://www.ibm.com/developerworks/java/library/j-pg01115.html http://mrhaki.blogspot.com/2009/10/groovy-goodness-groovy-sql.html Regards, Gilbert --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@ant.apache.org For additional commands, e-mail: user-help@ant.apache.org