<macrodef name="run-sql-file">
        <attribute name="file.name"/>
        <attribute name="user"/>
        <attribute name="password"/>
        <sequential>
            <sql
                    driver="oracle.jdbc.driver.OracleDriver"
                    classpath="${templateResources}/genericLibs/ojdbc14.jar"
                    url="jdbc:oracle:thin:@${ds_server}:${ds_sid}"
                    userid="@{user}"
                    password="@{password}"
                    src="@{file.name}"
                    >//1004
            </sql>
        </sequential>
    </macrodef>

   <target name="sql" depends="drop-all-tables, drop-all-sequences">
        <!-- DDL : tables & stuff -->
        <echo message="Purging 10g recyclebin"/>
        <sql-query sql="PURGE RECYCLEBIN" user="${ds_username}" password="${ds_password}"/>

        <run-sql-file file.name="${data}/ddl/tables.jdbc.sql" user="${ds_username}" password="${ds_password}"/> //1045