handling multiple database requests and updates

[manish ahuja]

Hi

How to handle multiple concurrent database requests/updates when using JDBC with servlets?
Rgrds

[Paul Anilprem]

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]

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]

Hi Anil
Waiting for your response

Rgrds