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 <[EMAIL 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
