ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rglm <geethalakshmi.ramachand...@gmail.com>
Subject ANT SQL task output to csv file contains extra new line appended in end of file
Date Tue, 20 Nov 2012 19:30:50 GMT
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


Mime
View raw message