• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem facing with executebatch function

 
James Basller
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

In my application I am inserting records in the database table. It works fine for minimum records like 50,000 records in batch. But I am facing problem when I add 4,00,000 records in one batch and then call executeBatch method it only inserts 58324 records in my database table.

So, please help me to resolve this problem!!!

Thanks,
James
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
James,
Have you tried inserting 58325 in one batch. If that also inserts 58324, it could be you are hitting a maximum. Personally, I wouldn't keep my batch over 10,000 anyway - just because it requires so much memory in each roundtrip.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic