• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

size limit on batch update

 
mukund kulkarni
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I ma using DB2 database . I have to insert 10,000 rows in an temp table .
I am using st.addBatch() and st.executebatch() after adding 10,000 rows.

Is there any limit on the data we can add in a batch. any size limit ?

Please let me know .

Thanks
-Mukund
 
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
Mukund,
If there is a limit, it would depend on your database driver (and available memory.)
 
Adeel Ansari
Ranch Hand
Posts: 2874
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If having problem with size limit then you can increase the no of open cursors of your DB. It may solve your problem.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic