Return-Path: 
 <user-return-64199-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 17949 invoked from network); 12 Mar 2008 19:31:33 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 12 Mar 2008 19:31:33 -0000
Received: (qmail 12109 invoked by uid 500); 12 Mar 2008 19:31:27 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 12070 invoked by uid 500); 12 Mar 2008 19:31:27 -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 12059 invoked by uid 99); 12 Mar 2008 19:31:27 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Mar 2008 12:31:27 -0700
X-ASF-Spam-Status: No, hits=-6.0 required=10.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_HI,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of Sumit.Srivastava@ubs.com
 designates 151.191.175.213 as permitted sender)
Received: from [151.191.175.213] (HELO dmz-vsgate2.stm.ibb.ubs.com)
 (151.191.175.213)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Mar 2008 19:30:47 +0000
Received: from dmz-vsgate2.stm.ibb.ubs.com (localhost [127.0.0.1])
	by dmz-vsgate2.stm.ibb.ubs.com (Postfix) with ESMTP id 491A756B0D
	for <user@ant.apache.org>; Wed, 12 Mar 2008 15:30:56 -0400 (EDT)
Received: by dmz-vsgate2.stm.ibb.ubs.com (Postfix, from userid 103)
	id C0A1256A0B; Wed, 12 Mar 2008 15:30:55 -0400 (EDT)
Received: from sstm6034pmh.stm.swissbank.com (unknown [10.246.160.34])
	by dmz-vsgate2.stm.ibb.ubs.com (Postfix) with ESMTP id 3A88956B49
	for <user@ant.apache.org>; Wed, 12 Mar 2008 15:30:55 -0400 (EDT)
Received: from sstm6034pmh.stm.swissbank.com (localhost [127.0.0.1])
	by postfix.imss70 (Postfix) with ESMTP id 25FFE98
	for <user@ant.apache.org>; Wed, 12 Mar 2008 15:30:55 -0400 (EDT)
Received: from NSTM0840PAP.ubsw.net (nstm0840pap.stm.swissbank.com
 [151.191.75.200])
	by sstm6034pmh.stm.swissbank.com (Postfix) with ESMTP id 22AE968
	for <user@ant.apache.org>; Wed, 12 Mar 2008 15:30:55 -0400 (EDT)
Received: from NSTMC102PEX1.ubsw.net ([151.191.77.245]) by
 NSTM0840PAP.ubsw.net with Microsoft SMTPSVC(6.0.3790.1830);
	 Wed, 12 Mar 2008 15:30:55 -0400
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: SQL scripts in ANT
Date: Wed, 12 Mar 2008 15:30:52 -0400
Message-ID: <F51FBA4E1F3BAC47A4F26FA05203690D11660118@NSTMC102PEX1.ubsw.net>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: SQL scripts in ANT
Thread-Index: AciEd5VuldcKypyAR0G6DSS/dGmMMQ==
From: <Sumit.Srivastava@ubs.com>
To: <user@ant.apache.org>
X-OriginalArrivalTime: 12 Mar 2008 19:30:55.0050 (UTC)
 FILETIME=[9710E2A0:01C88477]
Content-Type: multipart/mixed; boundary="retimiled-emim-mijooneldraneldeen"
X-UBS-Disclaimer: Version $Revision: 1.29 (postfix edition)$
X-Virus-Checked: Checked by ClamAV on apache.org

--retimiled-emim-mijooneldraneldeen
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C88477.96247FAE"

This is a multi-part message in MIME format.

------_=_NextPart_001_01C88477.96247FAE
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable


Hi Experts..

	I need to run multiple SQL scripts thru ANT...Following is my
code snippet :


			<sql
			    driver=3D"oracle.jdbc.driver.OracleDriver"
			    url=3D"jdbc:oracle:thin:@server.com:DATABASE"
			    userid=3D"${uid}"
			    password=3D"${passwd}"
			    print=3D"yes"
			    onerror=3D"continue"
=20
output=3D"${build.output.root}/output/sql/outputfile.txt"
    			    >			=09
    			    	<classpath>
			        <pathelement
location=3D"/path/to/jdbc.jar"/>
			 	</classpath>
    			    <transaction
src=3D"${PLSQL_ROOT}\DropTables.sql" />
			    <transaction
src=3D"${PLSQL_ROOT}\createTables.sql" />
				   =20
			 </sql>


I tried putting all the *.sql scripts inside one and call that like=20

<src=3D"${PLSQL_ROOT}\MasterScript.sql" />

MasterScript.sql contains following :

@DropTables

@createTables

But , ANT is not able to recognise "@" exits..


Is there a way to accomplish this ?? This would be lot easier to manage,
as we can comment/uncomment depending on the scenario instead of
changing the build script everytime.


Please suggest something..

Thanks,
Sumit

------_=_NextPart_001_01C88477.96247FAE
Content-Type: text/html;
	charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7653.21">
<TITLE>SQL scripts in ANT</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi Experts..</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">I need to run multiple SQL scripts thru =
ANT&#8230;Following is my code snippet :</FONT>
</P>
<BR>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&lt;sql</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp; =
driver=3D&quot;oracle.jdbc.driver.OracleDriver&quot;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp; =
url=3D&quot;jdbc:oracle:thin:@server.com:DATABASE&quot;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp; userid=3D&quot;${uid}&quot;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp; =
password=3D&quot;${passwd}&quot;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp; print=3D&quot;yes&quot;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp; onerror=3D&quot;continue&quot;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
output=3D&quot;${build.output.root}/output/sql/outputfile.txt&quot;</FONT=
>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&gt;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp; &lt;classpath&gt;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt;pathelement location=3D&quot;/path/to/jdbc.jar&quot;/&gt;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =
FACE=3D"Arial"> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt;/classpath&gt;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; =
&lt;transaction src=3D&quot;${PLSQL_ROOT}\DropTables.sql&quot; =
/&gt;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp; &lt;transaction =
src=3D&quot;${PLSQL_ROOT}\createTables.sql&quot; /&gt;</FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">&nbsp;&nbsp;&nbsp; </FONT>

<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT SIZE=3D2 =
FACE=3D"Arial"> &lt;/sql&gt;</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">I tried putting all the *.sql scripts =
inside one and call that like </FONT>
</P>

<P><FONT SIZE=3D2 =
FACE=3D"Arial">&lt;src=3D&quot;${PLSQL_ROOT}\MasterScript.sql&quot; =
/&gt;</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">MasterScript.sql contains following =
:</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">@DropTables</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">@createTables</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">But , ANT is not able to recognise =
&quot;@&quot; exits..</FONT>
</P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">Is there a way to accomplish this ?? =
This would be lot easier to manage, as we can comment/uncomment =
depending on the scenario instead of changing the build script =
everytime.</FONT></P>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">Please suggest something..</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Sumit</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C88477.96247FAE--

--retimiled-emim-mijooneldraneldeen
Content-Type: text/plain; charset=us-ascii; name="disclaim.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Content-Description: Legal Disclaimer

Visit our website at http://www.ubs.com

This message contains confidential information and is intended only 
for the individual named.  If you are not the named addressee you 
should not disseminate, distribute or copy this e-mail.  Please 
notify the sender immediately by e-mail if you have received this 
e-mail by mistake and delete this e-mail from your system.
	
E-mails are not encrypted and cannot be guaranteed to be secure or 
error-free as information could be intercepted, corrupted, lost, 
destroyed, arrive late or incomplete, or contain viruses.  The sender 
therefore does not accept liability for any errors or omissions in the 
contents of this message which arise as a result of e-mail transmission.  
If verification is required please request a hard-copy version.  This 
message is provided for informational purposes and should not be 
construed as a solicitation or offer to buy or sell any securities 
or related financial instruments.


--retimiled-emim-mijooneldraneldeen
Content-Type: text/plain; charset=us-ascii

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