File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC batch statement

 
Sub swamy
Ranch Hand
Posts: 121
  • 0
  • 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: 3896
16
Eclipse IDE Flex Google Web Toolkit
  • 0
  • 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