Create CSV file from resultset in Java

Thread view:

simon_s_li@hotmail.com - 28 Nov 2006 10:07 GMT

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

Reply to this Message

JK - 30 Nov 2006 03:52 GMT

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

> Hi,
>
[quoted text clipped - 10 lines]
> Regards
> Simon

Reply to this Message

Martin Gregorie - 30 Nov 2006 21:17 GMT

> Hi,
>
[quoted text clipped - 4 lines]
> 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.

Signature

martin@ | Martin Gregorie
gregorie. | Essex, UK
org |

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...