This week's book giveaway is in the Android forum.
We're giving away four copies of Head First Android and have Dawn & David Griffiths on-line!
See this thread for details.
The moose likes JDBC and Relational Databases 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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Batch Update by passing Inparameters in JDBC Template
 
It's not a secret anymore!