Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Batch Update by passing Inparameters in JDBC Template

 
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic