ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From RADEMAKERS Tanguy <Tanguy.RADEMAK...@swift.com>
Subject RE: SQL Command Output?
Date Mon, 17 May 2004 13:33:01 GMT
I thnk that's a database specific thing: try "set nocount on" at the head of your script for
oracle.

/t 

>-----Original Message-----
>From: Pawanraj Sadhwani [mailto:pawanraj@elitecore.com] 
>Sent: Saturday, May 15, 2004 11:29 AM
>To: 'Ant Users List'
>Subject: RE: SQL Command Output?
>
>Hi All,
>
>Just one more question. With every operation on the database, 
>the output file includes the header and the trailer 
>( saying 0 rows affected and so on)
>
>While there is an option to suppress header.. is there a way 
>to supress trailer also?
>
>Pawan
>
>-----Original Message-----
>From: Pawanraj Sadhwani [mailto:pawanraj@elitecore.com]
>Sent: Friday, May 14, 2004 7:06 PM
>To: 'Ant Users List'
>Subject: RE: SQL Command Output?
>
>
>thanx rhino.. works nicely
>
>-----Original Message-----
>From: Rhino [mailto:rhino1@sympatico.ca]
>Sent: Friday, May 14, 2004 6:59 PM
>To: Ant Users List; pawanraj@elitecore.com
>Subject: Re: SQL Command Output?
>
>
>Add this to the parameters for your sql task: print="yes".
>
>Without this parameter, your output file is created but is empty.
>
>Rhino
>
>----- Original Message ----- 
>From: "Pawanraj Sadhwani" <pawanraj@elitecore.com>
>To: "'Ant Users List'" <user@ant.apache.org>
>Sent: Friday, May 14, 2004 8:19 AM
>Subject: SQL Command Output?
>
>
>I am using the sql task of ant. working with ant 1.6.1
>
>the task is
>
><target name="sql-test">
>  <sql driver="oracle.jdbc.driver.OracleDriver"
>url="jdbc:oracle:thin:@192.168.1.66:1521:ora92"
>       userid="scott" password="tiger"  autocommit="true"
>       src="mycommands.sql" output="sql-result.txt" append="true"
>       classpathref="lib.class.path" />
></target>
>
>The build is successful, and commands are successfully 
>executed too. The
>problem is that no output is shown on sql-result.txt.
>
>My mycommands.sql is as below
>
>-- this is a comment
>select * from staff;
>
>-- now an insert
>insert into staff values('USR0000005', 'pawan', 'STF0000007');
>
>What am i doing wrong?
>
>
>
>---------------------------------------------------------------------
>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