Win a copy of Android Programming: The Big Nerd Ranch Guide this week in the Android forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Batch Update by passing Inparameters in JDBC Template  RSS feed

Swaroop Reddy
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!