ant-user mailing list archives

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

Pawan


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


Mime
View raw message