• Post Reply Bookmark Topic Watch Topic
  • New Topic

size limit on batch update  RSS feed

 
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: 36660
475
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.
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!