ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mario Manfre" <Mar...@PGAS.com>
Subject SQL parameter
Date Tue, 17 Feb 2004 20:39:53 GMT
HI,
I'm trying to create or drop a database based on a property file.

the basics are

 <property name="db.name"        value="Test_DB"/>


and then either do

            <exec  executable="osql"
                  dir="C:\Build\"
                  failonerror="true"   
                  vmlauncher="false"
                  >
            <arg value='-E'/> 
            <arg value='-SSQL-SERVER\'/>
            <arg value='-q"drop database ${db.name}"'/>
            </exec>


      <sql driver="${dbDriver}"
             classpath="${jdbc}:${jdbc-add1}:${jdbc-add2}"
             url="${jdbc-connect}"
             userid="${db.user}"
             password="${db.user.password}"
             print="false"
             >
             <transaction src="drop database ${db.name}"/>
             </sql>

Or is there some other way which I am missing?

Thanks,
Mario

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


Mime
View raw message