what is difference between optimistic and pessimistic locking

Home Answers Viewqa JDBC what is difference between optimistic and pessimistic locking

Nagendran

what is difference between optimistic and pessimistic locking
1 Answer(s) a year and a month ago
Posted in : JDBC

what is difference between optimistic and pessimistic locking

View Answers

May 9, 2012 at 5:20 PM

Pessimistic locking is where a record or page is locked immediately when the lock is requested.While Optimistic locking is where a record or page is only locked when the changes made to that record are updated.

The Optimistic locking situation is only appropriate when there is less chance of someone needing to access the record while it is locked; otherwise it cannot be certain that the update will succeed because the attempt to update the record will fail if another user updates the record first. With pessimistic locking it is guaranteed that the record will be updated.

consider optimistic versus pessimistic approaches
consider optimistic versus pessimistic approaches Why should I consider optimistic versus pessimistic approaches to database updates

optimistic concurrency
optimistic concurrency What is optimistic concurrency

jdbc
what is difference between optimistic and pessimistic locking what is difference between optimistic and pessimistic locking Pessimistic... is requested.While Optimistic locking is where a record or page is only locked when

What is the difference between the >> and >>> operators?
What is the difference between the >> and >>> operators? hi, What is the difference between the >> and >>> operators? Thanks

what is the difference between extends and implements
what is the difference between extends and implements difference between extends and implements

What is the difference between PHP4 and PHP5?
What is the difference between PHP4 and PHP5? What is the difference between PHP4 and PHP5

What is the difference between $message and $$message?
What is the difference between $message and $$message? What is the difference between $message and $$message

what is the Difference between weblogic and jboss?
what is the Difference between weblogic and jboss? what is the Difference between weblogic and jboss

what is the difference between pop and oop
what is the difference between pop and oop what is the difference between pop and oop

What is the difference between hibernate and spring
What is the difference between hibernate and spring Hi, What is the difference between hibernate and spring. Thanks

What is difference between a PROCEDURE & FUNCTION ?
What is difference between a PROCEDURE & FUNCTION ? What is difference between a PROCEDURE & FUNCTION

What is the difference between a constructor and a method?
What is the difference between a constructor and a method? Hi, What is the difference between a constructor and a method? Hi, I have found a good link of Java program related to difference between constructor

What is difference between the java and javascript?
What is difference between the java and javascript? What is the difference beteen the java and javascript? Hello Friend, Read Here Thanks

difference
difference what's the difference between mysql and sql

What is the difference between a JDK and a JVM?
What is the difference between a JDK and a JVM? Hi, What is the difference between a JDK and a JVM? Thanks, Hi, JDK is stand... to compile your source files using a JVM. For more difference between JDK and JVM

What is difference between Path and Classpath?
What is difference between Path and Classpath? hi What is difference between Path and Classpath? thanks Hi, The Path & Classpath are used for operating system level environment variales. We mostly use Path

Difference
Difference What Is the difference between JDK & SDK

What is difference between TRUNCATE & DELETE
What is difference between TRUNCATE & DELETE What is difference between TRUNCATE & DELETE? Hi, The DELETE command is used to remove rows from a table. A WHERE clause can be used to only remove some rows

Difference between DispatchAction and LookupDispatchAction
Difference between DispatchAction and LookupDispatchAction What is the Difference between DispatchAction and LookupDispatchAction

difference between SessionState and ViewState
difference between SessionState and ViewState What is the difference between SessionState and ViewState

difference between ForwardAction and IncludeAction
difference between ForwardAction and IncludeAction What is the difference between ForwardAction and IncludeAction

Difference between struts and JSF
Difference between struts and JSF What is the difference between struts and JSF

What is difference between the java and javascript?
What is difference between the java and javascript? What is the difference beteen the java and javascript? Hello Friend, Difference: 1) Java is a Object Oriented programming language developed by Sun Microsystems

What is the difference between ereg_replace() and eregi_replace()?
What is the difference between ereg_replace() and eregi_replace()? What is the difference between eregreplace() and eregireplace

What is the difference between the functions unlink and unset?
What is the difference between the functions unlink and unset? What is the difference between the functions unlink and unset

