Return-Path: 
 <user-return-64305-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 3512 invoked from network); 19 Mar 2008 22:57:45 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 19 Mar 2008 22:57:45 -0000
Received: (qmail 16792 invoked by uid 500); 19 Mar 2008 22:57:39 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 16769 invoked by uid 500); 19 Mar 2008 22:57:39 -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 16758 invoked by uid 99); 19 Mar 2008 22:57:39 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Mar 2008 15:57:39 -0700
X-ASF-Spam-Status: No, hits=-4.0 required=10.0
	tests=RCVD_IN_DNSWL_MED,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [146.197.27.91] (HELO barrierN241.nike.com) (146.197.27.91)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Mar 2008 22:56:49 +0000
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: RE: how to load a bunch data from a txt file,
 and ant sql call these data
Date: Wed, 19 Mar 2008 15:56:37 -0700
Message-ID: <200803192257.m2JMv9ZJ025329@barrierN241.nike.com>
In-Reply-To: <A65532B432F0C341A8123992FDE4E44403F3A054@ATLPRDEVS01.uss.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: how to load a bunch data from a txt file,
 and ant sql call these data
Thread-Index: AciH0zC8N8Qaw0scTq+7bAXvo5n/SwAd6r9QAGkOnsAACPnFAAAARqpg
References: <A65532B432F0C341A8123992FDE4E44403D76805@ATLPRDEVS01.uss.net>
 <47D8F936.4080104@apache.org>
 <A65532B432F0C341A8123992FDE4E44403E040D3@ATLPRDEVS01.uss.net>
 <47DDD124.6040902@bull.net>
 <A65532B432F0C341A8123992FDE4E44403E04D70@ATLPRDEVS01.uss.net>
 <200803191830.m2JIUwdi000550@barrierN241.nike.com>
 <A65532B432F0C341A8123992FDE4E44403F3A054@ATLPRDEVS01.uss.net>
From: "Anderson, Rob (Global Trade)" <Rob.Anderson@nike.com>
To: "Ant Users List" <user@ant.apache.org>
X-OriginalArrivalTime: 19 Mar 2008 22:57:08.0413 (UTC)
 FILETIME=[8F0E7ED0:01C88A14]
X-Virus-Checked: Checked by ClamAV on apache.org

I'm not trying to be a jerk, but you would probably benefit from reading
the following...

http://catb.org/~esr/faqs/smart-questions.html

I don't think anybody here is interested in doing your work for you. But
if you have specific questions about things you are having difficulty
with, we are happy to help if we can.

-Rob Anderson


-----Original Message-----
From: Chaohua Wang [mailto:cwang@incomm.com]=20
Sent: Wednesday, March 19, 2008 3:52 PM
To: Ant Users List
Cc: floess@mindspring.com
Subject: how to load a bunch data from a txt file, and ant sql call
these data

Hi Folks,

I have a ant sql statement=20


<target name=3D"insertData">
		<sql driver=3D"${jdbcdriver}" url=3D"${dburl}/BillPay"
userid=3D"${userid}" password=3D"${password}"
			print=3D"yes" onerror=3D"continue"
output=3D"${tmp.dir}/dbModification.txt">
			<transaction> INSERT INTO Payment (RefNumber,
VAN, Amount, OptCode, VendorID,
				PriorRefNumber, TransactionTS,
IsProcessed) VALUES
=09
('6569998989','2131213','1131',2031,232,'7898', { fn NOW() },1);
</transaction>
			<transaction> INSERT INTO Payment (RefNumber,
VAN, Amount, OptCode, VendorID,
				PriorRefNumber, TransactionTS,
IsProcessed) VALUES
=09
('9565689232323','21313213','1131',2031,232,'7898', { fn NOW() },1);
</transaction>
		</sql>

Here there are 2 sql statement to insert. But I have more than 100 data
put in txt file.

Like this
'1569998989','2131213','1131',2031,232,'7898', { fn NOW() },
'2569998989','2131213','1131',2031,232,'7898', { fn NOW() },
'3569998989','2131213','1131',2031,232,'7898', { fn NOW() },


Could you tell me How can load these data from a txt file. And using
loop to insert these data into database. Which means dynamically.
So I don't need to put  more thant 100 sql statement in the ant build
file.=20

Thank you very much.

Cwang



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


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