Carlos,

That message is coming from the <transaction> element, which apparently does
not support a nested <sort>. The Ant documentation matches the error
message you are seeing and says that <transaction> only supports single
element resource collections (
http://ant.apache.org/manual/CoreTasks/sql.html).

Try removing <transaction> so that your <sort> is nested directly within
<sql>. According to the Ant docs for <sql> each resource from a nested
resource collection is automatically run in its own transaction.

-Andrew

On Fri, May 16, 2008 at 11:57 AM, Carlos Alonso <calonso@(protected)>
wrote:

> Hi everyone.
>
> I'm looking for an automated way to execute a set of .sql files inside a
> sql task and I do need them to be executed in order. The ant task I've tried
> is the following
>
> <sql
>       driver = "com.mysql.jdbc.Driver"
>       password = "root"
>       url = "jdbc:mysql://127.0.0.1/"
>       userid = "root"
>       autocommit = "true"
>       classpath = "${lib}/mysql-connector-java-5.0.4-bin.jar"
>       >
>       <transaction>
>           <sort>
>                 <fileset dir="${sources.dir}" includes="*.sql" />
>           </sort>
>       </transaction>
>    </sql>
>
> But I get the following error "only single argument resource collections
> are supported."
> I've been looking over Google for possible solutions or examples, but I've
> seen no answer. Could anyone help?
>
> Thanks.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@(protected)
> For additional commands, e-mail: user-help@(protected)
>
>