File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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!