ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pawanraj Sadhwani" <pawan...@elitecore.com>
Subject RE: SQL Command Output?
Date Fri, 14 May 2004 13:36:05 GMT
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


Mime
View raw message