Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC batch statement

 
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
Saloon Keeper
Posts: 4014
18
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