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 19:28:19 GMT
Hmmm...that <replace> looks like a good idea. Thanks...

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

wellllllllllllllll... (more than one way to skin a cat)

if the cleanDB.sql file has db-specific references, you could
"specialize" this file before running it using the <replace> task.

that would work if we're talking about changing names... it could be
made to work if we're talking about selectively executing only some
parts of the file, but it would get messy quite quick!

/t

>-----Original Message-----
>From: Rizwan Merchant [mailto:rizwan@alpha-it.com] 
>Sent: Thursday, August 25, 2005 9:00 PM
>To: 'Ant Users List'
>Subject: RE: sql task sp_dboptions problem
>
>
>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;Datab
>aseName=$
>{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
>
>

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