What is the difference between an explicit and an implicit lock in database?

database-locking
DayDayUp picture DayDayUp · Sep 8, 2010 · Viewed 18.3k times · Source

What is the difference between an explicit and an implicit lock in database?

Answer

Sharjeel Aziz picture Sharjeel Aziz · Sep 8, 2010

Implicit locks are generally placed by the DBMS automatically. Most DBMS allow the developer or the application to issue locks which are referred to as explicit locks.

Related questions

Will Oracle lock the whole table while performing a DML statement or just the row

When i try to insert/update something in a db table, will Oracle lock the whole table or only the row being inserted/updated? Is this something that can be controlled through external configuration?

Read More
SQLITE_BUSY The database file is locked (database is locked) in wicket

I am doing a project in wicket How to solve the problem. I came across such a message: WicketMessage: Can't instantiate page using constructor public itucs.blg361.g03.HomePage() Root cause: java.lang.UnsupportedOperationException: [SQLITE_BUSY] The database file is …

Read More
Delphi: Database is locked (SQLite)

I am facing two problems... (1) When I try to write to a Database (SQLite) by using Delphi XE6, I always get the Database is locked error message. I am certain that I close the database everytime I access it by …

Read More