Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC batch statement  RSS feed

 
Sub swamy
Ranch Hand
Posts: 121
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is there any upper limit to the batch statement size that we use in JDBC? Can we set the batch statement size to as high as 100/200 ?

Or is it dependent on the driver/RDBMS combination that we use ?
 
Scott Selikoff
author
Bartender
Posts: 4084
21
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
100/200 doesn't seem particular high to me. I believe most of the way batch actually works is database driver dependent. For example, the driver could ignore the limit and send the data sooner.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!