Return-Path: 
 <user-return-69379-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 31762 invoked from network); 16 Nov 2009 14:30:29 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 16 Nov 2009 14:30:29 -0000
Received: (qmail 85329 invoked by uid 500); 16 Nov 2009 14:30:28 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 85236 invoked by uid 500); 16 Nov 2009 14:30:27 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 85226 invoked by uid 99); 16 Nov 2009 14:30:27 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Nov 2009 14:30:27 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of sfloess@nc.rr.com designates
 75.180.132.120 as permitted sender)
Received: from [75.180.132.120] (HELO cdptpa-omtalb.mail.rr.com)
 (75.180.132.120)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 16 Nov 2009 14:30:18 +0000
Received: from flossware.homelinux.org ([66.57.231.67])
          by cdptpa-omta04.mail.rr.com with ESMTP
          id <20091116142957412.EUPQ5263@cdptpa-omta04.mail.rr.com>
          for <user@ant.apache.org>; Mon, 16 Nov 2009 14:29:57 +0000
Received: from adminserver.flossware.com (adminserver.flossware.com
 [192.168.168.253])
	by flossware.homelinux.org (Postfix) with ESMTP id 0DB8912120B2
	for <user@ant.apache.org>; Mon, 16 Nov 2009 09:29:57 -0500 (EST)
Date: Mon, 16 Nov 2009 09:29:57 -0500 (EST)
From: "Scot P. Floess" <sfloess@nc.rr.com>
X-X-Sender: sfloess@adminserver.flossware.com
To: Ant Users List <user@ant.apache.org>
Subject: Re: ant sql query weirdness
In-Reply-To: <1d6b114f0911151856k7c9692e2r63096d946d0ed434@mail.gmail.com>
Message-ID: <alpine.LRH.2.00.0911160929100.28326@adminserver.flossware.com>
References: <bc63fcdb0911132026m16e4d889vc10d48c79e9944e@mail.gmail.com>
  <alpine.LRH.2.00.0911152148050.28326@adminserver.flossware.com>
 <1d6b114f0911151856k7c9692e2r63096d946d0ed434@mail.gmail.com>
User-Agent: Alpine 2.00 (LRH 1167 2008-08-23)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Checked: Checked by ClamAV on apache.org


I see you have onerror set to stop.  What happens if you don't set that 
attribute?  It defaults to abort if not set...

On Sun, 15 Nov 2009, Richard Brunelle wrote:

> Yes, both echo statements get executed.
>
> Thanks Scot.
>
> On Sun, Nov 15, 2009 at 9:49 PM, Scot P. Floess <sfloess@nc.rr.com> wrote:
>
>>
>> Question for you...Do both echo statements get executed?  Meaning, both
>> targets in the depends are honored (printUsStatesData -and"
>> printAccountsData's echo statements are executed)...
>>
>> On Fri, 13 Nov 2009, Richard Brunelle wrote:
>>
>>  This is driving me crazy....
>>>
>>> I have the following code in an ant file.
>>>
>>> <target name="printAccountsData">
>>>       <echo message="PRINT accounts DATA USING: ${db.driver} ${db.url}"/>
>>>       <sql driver="${db.driver}"
>>>            url="${db.url}"
>>>            userid="${db.user}"
>>>            password="${db.pw}"
>>>            onerror="stop"
>>>            print="true">
>>>           <classpath refid="master-classpath"/>
>>>
>>>           SELECT * FROM accounts;
>>>
>>>       </sql>
>>>   </target>
>>>
>>>   <target name="printUsStatesData">
>>>       <echo message="PRINT us_states DATA USING: ${db.driver} ${db.url}"/>
>>>       <sql driver="${db.driver}"
>>>            url="${db.url}"
>>>            userid="${db.user}"
>>>            password="${db.pw}"
>>>            onerror="stop"
>>>            print="true">
>>>           <classpath refid="master-classpath"/>
>>>
>>>           SELECT * FROM us_states;
>>>
>>>       </sql>
>>>   </target>
>>>
>>> individidualy, each of these targets return proper data from the database.
>>> But when I do this and execute 'ant printData', only results from the
>>> first
>>> dependency listed below prints data.  Any insight into why this is
>>> happening?   It is as if the second print="true" is being ignored. No
>>> errors
>>> are generated.
>>>
>>> <target name="printData" depends="printUsStatesData,
>>>                                     printAccountsData">
>>>       <echo message="PRINT DATA USING: ${db.driver} ${db.url}"/>
>>>   </target>
>>>
>>> Thanks for any insight into this issue.
>>>
>>>
>>> Richard P. Brunelle
>>> Solutions Architect
>>> BinaryDream
>>>
>>>
>> Scot P. Floess
>> 27 Lake Royale
>> Louisburg, NC  27549
>>
>> 252-478-8087 (Home)
>> 919-890-8117 (Work)
>>
>> Chief Architect JPlate   http://sourceforge.net/projects/jplate
>> Chief Architect JavaPIM  http://sourceforge.net/projects/javapim
>>
>> Architect Keros          http://sourceforge.net/projects/keros
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
>> For additional commands, e-mail: user-help@ant.apache.org
>>
>>
>
>
> -- 
> Richard Brunelle
>
> ~~^^~~
> Sent from Atlanta, GA, United States
>

Scot P. Floess
27 Lake Royale
Louisburg, NC  27549

252-478-8087 (Home)
919-890-8117 (Work)

Chief Architect JPlate   http://sourceforge.net/projects/jplate
Chief Architect JavaPIM  http://sourceforge.net/projects/javapim

Architect Keros          http://sourceforge.net/projects/keros

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org