Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC what are different type of locks
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Nagendran
what are different type of locks
1 Answer(s)      2 years and 6 months ago
Posted in : JDBC


what are different type of locks


Advertisement
View Answers

May 9, 2012 at 5:03 PM


Types of locks in JDBC:

Row and Key Locks:: It is useful when updating the rows (update, insert or delete operations), as they increase concurrency.

Page Locks: It locks the page when the transaction updates or inserts or deletes rows or keys. The database server locks the entire page that contains the row. The lock is made only once by database server, even more rows are updated. This lock is suggested in the situation where large number of rows is to be changed at once.

Table Locks: Utilizing table locks is efficient when a query accesses most of the tables of a table. These are of two types:

a) Shared lock: One shared lock is placed by the database server, which prevents other to perform any update operations.

b) Exclusive lock: One exclusive lock is placed by the database server, irrespective of the number of the rows that are updated.

Database Lock: In order to prevent the read or update access from other transactions when the database is open, the database lock is used.



Related Tutorials/Questions & Answers:
What is an object's lock and which object's have locks?
What is an object's lock and which object's have locks?   Hi, What is an object's lock and which object's have locks? Thanks
different type input in java
different type input in java  hiiiii... get input different different type like as DataInputStream,Scanner i want to get source code of these all type of input method. thank   Java Read through DataInputStream: import
Advertisements
What is mime type in HTML
What is mime type in HTML  what is mime type in html? is it different in new HTML5
What is mime type in HTML
What is mime type in HTML  what is mime type in html? is it different in new HTML5
What are the different types of AutoProxying?
What are the different types of AutoProxying?  Hi, What are the different types of AutoProxying? Thanks
What are different normalization forms?
What are different normalization forms?  What are different normalization forms?   Hi, 1NF: Eliminate Repeating Groups- Make a separate table for each set of related attributes, and give each table a primary key. Each
What are the different functions in sorting an array?
What are the different functions in sorting an array?  What are the different functions in sorting an array
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?
WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP?  WHAT ARE THE DIFFERENT TYPES OF ERRORS IN PHP
What are the different modules in Spring framework?
What are the different modules in Spring framework?  Hi, What are the different modules in Spring framework? Thanks
What are different environments to configure hibernate?
What are different environments to configure hibernate?  Hi, What are different environments to configure hibernate? Thanks
with a different number, what’s the problem
with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
with a different number, what’s the problem
with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
What type of inheritance that php supports?
What type of inheritance that php supports?  What type of inheritance that php supports
What is the return type of the main method?
What is the return type of the main method?  hi, What is the return type of the main method? thanks   Hi, In the java programming... to have a method named main in at least one class. The following is what must
What are the different types of property and class mappings?
What are the different types of property and class mappings?  Hi, What are the different types of property and class mappings? thanks
what are different M.I.S reporting tools basically used?
what are different M.I.S reporting tools basically used?  what are different M.I.S reporting tools basically used
what are different M.I.S reporting tools basically used?
what are different M.I.S reporting tools basically used?  write a java pgm using keyword super,static nd final
What is a join and explain different types of joins
What is a join and explain different types of joins  What is a join and explain different types of joins?   Hi, Joins are used in queries to explain how different tables are related. Joins also let you select data from
What are constructors ? explain different types of constructor with example
What are constructors ? explain different types of constructor with example  Hi, What are constructors ? explain different types of constructor... To know more related to What are constructors with examples
what type of computer memory is used for temporary storage
what type of computer memory is used for temporary storage  what type of computer memory is used for temporary storage   RAM or Random Access Memory is a computer memory that is used for temporary storage of data. RAM
Conversion from string data type into different data types.
Conversion from string data type into different data types.  string str="World id Beutifull"; char chr[20]; char* chrctr ; Qustion is -How to store the 'str' value in 'chr' and 'chrctr'? int abc; sprintf(abc ,"%s",str
JDOM Attribute Example, How to convert value of attribute in different data type
JDOM Attribute Example, How to convert value of attribute in different data type In this tutorial, we will see how to retrieve the value of an attribute in different data type like int, float, boolean etc with the help of JDOM
keeps coming up with a different number, what’s the problem.
keeps coming up with a different number, what?s the problem.  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
keeps coming up with a different number, what’s the problem
keeps coming up with a different number, what?s the problem  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem
What type of headers have to be added in the mail function to attach a file?
What type of headers have to be added in the mail function to attach a file?  What type of headers have to be added in the mail function to attach a file
What are the different types of interfaces in java? - Java Interview Questions
What are the different types of interfaces in java?  Hi, Is it correct question.I faced this in one interview. If yes can u tell me please. thanks chandu
What is the return type of execute mehtod in jdbc - Java Beginners
What is the return type of execute mehtod in jdbc  Hi Deepak, u posted this answer. " Whatever it may be the statement type, like.... " String s="raja" , Here return type of s is string
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what’s the problem?
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem?  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what’s the problem?
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s the problem?  I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, what?s
JAVA what is different between static block and public static void main(String a[]) method
JAVA what is different between static block and public static void main(String a[]) method  what is different between static block and public static void main(String a[]) method,we execute method without main method(by static
type casting
type casting  what is type casting
Advertisements
 

 

 

DMCA.com