Bulk Insert jdbc oracle

Thread view:

vnethirajan@gmail.com - 04 Jul 2007 11:09 GMT

Hey i am writing a java program which will insert more than 1,00,000
records in to oracle DB. i have read the records from a txt file , i
can read it using java and load one by one record into oracle using
executeUpdate(), but i want know is there any way by which i can
update the records in BULK/BatchUpdate ?

pls help me, thanx in advance.

rajan

Reply to this Message

Roedy Green - 04 Jul 2007 19:15 GMT

>Hey i am writing a java program which will insert more than 1,00,000
>records in to oracle DB. i have read the records from a txt file , i
>can read it using java and load one by one record into oracle using
>executeUpdate(), but i want know is there any way by which i can
>update the records in BULK/BatchUpdate ?

look for a utility to import CSV files.
--
Roedy Green Canadian Mind Products
The Java Glossary
http://mindprod.com

Reply to this Message

Thomas Kellerer - 04 Jul 2007 19:28 GMT

vnethirajan@gmail.com wrote on 04.07.2007 12:09:

> Hey i am writing a java program which will insert more than 1,00,000
> records in to oracle DB. i have read the records from a txt file , i
[quoted text clipped - 3 lines]
>
> pls help me, thanx in advance.

Why do you need to optimize it?
10000 rows is nothing.
I doubt you can see real performance gain (unless your import routine is
seriously flawed).

Do you have a real performance problem? Without any tweaks I can easily import
10000 rows (4 varchar columns) in about 2 seconds (using a PreparedStatement) on
my 2GHz Laptop.

If you really want to, you can have a look at PreparedStatement.addBatch() that
does give quite a performance boost with the newer (10g) Oracle drivers.

Thomas

Reply to this Message

Bulk Insert jdbc oracle

Free Magazines