Create CSV file from resultset in Java

[simon_s_li]

Hi,

I need to be able to read data from a table (ResultSet) and create a
CSV file.

Once the CSV file is created I want to save the CSV into a SQL Server
database.

Can anyone help me with this.

Any sample code would be great.

Regards
Simon

 

[JK]

Hi,

Resultset cannot be saved directly as it is. It has to be read and
store in a Array or Collection. This Array has to be stored as CSV
file.

If requirement is data transfer from one database to another database,
ex. oracle to SQL Server, it is better to go for Hibernate.

Shrik's

 

[Martin Gregorie]

Hi,

Resultset cannot be saved directly as it is. It has to be read and
store in a Array or Collection. This Array has to be stored as CSV
file.

If requirement is data transfer from one database to another database,
ex. oracle to SQL Server, it is better to go for Hibernate.

Might be better yet to avoid programming and do the job with the
database unloader and loader programs, which generally write and read
CSV files.