From user-return-64826-apmail-ant-user-archive=ant.apache.org@ant.apache.org Sat May 17 15:27:31 2008 Return-Path: Delivered-To: apmail-ant-user-archive@www.apache.org Received: (qmail 61221 invoked from network); 17 May 2008 15:27:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 17 May 2008 15:27:31 -0000 Received: (qmail 85726 invoked by uid 500); 17 May 2008 15:27:29 -0000 Delivered-To: apmail-ant-user-archive@ant.apache.org Received: (qmail 85689 invoked by uid 500); 17 May 2008 15:27:29 -0000 Mailing-List: contact user-help@ant.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Ant Users List" Reply-To: "Ant Users List" Delivered-To: mailing list user@ant.apache.org Received: (qmail 85678 invoked by uid 99); 17 May 2008 15:27:29 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 May 2008 08:27:29 -0700 X-ASF-Spam-Status: No, hits=2.9 required=10.0 tests=HTML_MESSAGE,NORMAL_HTTP_TO_IP,SPF_PASS,URIBL_RHS_DOB X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of andrewgoktepe@gmail.com designates 74.125.46.155 as permitted sender) Received: from [74.125.46.155] (HELO yw-out-1718.google.com) (74.125.46.155) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 17 May 2008 15:26:43 +0000 Received: by yw-out-1718.google.com with SMTP id 9so806849ywk.70 for ; Sat, 17 May 2008 08:26:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; bh=yNAibyY9MKZMrBux/KEOpJgavaCkPnaFZdrBKtc/VEg=; b=W32GQ9VYG8ZL9sVjDOkCFekkwiGsp/N366fTZAaMJieRZgfNhN8xF5whyUaGi254Q6E+ilQ0BLBtxdDBuZvrq/QrGNoqHo3lCcOU6I2Mo7xKKTwpVIXiDwqouB+pFjFd+mAMmeT/IfSgDq5/VV0hx8Vw16miBsAcO8othahLzBo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=vFA+WUZOm1NDRxZMhL1FzyqmMOZ4Blq2FhmnzjzROC5TLIZrlPJiBILoN9SWaolZS1aAzvdnbdzd5Dv/sa85lkH7Rhwm/VCVRx4nSF1Zpx0hGrkdeQmp3eybzplWsZgKSJXVnhq7EMk9dMSh6DkPGlIZ/an3lXo140LzZrdwES8= Received: by 10.150.73.6 with SMTP id v6mr4636659yba.121.1211038018127; Sat, 17 May 2008 08:26:58 -0700 (PDT) Received: by 10.151.11.13 with HTTP; Sat, 17 May 2008 08:26:58 -0700 (PDT) Message-ID: <98c2b60d0805170826n78ce1ef8gfff58c1a1fbcae48@mail.gmail.com> Date: Sat, 17 May 2008 10:26:58 -0500 From: "Andrew Goktepe" To: "Ant Users List" Subject: Re: Executing a sorted fileset of .sql files in sql task In-Reply-To: <482DBD15.6050507@unkasoft.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9775_14643611.1211038018116" References: <482DBD15.6050507@unkasoft.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_9775_14643611.1211038018116 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Carlos, That message is coming from the element, which apparently does not support a nested . The Ant documentation matches the error message you are seeing and says that only supports single element resource collections ( http://ant.apache.org/manual/CoreTasks/sql.html). Try removing so that your is nested directly within . According to the Ant docs for 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 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 > > 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" > > > > > > > > > > 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@ant.apache.org > For additional commands, e-mail: user-help@ant.apache.org > > ------=_Part_9775_14643611.1211038018116--