Reputation: 367
I have a simple web application built on Servlet and simple DAO classes to handle database (MySQL) operations.
My servlet may receive multiple requests at the same time. How will the database handle multiple requests?
Suppose I have an "item" database table. Multiple requests may update or delete from the "item" table at the same time.
Is it required to use Transactions and lock the table explicitly during update and delete operations in the DAO class, or will concurrency be handled by the database automatically?
Upvotes: 0
Views: 90