[CSV-138] CSVPrinter.printRecords(ResultSet) skips first row with SQLServer

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.0
• Component/s: Printer
• Assignee: Unassigned
• Reporter: Alan Stewart
• Created: 28/Oct/14 02:16
• Updated: 29/Oct/14 03:24
• Resolved: 28/Oct/14 11:47

Description

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

final int columnCount = resultSet.getMetaData().getColumnCount();

positions the cursor on the first row and then when

 while (resultSet.next()) { ...

is called, the 2nd row onwards is what is getting outputted.

As a workaround, I used :

final int columnCount = rs.getMetaData().getColumnCount();
do {
    for (int i = 1; i <= columnCount; i++) {
        csvPrinter.print(rs.getString(i));
    }
    csvPrinter.println();
} while (rs.next());