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
|