Best way to insert 10000 rows in JDBC

[Senthil Kumar Sekar]

Hi All,
Can anyone tel me the best way to perform 10000 rows insert or bulk insert in JDBC?
Say,I have a file with 10k records which i need to insert to DB after manipulation.

Thanks.

Regards
Senthil Kumar Sekar

[Jeanne Boyarsky]

There are two alternatives:
1) prepared statement batch updates (in smaller groups)
2) writing to a flat file and importing at command line

I'd probably go with #1 because I would want to batch the manipulation of the 10K records anyway.

[xsunil kumar]

Use Batch update for this

[chris webster]

If you're using Oracle and can provide your data in a CSV file, then using Oracle external tables is probably the quickest way to do this.