What are the difference between abstract class and interface?
What are the difference between abstract class and interface? What are the difference between abstract class and interface

What’s the difference between include and require?
What?s the difference between include and require? What?s the difference between include and require

what is the difference between distributed application and web application?
what is the difference between distributed application and web application? what is the difference between distributed application and web application

What’s the difference between load() and get()?
What?s the difference between load() and get()? Hi, What?s the difference between load() and get()? thanks

What is difference between singleton and prototype bean?
What is difference between singleton and prototype bean? Hi, What is difference between singleton and prototype bean? Thanks

difference
difference what is the difference between the JDBC-ODBC bridge, the Native-API-Partly-Java driver, and the JDBC-Net-All-Java Driver is the placement of the database access libraries Please visit the following link

Difference between 3d and 4d
Difference between 3d and 4d what is the difference between 3d and 4d

difference between varchar & varchar2?
difference between varchar & varchar2? What is the difference between varchar & varchar2

what is difference between objectan primitive? - Java Beginners
what is difference between objectan primitive? whatis difference between object and primitive

what is the difference between productList==null and productList.size()==0
what is the difference between productList==null and productList.size()==0 what is the difference between productList==null and productList.size()==0? here productList is of type LIST

What is the difference between the Boolean & operator and the && operator?
What is the difference between the Boolean & operator and the && operator? Hello, What is the difference between the Boolean & operator and the && operator? thanks

What are difference between Bean Factory and Application Context ?
What are difference between Bean Factory and Application Context ? Hi, What are difference between Bean Factory and Application Context

Difference between Mysql and SQL
Difference between Mysql and SQL hello, What is the difference between Mysql and SQL?? hii, SQL is structural quary language but mysql is database package

what is the difference between the eclipse and myeclipse - IDE Questions
what is the difference between the eclipse and myeclipse what is the difference between the eclipse and myeclipse Hi Friend, Difference: Eclipse is an IDE or platform for developing, whereas MyEclipse

Difference between SCJP Exams
Difference between SCJP Exams What is the differences between SCJP 5 (310 - 055) exam and SCJP 6 (310 - 065) exam??? Thank You In Adv

What is the difference between component and tag in JSF?
What is the difference between component and tag in JSF? Please let me know,becaus i am new to jsf and am confusing

Difference between JSP and Servlets
Difference between JSP and Servlets What is the difference between JSP and Servlets ? JSP is used mainly for presentation only. A JSP can only be HttpServlet that means the only supported protocol in JSP is HTTP

Difference between request.getRequestDispatcher() and context.getRequestDispatcher()
Difference between request.getRequestDispatcher() and context.getRequestDispatcher() What is the difference in using request.getRequestDispatcher() and context.getRequestDispatcher()? request.getRequestDispatcher

What is the difference between UNION and UNION ALL in SQL?
What is the difference between UNION and UNION ALL in SQL? What is the difference between UNION and UNION ALL in SQL? Hi, UNION is an SQL keyword used to merge the results of two or more tables using a Select

Difference between forward and sendRedirect
Difference between forward and sendRedirect What's the difference between forward and sendRedirect? RequestDispatcher.forward() and HttpServletResponse.sendRedirect() are the two methods available for URL redirecting

Difference between ServletContext and ServletConfig
Difference between ServletContext and ServletConfig What is the difference between ServletContext and ServletConfig? ServletContext :Defines a set of methods that a servlet uses to communicate with its servlet

Difference between translate and replace
Difference between translate and replace hiii, What is the difference between translate and replace? hello, Replace replace every instence of character with character sting by the given charator of string

What is the difference between GET and POST method?
What is the difference between GET and POST method? In PHP, both GET... there is a lots of difference between the both. Can anyone please explain...;difference between get and post method in PHP POST method is more secure than GET

What is the difference between IN and BETWEEN, that are used inside a WHERE clause?
What is the difference between IN and BETWEEN, that are used inside a WHERE clause? What is the difference between IN and BETWEEN, that are used inside a WHERE clause? Hi, The BETWEEN clause is used to fetch a range

Latest
Frameworks
Category