File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Execute Batch(OutOfMemoryError)

 
Ravindra Deopurkar
Greenhorn
Posts: 2
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I am executing an rs.executeBatch() which has 200000 statements in it...
During execution it throws java.lang.OutOfMemory Exception.

How can i avoid this...

Thanks
 
Mani Ram
Ranch Hand
Posts: 1140
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
One way is to increase the heap memory. But trying to batch 200000 queries at one go, looks too much. Probably you should consider splitting up into smaller sizes.
For example, the following code snippet will batch upto 100 queries at a time.

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic