Ant community:

I'm trying to upgrade my build.xml to be ant 1.7.0 compatible and seem
to be stumbling on changes in the SQL task related to resource collections.

I have been trying:

    <sql driver="${jdbc_driver_class}" url="${jdbc_url}"
      userid="${this.user}" password="${this.password}"
      keepformat="true" delimiter="/" escapeprocessing="false"
print="true"
      onerror="continue">
      <fileset dir="${this.dir}">
       <include name="*.sql"/>
       <modified>
        <param name="cache.cachefile" value="./sql.properties"/>
       </modified>
      </fileset>
      <classpath>
       <pathelement location="${build.dir}/${jdbc.jar}"/>
      </classpath>
    </sql>

I keep getting the error message: "Source file or resource collection,
transactions, or sql statement must be set!". I thought that a fileset
WAS a resource collection and the manual says:

> You can specify multiple sources via nested resource collection
> elements. Each resource of the collection will be run in a transaction
> of its own. Prior to Ant 1.7 only filesets were supported. Use a sort
> resource collection to get a predictable order of transactions.
>
which, to me at least, indicates that a fileset should still be supported.
Can anyone shed some light on this or help me to see what I've fouled up
here? I can't seem to figure out what I'm doing wrong.

Thanks for your consideration,

John




---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@(protected)
For additional commands, e-mail: user-help@(protected)