Dump SQL tables to CSV using OpenCSV

Question

I am trying to write the data from ResultSet to csv file using Netbeans and OpenCSV. I added OpenCSV library:

import au.com.bytecode.opencsv.*;

...

 try {   CSVWriter writer = new CSVWriter(new FileWriter("C:\\test2.csv"), ',');
                        writer.writeAll(rs,includeHeaders);

                     }

                     catch (Exception e){}
                }

However I get the error:

cannot find symbol
  symbol:   variable includeHeaders
  location: class DBConnect

Am I missing some other imports?

I haven't as I assumed this was imported variable as it is on the basic openCSV tutorial. Any suggestions? — GuyWhoReadsStockoverflow, Jan 04 '13 at 14:40

score 1 · Accepted Answer · answered Jan 04 '13 at 14:42

1

CSVWriter.writeAll(rs,includeHeaders) expects a ResultSet and a boolean as an argument. you need to declare includeHeaders.

or simply pass the boolean values like

     writer.writeAll(rs,true);
     writer.writeAll(rs,false);

answered Jan 04 '13 at 14:42

PermGenError

45,977
8
87
106

Thanks. That's working but the file I get is empty? Database works fine. – GuyWhoReadsStockoverflow Jan 04 '13 at 14:45
I will but need to wait 3 min. Any suggestions for empty csv file? I check and rs contains valid data. – GuyWhoReadsStockoverflow Jan 04 '13 at 14:49

Dump SQL tables to CSV using OpenCSV

1 Answers1