Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

handling multiple database requests and updates

 
manish ahuja
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

How to handle multiple concurrent database requests/updates when using JDBC with servlets?
Rgrds
 
Paul Anilprem
Enthuware Software Support
Ranch Hand
Posts: 3817
10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you give any example situation that you that thinking of? There are many different ways. Which one to choose really depends on what the business logic is.
 
manish ahuja
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Anil
Thanks for teh response. What i am curious to know is say if i update a database table from the servlet code & i have many simultaneous requests to that servlet then n number of updates will be fired.
At the database level the first update will lock the table till the time it has not completed with the update i.e (commit or rollback)
And as such the subsequent servlets requesting the update will be waiting.
I would like to know how to handle such kind of situation.
You mentioned in your post there are many ways to deal with such kind of situation.
If possible can you post them here or give pointers to documents where i can find them
Rgrds
 
manish ahuja
Ranch Hand
Posts: 312
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Anil
Waiting for your response

Rgrds
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic