aspose file tools*
The moose likes JDBC and the fly likes Batch Update by passing Inparameters in JDBC Template Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Batch Update by passing Inparameters in JDBC Template" Watch "Batch Update by passing Inparameters in JDBC Template" New topic
Author

Batch Update by passing Inparameters in JDBC Template

Swaroop Reddy
Ranch Hand

Joined: Feb 25, 2009
Posts: 34
Hi All,
I am working on Spring with JDBC Templates,I need to delete a record from almost all 25 tables hence I thought of going for Batch updates,all 25 queries need caseNo as a parameter ,hence my problem is how to use batch update for deleting a record in these 25 tables by sending caseNo as inparameter

example of my query
1.Delete* from emp where id = ?
2.Delete * from organization where id = ?
and so on till 25 th query

Please provide me with example


Mr.Reddy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Batch Update by passing Inparameters in JDBC Template