This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) 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
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!