ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pawanraj Sadhwani" <>
Subject RE: SQL Command Output?
Date Fri, 14 May 2004 13:36:05 GMT
thanx rhino.. works nicely

-----Original Message-----
From: Rhino []
Sent: Friday, May 14, 2004 6:59 PM
To: Ant Users List;
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.


----- Original Message ----- 
From: "Pawanraj Sadhwani" <>
To: "'Ant Users List'" <>
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"
       userid="scott" password="tiger"  autocommit="true"
       src="mycommands.sql" output="sql-result.txt" append="true"
       classpathref="lib.class.path" />

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:
For additional commands, e-mail:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message