How to batchUpdate in JDBC?
Posted on 2006-05-23
This is the simple scenario.
I have an array of objects (few thousands) with the instance variables EmailId, Code, SignoutDate, TimeStamp
I want to get the values from these objects and update just one table, EMAIL table.
EMAIL table has: EmailID, SignOutDate, SignInDate, FailureCount
I have to look at the Code, and based on this, update the EMAIL table.
If I see the Code says the email was Undeliverable, I will need to Increment the FailureCount from 0 to 1.
If I see the Code says the email wants to signout, I will need to put the SignOutDate in the EMAIL table.
Since the EMAIL table will have millions of records, WHAT ARE MY OPTIONS ON USING JDBC BATCH UPDATE?
I MAY NOT WANT TO USE STORED PROCEDURES?
Could you let me know how to go about that?