Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

db2 batch update using java  RSS feed

Gouri Bargi
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!