Another chapter in the “tiny CSV library keeps on growing” saga… opencsv 1.5 has gone out the door. The new version includes changes to CSVWriter to allow for easily exporting a SQL table or query to a CVS file.
The new method writeAll(ResultSet rs, boolean includeHeaders)
makes exporting SQL to CSV a snap! Does the hard work of coercing Bits, CLOBs, Timestamps and whatnot to Strings on the way out.
Thanks to Sean Sullivan for the good work in adding this feature.