ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan.Mate...@rzf.fin-nrw.de
Subject AW: looping over exec task
Date Wed, 11 Jun 2003 07:49:43 GMT
1) concat the sql files with <concat> and use that
2) use Ant-Contrib┬┤s <foreach>
3) use <script> for iterating over the sql files

Do you need more help on one of these?


Jan


> -----Urspr├╝ngliche 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
> 
> Hi ppl,
> 
> I'm using Ant to run a SQL script, like this:
> 
>      <target name="sql">
>          <fileset dir="sql" id="fs">
>              <include name="*.sql"/>
>          </fileset>
>          <!-- Convert the names to a property -->
>          <pathconvert pathsep=" " property="pks" refid="fs"/>
> 
>          <exec executable="sqlplus" dir="sql">
>              <arg value="-S"/>        <!-- Silent -->
>              <arg value="${db_login}/${db_passwd}@${db}"/>
>              <arg value="${sql}"/>
>          </exec>
>      </target>
> 
> Problem is: sqlplus (the commandline Oracle client) doesn't accept 
> multiple files! I want to work around this by looping over the exec 
> task. Can this be done. A little googling showed some javascript 
> kludges, but I want some clean XML, please :)
> 
> TIA
> Bart
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
> 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message