aspose file tools*
The moose likes Spring and the fly likes Multiple Items to Iterate in on jbctemplate batchupdate. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Spring
Bookmark "Multiple Items to Iterate in on jbctemplate batchupdate." Watch "Multiple Items to Iterate in on jbctemplate batchupdate." New topic
Author

Multiple Items to Iterate in on jbctemplate batchupdate.

Eshwar Prasad
Ranch Hand

Joined: Mar 21, 2008
Posts: 202

Hello - I have requirement to execute and insert around 2000 records. Hence I choose to execute through jdbctemplate batch template.

Problem: This is to insert insurance plans for my customer. As a requirement I have many Insurances and it has many plans. So getBatchSize() returns number of insurance available and while setting the values i will get Insurance plan object and insert the data. However, with this line getInsuranceList().get(i).getInsPlan(), I get only one plan.

Please advice, If i have to put all this method in a loop to run available insurances so that i can return the size of the plans available. Is this the correct approach to loop the method.

Eshwar Prasad
Ranch Hand

Joined: Mar 21, 2008
Posts: 202
Adding below information would give some additional information to help.

Here getInsPlanList size is 10 and however getInsuranceList().size() is 2, I want to iterate and insert the record details of getInsPlanList.size().

So in this case do I need to loop this logic to getInsuranceList().size() so that my getBatchSize() can return of getInsPlanList.size().




Bill Gorder
Bartender

Joined: Mar 07, 2010
Posts: 1649
    
    7

A batch operation by definition is executing the same SQL statement many times with different parameters. This does not sound like it's the case here. You could do it possibly in 2 batches, but you are only talking about 10 rows I would not even bother with batches.


[How To Ask Questions][Read before you PM me]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Multiple Items to Iterate in on jbctemplate batchupdate.