RE: Retrieving key value pairs from URL and setting as system property

2008-03-19 Thread raju
Hi gilbert, Thanks for your replies. This is what i am trying to acheive from within an Ant script: Hit a URL say http://host/environment?name=test ,from which a get a response a containing key-value pairs containing data about the environment.(could this be done without writing the key-value d

testing garbled text

2008-03-19 Thread LLCool Jay
Oigrin of the n eA lam so nnkiacmed \\\T\h\"\\e Grey L\a\\y\d\\\", Nkentacut tekas its name from a wrod in an Eatesrn Aioalungqn lgaugane of srohteun New Ennlagd, orinaiglly slleped vorulsaiy as ncaotke, nitanacn, and naauitcn. The mneanig of the trem

Re: 答复: how to load a bunch data from a txt file, and ant sql call these data

2008-03-19 Thread Kevin Jackson
Hi, > I have a ant sql statement > > > > userid="${userid}" password="${password}" > print="yes" onerror="continue" > output="${tmp.dir}/dbModification.txt"> > INSERT INTO Payment (RefNumber, > VAN, Amount, OptCode, VendorID,

答复: how to load a bunch data from a tx t file, and ant sql call these data

2008-03-19 Thread Chaohua Wang
I am not interested in your link. I don't ask people for doing homework for me. I am asking for hint and some helpful links. Pleas understand my question first. -Original Message- From: Anderson, Rob (Global Trade) [mailto:[EMAIL PROTECTED] Sent: 2008-3-19 (星期三) 18:56 To: Ant Users

RE: how to load a bunch data from a txt file, and ant sql call these data

2008-03-19 Thread Anderson, Rob (Global Trade)
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 happ

how to load a bunch data from a txt file, and ant sql call these data

2008-03-19 Thread Chaohua Wang
Hi Folks, I have a ant sql statement INSERT INTO Payment (RefNumber, VAN, Amount, OptCode, VendorID, PriorRefNumber, TransactionTS, IsProcessed) VALUES ('6569998989','2131213','1131',2031,232,'7898', { fn NOW()

RE: ant sql call stored procedure

2008-03-19 Thread Chaohua Wang
Thank you very much for your help. -Original Message- From: Anderson, Rob (Global Trade) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 12:30 PM To: Ant Users List Subject: RE: ant sql call stored procedure It looks like the sql you are trying to execute is vendor specific. K

Re: ant sql call stored procedure

2008-03-19 Thread Scot P. Floess
Its not a vendor issue. I was trying to help out...and it appears it was an editor issue... Anderson, Rob (Global Trade) wrote: It looks like the sql you are trying to execute is vendor specific. Keep in mind that the Ant sql task uses a jdbc connection, and cannot accommodate vendor specifi

RE: ant sql call stored procedure

2008-03-19 Thread Anderson, Rob (Global Trade)
It looks like the sql you are trying to execute is vendor specific. Keep in mind that the Ant sql task uses a jdbc connection, and cannot accommodate vendor specific statements that may work fine in the vendor supplied client. -Rob Anderson -Original Message- From: Chaohua Wang [mailto:

RE: setting properties

2008-03-19 Thread Anderson, Rob (Global Trade)
Given that the properties in ant are immutable, you should have the defaults set in a properties file and override them in your environment. This is opposite of what you describe, where you are attempting to set defaults in your environment and override them with a properties file. -Rob Anderson

RE: a stored procedure example for an sql src.

2008-03-19 Thread Anderson, Rob (Global Trade)
The documentation has examples. http://ant.apache.org/manual/CoreTasks/sql.html -Rob A -Original Message- From: Chaohua Wang [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 2:49 PM To: Ant Users List Subject: a stored procedure example for an sql src. Hi folks, could somebo

RE: ant sql call stored procedure

2008-03-19 Thread Anderson, Rob (Global Trade)
When executing sql using Ant, you are using a jdbc connection, not the sql client that is available from the database vendor. Some of the features that are database specific are not available when using a jdbc connection. If you find that the Ant sql task does not support your vendor specific sq

RE: SQL scripts in ANT

2008-03-19 Thread Anderson, Rob (Global Trade)
The usage of @filename in a sql script works in sqlplus because that is a feature of sqlplus. When executing sql from ant, you are using a jdbc connection and database specific things like this do not work. Use a fileset to execute all the files you intent to execute. See the documentation for the

RE: Retrieving key value pairs from URL and setting as system property

2008-03-19 Thread Burgess, Benjamin
You could do it as separate steps: http://.../viewproperties"; dest="downloaded.properties" usetimestamp="true" /> You may also have to set Ben -Original Message- From: raju [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 7:23 AM To: user@ant.apache.org Subject: Retrieving

RE: Retrieving key value pairs from URL and setting as system property

2008-03-19 Thread Rebhan, Gilbert
... /* setting the env variables = accessing the env variables = $${env.FOO} == ${env.FOO} $${env.BAR} == ${env.BAR} other already set env variables are also accessible $${env.JAVA_HOME} == ${env.JAVA_HOME} $${env.TOMCAT_HOME} == ${env.TOMCAT_HOME} */ when using the variables are only

RE: Retrieving key value pairs from URL and setting as system property

2008-03-19 Thread Rebhan, Gilbert
-Original Message- From: raju [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 12:23 PM To: user@ant.apache.org Subject: Retrieving key value pairs from URL and setting as system property /* I need to access a web URL say http://.../viewproperties which throws plain html with

Retrieving key value pairs from URL and setting as system property

2008-03-19 Thread raju
Hi, I need to access a web URL say http://.../viewproperties which throws plain html with key value pairs as response. Now as part of the main build i need to acces the above mentioned URL and set each of the key value pairs as system environment variables so that they are available other progr