how to read from a file and execute the lines

[Jason Rodrigues]

Hi I am a noob @ Ant . The problem i am facing is that i have a text file "control.ini" which has a list of sql files that has to be read and executed in the db via ant.
control.ini
-----------
a.sql
b.sql


I used the load file and store it in a variable mess, when i use the
echo task i and see all the sql files in the variable mess. But when i try to use the foreach tag it bombs out . Am i following the correct route or am i way off base ??

Thankx for your helps guys

    
<project name="LoopThroughControlFile" basedir="." default="init">
    <target name="init">
    
    <!-- read file -->
    <echo message="Starting to execute sql files in the control file.."/>
    <loadfile property="mess" srcFile="control.ini"/>

   <foreach list="${mess}" target="callSqlExec" param="var">

</foreach>

 
    </target>
    
    
    
    <target name="callSqlExec">
        <echo message="${var}"/>
      </target>
 

    
 
</project>
 

[Jason Rodrigues]

hi guys , well i got it to work and i thought i share it with you guys . Since I didnt find a solution out there. Its not a perfect solution , but it works

PS. u need to have apache contrib lib

<!--
 Author: R-squared
 Date  : Feb 27, 06
 script: Loops through a file and executes the sql statements
-->
 
<project name="LoopThroughControlFile" basedir="." default="init">
    <!-- make sure you have ur driver.jar in the classpath -->
    
    <!-- Need contrib.jar for "foreach" , add the line below -->    
    <taskdef resource="net/sf/antcontrib/antcontrib.properties"/>
    
    <!-- database properties   -->     
    <property name="db.driver"   value="oracle.jdbc.driver.OracleDriver"/>
    <property name="db.url"      value="jdbc :-o	 racle:thin:@gmacwltd.gmacm.com :-o	 oo :-o	 oo"/>
    <property name="db.userid"   value="x"/>
    <property name="db.password" value="x"/>
    <property name="db.print"    value="yes"/>
    <property name="db.output"   value="outputfile.txt"/>
    <property name="oracle.jar"  value="C:\bea81sp4\weblogic81\server\lib\ojdbc14.jar"/>
 
    <target name="init">
    <echo message="Starting to execute sql files in the control file.."/>
    <!-- load file-->
<loadfile property="sqlFiles" srcFile="control.ini"/>
<foreach list="${sqlFiles}" target="execSql" param="var" delimiter="${line.separator}"/> 
</target>
    
    
    
    <target name="execSql">
        <echo message="File being execute : ${var} ..."/>
         <sql
    driver  ="${db.driver}"
    url    ="${db.url}"
    userid  ="${db.userid}"
    password="${db.password}"
    print   ="${db.print}"
    output  ="${db.output}">
  <transaction  src="${var}"/>
  <classpath>
  <pathelement location="${oracle.jar}"/>
  </classpath>
       
</sql>
    </target>