Home » SQL & PL/SQL » SQL & PL/SQL » Invalid Batch Value Exception...
Invalid Batch Value Exception... [message #172080] Sun, 14 May 2006 10:27 Go to next message
Messages: 16
Registered: December 2005
Junior Member
Hi Guys ,

I have been trying to insert more than 20.000 records at the same time into table

For Performance Tuning , So i decided to use Batch Update Something like below

PreparedStatement pstmt = value;

for(int i=0;i<100000;i++)
{ pstmt.setString(1,somevalue);

At The end of for loop i plan to execute all
using pstmt.executeUpdate()

But along the way i hit Invalid Batch Value exception.
i was told there is a limitation in Oracle Thin Driver to addBatch()
Is there any way for us to increase the batch value to highest possible value.


Re: Invalid Batch Value Exception... [message #189592 is a reply to message #172080] Fri, 25 August 2006 03:20 Go to previous messageGo to next message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member

Is it possible for You to do this in SQL instead of Java calls?
- This will always be the fastest.

Re: Invalid Batch Value Exception... [message #189606 is a reply to message #189592] Fri, 25 August 2006 04:11 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
I truly hope for the OP that his 20000 records will be inserted by now...
Previous Topic: Truncating the content of a file
Next Topic: what is the username/password for oracle 9i. like scott/tiger for personal oracle for win95
Goto Forum:

Current Time: Thu Oct 27 00:28:14 CDT 2016

Total time taken to generate the page: 0.05370 seconds