Thank you very much Andrew. It works fine!
Andrew Goktepe escribió:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
