This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
Consider Paul's rocket mass heater.
subject: db2 batch update using java
Similar Threads
JDBC 2.0 And DB2
Performance problem in jdbc
Want to do data transfer from DB2 on OS390 to Oracle database on solaris
DB2 access from browser using JDBC
java.sql.SQLException: No suitable driver