You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ant.apache.org by rglm <ge...@gmail.com> on 2012/11/20 20:30:50 UTC
ANT SQL task output to csv file contains extra new line appended in
end of file
Hi,
Iam sending the sql output to a csv file. Notice that there is an extra new
line added at the end of the csv file
(try opening in notepad++)
<sql driver="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@${ora.server}:1521/${ora.db}"
userid="${ora.user}"
password="${ora.passwd}"
expandproperties="true"
showheaders="true"
showtrailers="false"
print="true"
output="${local.outdir}/Actual.csv">
select d.name
from
emp e
inner join DOCUMENTS d
on d.source_id = e.source_id
where e.id!=7
and trunc(e.creation_date) =
trunc(to_date(${creation_date},'DD-Mon-YY'))
and trunc(d.document_date) =
trunc(to_date(${creation_date},'DD-Mon-YY'))
;
</sql>
This is impacting because we have to compare the csv file with a original
doc and at this step because of the extra line, the program is failing. Can
this be fixed?
Thanks!
--
View this message in context: http://ant.1045680.n5.nabble.com/ANT-SQL-task-output-to-csv-file-contains-extra-new-line-appended-in-end-of-file-tp5713686.html
Sent from the Ant - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org