title: logging in ant script for running .sql
body: <p>I have a .sql file which contain create script for 20 tables.I am running this through ant.</p>
  
  <p>the Ant Script is </p>
  
  <pre><code>&lt;target name="CompleteDBRollCreate" &gt;
          &lt;sql classpath="D:\lib\ojdbc14.jar"      driver="oracle.jdbc.driver.OracleDriver"     
          url="jdbc:oracle:thin:@12326:1521:orcl"      
          userid="scott"      password="tiger"    
          src="D:\dropalltables.sql"  /&gt; 
          &lt;/target&gt;
  </code></pre>
  
  <p>but there is no logging in ant so I can't know if the SQL file was executed correctly. Can any one please suggest how to do logging into a separate localfile/on the ant console. I just want to know where I need to change the .sql file or the ant script.</p>