ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rizwan Merchant" <riz...@alpha-it.com>
Subject RE: sql task sp_dboptions problem
Date Thu, 25 Aug 2005 18:59:40 GMT

I don't think so, because the cleanDB.sql file still refers to a specific
database. What I want to do is somehow pass a parameter to the cleanDB.sql
file so that the file can be generic.

-----Original Message-----
From: RADEMAKERS Tanguy [mailto:Tanguy.RADEMAKERS@swift.com] 
Sent: Thursday, August 25, 2005 2:51 PM
To: Ant Users List
Subject: RE: sql task sp_dboptions problem

wouldn't this work?


<sql driver="com.microsoft.jdbc.sqlserver.SQLServerDriver" 
 
url="jdbc:microsoft:sqlserver://localhost\myinstance:1433;DatabaseName=$
{the.database.i.wanted.to.pass}"
     userid="sa"
     password="${the.password.of.the.database.i.wanted.to.pass}"
     src="cleanDB.sql"
     />

>-----Original Message-----
>From: Moran Ben-David [mailto:moran@place-base.com] 
>Sent: Thursday, August 25, 2005 8:43 PM
>To: 'Ant Users List'
>Subject: RE: sql task sp_dboptions problem
>
>Sorry Razwan,
>
>I am not familiar with the <sql> task enough to help you on 
>that.  However,
>one thing I can suggest is that instead of using the tasks' 
>"src" attribute,
>you put the sql from cleanDB.sql in you're ant file as such:
>
>
><sql driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
>url="jdbc:microsoft:sqlserver://localhost\myinstance:1433;Datab
>aseName=on_de
>velop" userid="sa" password="on_develop">
>
>	-- example code from cleanDB.sql
>	DROP DATABASE ${the.database.i.wanted.to.pass};
>
></sql>
>
>Moran

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


Mime
View raw message