Win a copy of Mastering Non-Functional Requirements this week in the Design 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: 4085
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!