Java / JDBC
What are the locking systems in JDBC?
There are 2 types of locking in JDBC by which we can handle multiple users trying to update the same record.
Optimistic locking locks the record only when update happens. Optimistic locking does not use exclusive locks when reading or selecting the record.
Pessimistic Locking locks the record as soon as it selects the row to update. This locking strategy guarantees the changes are made safely and consistently.
More Related questions...