The best way of creating .CSV files in java [duplicate]

This question already has answers here: CSV API for Java [closed] (10 answers) Closed 8 years ago.

I need to create MAX file for using it in Xerox 开发者_开发百科FreeFlow Process Manager. Most of the data is static, and is just poped out of the mssql database. (And it has nothing to do with Excel.) What is better in this situation to use? some tools like CSVReader/CSVWriter? Or is it more useful to handle it with the Apache Velocity?

---

Use the DB's builtin CSV generator. It's faster and more efficient than you can ever do in Java.

In SQL Server 2005 you can use SQLCMD for this:

SQLCMD -S MyInstance -E -d sales -i query_file.sql -o output_file.csv -s ,