Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes db2 batch update using java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "db2 batch update using java" Watch "db2 batch update using java" New topic

db2 batch update using java

Gouri Bargi
Ranch Hand

Joined: Sep 29, 2002
Posts: 47

I have hardly any experience in JDBC programming. I am developing an application where daily 200 to 300 records are to be uploaded to DB2 UDB version 8.1 database, at one go. I am thinking of using the batch updation methods provided in JDBC 2 - Statement.addBatch and Statement.executeBatch. Is it a good idea to have hundreds of insert queries in a batch? Is there some more efficient way of uploading this data through java? How much data can I send in one go? Where can I find information regarding usage of these methods?

- Gouri
I agree. Here's the link:
subject: db2 batch update using java
It's not a secret anymore!