Return-Path: 
 <user-return-41161-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 40695 invoked from network); 18 Feb 2004 16:09:47 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 18 Feb 2004 16:09:47 -0000
Received: (qmail 22302 invoked by uid 500); 18 Feb 2004 16:09:32 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 22263 invoked by uid 500); 18 Feb 2004 16:09:32 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Subscribe: <mailto:user-subscribe@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 22250 invoked from network); 18 Feb 2004 16:09:31 -0000
Received: from unknown (HELO PGAS-MAIL.PGAS.PGAS.COM) (162.39.153.209)
  by daedalus.apache.org with SMTP; 18 Feb 2004 16:09:31 -0000
content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: SQL parameter
X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0
Date: Wed, 18 Feb 2004 10:05:03 -0600
Message-ID: <F3E4AE30B8A9C84FBC868F4F3348D46356A5F4@pgas-mail.pgas.pgas.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: SQL parameter
Thread-Index: AcP1otMtkGrnPZSTQY6Vs4MeEPmY4AAkppoAAADayeA=
From: "Mario Manfre" <MarioM@PGAS.com>
To: "Ant Users List" <user@ant.apache.org>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

looks like it didn't like the <arg value=3D>..change to <arg line> and =
it seems to be working.

-----Original Message-----
From: Mario Manfre=20
Sent: Wednesday, 02 18, 2004 09:54
To: Ant Users List
Subject: RE: SQL parameter


ok..closer but not that I got my &quot=20

If I do

            <arg value=3D'-q&quot;drop database ${db.name}&quot;'/>
I get the following
'osql'
'-E'
'-SSQL-SERVER\MYDBs'
'-a8192'
'-q"drop database NightBuild_Test";'

The ' characters around the executable and arguments are
not part of the command.
     [exec] usage: osql              [-U login id]          [-P passwor
     [exec]   [-S server]            [-H hostname]          [-E trusted
     [exec]   [-d use database name] [-l login timeout]     [-t query t
     [exec]   [-h headers]           [-s colseparator]      [-w columnw
     [exec]   [-a packetsize]        [-e echo input]        [-I Enable
     [exec]   [-L list servers]      [-c cmdend]            [-D ODBC DS
     [exec]   [-q "cmdline query"]   [-Q "cmdline query" and exit]
     [exec]   [-n remove numbering]  [-m errorlevel]
     [exec]   [-r msgs to stderr]    [-V severitylevel]
     [exec]   [-i inputfile]         [-o outputfile]
     [exec]   [-p print statistics]  [-b On error batch abort]
     [exec]   [-O use Old ISQL behavior disables the following]
     [exec]       <EOF> batch processing
     [exec]       Auto console width scaling
     [exec]       Wide messages
     [exec]       default errorlevel is -1 vs 1
     [exec]   [-? show syntax summary]



BUILD FAILED
C:\PGAS\Development\Build\build.xml:615: exec returned: 1
        at org.apache.tools.ant.taskdefs.ExecTask.runExecute(ExecTask.j
        at org.apache.tools.ant.taskdefs.ExecTask.runExec(ExecTask.java
        at org.apache.tools.ant.taskdefs.ExecTask.execute(ExecTask.java
        at org.apache.tools.ant.UnknownElement.execute(UnknownElement.j
        at org.apache.tools.ant.Task.perform(Task.java:401)
        at org.apache.tools.ant.Target.execute(Target.java:338)
        at org.apache.tools.ant.Target.performTasks(Target.java:365)
        at org.apache.tools.ant.Project.executeTarget(Project.java:1237
        at org.apache.tools.ant.Project.executeTargets(Project.java:109
        at org.apache.tools.ant.Main.runBuild(Main.java:669)
        at org.apache.tools.ant.Main.startAnt(Main.java:220)
        at org.apache.tools.ant.launch.Launcher.run(Launcher.java:215)
        at org.apache.tools.ant.launch.Launcher.main(Launcher.java:90)


also, it looks like the <sql command doesn't allow a single SQL command =
to be issued, only running of a .sql file :(

-----Original Message-----
From: Antoine L=E9vy-Lambert [mailto:antoine@apache.org]
Sent: Tuesday, 02 17, 2004 16:12
To: Ant Users List
Subject: Re: SQL parameter


Mario Manfre wrote:

>HI,
>I'm trying to create or drop a database based on a property file.
>
>the basics are
>
> <property name=3D"db.name"        value=3D"Test_DB"/>
>
>
>and then either do
>
>            <exec  executable=3D"osql"
>                  dir=3D"C:\Build\"
>                  failonerror=3D"true"  =20
>                  vmlauncher=3D"false"
>                  >
>            <arg value=3D'-E'/>=20
>            <arg value=3D'-SSQL-SERVER\MYDBs'/>
>            <arg value=3D'-q"drop database ${db.name}"'/>
>            </exec>
>
>
>      <sql driver=3D"${dbDriver}"
>             classpath=3D"${jdbc}:${jdbc-add1}:${jdbc-add2}"
>             url=3D"${jdbc-connect}"
>             userid=3D"${db.user}"
>             password=3D"${db.user.password}"
>             print=3D"false"
>             >
>             <transaction src=3D"drop database ${db.name}"/>
>             </sql>
>
>Or is there some other way which I am missing?
>
>Thanks,
>Mario
>
> =20
>
This sounds good. Pay attention that you might need to escape as &quot;=20
the double quotes in the argument -q"drop database ${db.name}",
so write -q&quot;drop database ${db.name}&quot;

Come back to the list if something does not work out properly.

Antoine


---------------------------------------------------------------------
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


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