Hi,
> I have a ant sql statement
>
>
> <target name="insertData">
> <sql driver="${jdbcdriver}" url="${dburl}/BillPay"
> userid="${userid}" password="${password}"
> print="yes" onerror="continue"
> output="${tmp.dir}/dbModification.txt">
> <transaction> INSERT INTO Payment (RefNumber,
> VAN, Amount, OptCode, VendorID,
> PriorRefNumber, TransactionTS,
> IsProcessed) VALUES
>
> ('6569998989','2131213','1131',2031,232,'7898', { fn NOW() },1);
> </transaction>
> <transaction> INSERT INTO Payment (RefNumber,
> VAN, Amount, OptCode, VendorID,
> PriorRefNumber, TransactionTS,
> IsProcessed) VALUES
>
> ('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.
Ant doesn't usually deal with 'loops' in the usual sense (imperative
programming style). In ant it's more normal to define a dataset and
perform the same operation for the entire set - not sure if I
explained that properly (morning coffee hasn't kicked in)
Here are a couple of suggestions:
- checkout dbunit it has good ant integration and makes this kind of
db interaction easy
- read the ant manual http://ant.apache.org/manual/CoreTasks/sql.html
<sql
driver="org.database.jdbcDriver"
url="jdbc:database-url"
userid="sa"
password="pass"
src="data.sql"
/>
Please be aware that we are all busy, and this is not an uncommon
thing to want to do so there's a good chance that someone has an
example or has asked the question before.
In the future if you could try:
- Check the ant manual (see if there's a task that matches what you want to do)
- Read the mailing list archives (google search for them or try
http://marc.info/)
- Finally ask on the users list
You may feel that it was rude to ask you to read the standard 'How to
ask for help page', but really there's a good reason that page exists
and especially with open source software where everyone is a
volunteer.
Thanks,
Kev
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
