Forums Register Login

handling multiple database requests and updates

+Pie Number of slices to send: Send
Hi

How to handle multiple concurrent database requests/updates when using JDBC with servlets?
Rgrds
+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
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
+Pie Number of slices to send: Send
Hi Anil
Waiting for your response

Rgrds
I will suppress my every urge. But not this shameless plug:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 680 times.
Similar Threads
ResultSet is getting closed..
Closing database connections properly?
guide me
Connection Pooling
database access & request dipatcher
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 08:52:26.