commons-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alan Stewart (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CSV-138) CSVPrinter.printRecords(ResultSet) skips first row with SQLServer
Date Tue, 28 Oct 2014 09:15:34 GMT

    [ https://issues.apache.org/jira/browse/CSV-138?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14186624#comment-14186624
] 

Alan Stewart commented on CSV-138:
----------------------------------

Forgot about the jtds driver. I used to be the lead of Spring Roo and recall that it was compatible
with both SQLServer and sybase. I'll try tomorrow.

> CSVPrinter.printRecords(ResultSet) skips first row with SQLServer
> -----------------------------------------------------------------
>
>                 Key: CSV-138
>                 URL: https://issues.apache.org/jira/browse/CSV-138
>             Project: Commons CSV
>          Issue Type: Bug
>          Components: Printer
>    Affects Versions: 1.0
>            Reporter: Alan Stewart
>
> WIth SQLServer's 2012 jdbc driver 4.0, when I call CSVPrinter#printRecords with a java.sql.ResultSet,
the first row is not printed. It appears that the line
> {code}
> final int columnCount = resultSet.getMetaData().getColumnCount();
> {code} 
> positions the cursor on the first row and then when
> {code}
>  while (resultSet.next()) { ...
> {code}
> is called, the 2nd row onwards is what is getting outputted.
> As a workaround, I used :
> {code}
> final int columnCount = rs.getMetaData().getColumnCount();
> do {
>     for (int i = 1; i <= columnCount; i++) {
>         csvPrinter.print(rs.getString(i));
>     }
>     csvPrinter.println();
> } while (rs.next());
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message