Return-Path: 
 <user-return-33703-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 36069 invoked by uid 500); 11 Jun 2003 07:49:57 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Subscribe: <mailto:user-subscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 36058 invoked from network); 11 Jun 2003 07:49:57 -0000
Received: from dnsinet.rzf-nrw.de (193.109.238.66)
  by daedalus.apache.org with SMTP; 11 Jun 2003 07:49:57 -0000
Received: from z011104.bk.fin.local (z011104.bk.fin.local [193.109.238.140])
	by dnsinet.rzf-nrw.de (8.12.9/8.12.9) with ESMTP id h5B7o6BT009599
	for <user@ant.apache.org>; Wed, 11 Jun 2003 09:50:06 +0200
Received: by z011104.bk.fin.local with Internet Mail Service (5.5.2653.19)
	id <MWLSBL32>; Wed, 11 Jun 2003 09:50:07 +0200
Message-ID: <879A5AD5DD0ED511891F0003473A9B5608FF6A30@Z011004>
From: Jan.Materne@rzf.fin-nrw.de
To: user@ant.apache.org
Subject: AW: looping over exec task
Date: Wed, 11 Jun 2003 09:49:43 +0200
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C32FEE.0582DC90"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C32FEE.0582DC90
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

1) concat the sql files with <concat> and use that
2) use Ant-Contrib=B4s <foreach>
3) use <script> for iterating over the sql files

Do you need more help on one of these?


Jan


> -----Urspr=FCngliche Nachricht-----
> Von: Bart van Kuik [mailto:bart.van.kuik@oracle.com]
> Gesendet am: Mittwoch, 11. Juni 2003 09:02
> An: user@ant.apache.org
> Betreff: Q: looping over exec task
>=20
> Hi ppl,
>=20
> I'm using Ant to run a SQL script, like this:
>=20
>      <target name=3D"sql">
>          <fileset dir=3D"sql" id=3D"fs">
>              <include name=3D"*.sql"/>
>          </fileset>
>          <!-- Convert the names to a property -->
>          <pathconvert pathsep=3D" " property=3D"pks" refid=3D"fs"/>
>=20
>          <exec executable=3D"sqlplus" dir=3D"sql">
>              <arg value=3D"-S"/>        <!-- Silent -->
>              <arg value=3D"${db_login}/${db_passwd}@${db}"/>
>              <arg value=3D"${sql}"/>
>          </exec>
>      </target>
>=20
> Problem is: sqlplus (the commandline Oracle client) doesn't accept=20
> multiple files! I want to work around this by looping over the exec=20
> task. Can this be done. A little googling showed some javascript=20
> kludges, but I want some clean XML, please :)
>=20
> TIA
> Bart
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
>=20

------_=_NextPart_001_01C32FEE.0582DC90--