Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
JDBC batch statement
Joined: Oct 02, 2002
Oct 26, 2006 00:12:00
Is there any upper limit to the batch statement size that we use in
? 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 ?
Joined: Oct 23, 2005
Oct 26, 2006 00:55:00
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.
[OCA 8 Book]
I agree. Here's the link:
subject: JDBC batch statement
Why Batch Update Support Only One Single PreparedStatement
JDBC, Create Stored Procedure, delimiters
transaction size and commit
read large CSV file and update the database
Taking an argument from a file into SQL prep statement
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015