Return-Path: 
 <user-return-52023-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 33526 invoked from network); 25 Aug 2005 19:09:13 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 25 Aug 2005 19:09:13 -0000
Received: (qmail 84185 invoked by uid 500); 25 Aug 2005 19:09:07 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 84142 invoked by uid 500); 25 Aug 2005 19:09:07 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@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 84112 invoked by uid 99); 25 Aug 2005 19:09:07 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Aug 2005 12:09:06 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [194.78.35.134] (HELO besec551.swift.com) (194.78.35.134)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 25 Aug 2005 12:09:24 -0700
Received: from besec561 ([172.24.88.21])
	by besec551.swift.com (Switch-3.1.6/Switch-3.1.6) with ESMTP id
 j7PJ7kxc016892
	for <user@ant.apache.org>; Thu, 25 Aug 2005 19:07:46 GMT
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.5.7233.11
Subject: RE: sql task sp_dboptions problem
Date: Thu, 25 Aug 2005 21:06:24 +0200
Message-ID: <E8BDA1F40F40BD4396D49DF2A48963CB26E1B2@BE-EXCHANGE-03.swift.corp>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: sql task sp_dboptions problem
Thread-Index: 
 AcWpjqNx3SH3zJUESa+rbB1iJKhndQAARyFQAAM91SAAAdsS4AAAUrlgAABgPYAAAA0s4A==
From: "RADEMAKERS Tanguy" <Tanguy.RADEMAKERS@swift.com>
To: "Ant Users List" <user@ant.apache.org>
X-OriginalArrivalTime: 25 Aug 2005 19:06:26.0014 (UTC)
 FILETIME=[174847E0:01C5A9A8]
Received-SPF: none
X-Flow-Control: Sendmail Flow Controller v1.4.0 besec551.swift.com
 j7PJ7kxc016892
X-MASF: 0.00%
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

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]=20
>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=20
>a specific
>database. What I want to do is somehow pass a parameter to the=20
>cleanDB.sql
>file so that the file can be generic.
>
>-----Original Message-----
>From: RADEMAKERS Tanguy [mailto:Tanguy.RADEMAKERS@swift.com]=20
>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=3D"com.microsoft.jdbc.sqlserver.SQLServerDriver"=20
>=20
>url=3D"jdbc:microsoft:sqlserver://localhost\myinstance:1433;Datab
>aseName=3D$
>{the.database.i.wanted.to.pass}"
>     userid=3D"sa"
>     password=3D"${the.password.of.the.database.i.wanted.to.pass}"
>     src=3D"cleanDB.sql"
>     />
>
>>-----Original Message-----
>>From: Moran Ben-David [mailto:moran@place-base.com]=20
>>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=20
>>that.  However,
>>one thing I can suggest is that instead of using the tasks'=20
>>"src" attribute,
>>you put the sql from cleanDB.sql in you're ant file as such:
>>
>>
>><sql driver=3D"com.microsoft.jdbc.sqlserver.SQLServerDriver"
>>url=3D"jdbc:microsoft:sqlserver://localhost\myinstance:1433;Datab
>>aseName=3Don_de
>>velop" userid=3D"sa" password=3D"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