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



Home Answers Viewqa JDBC what are different type of locks

Have Programming Question? Ask it here!
 
 
 


Nagendran
what are different type of locks
1 Answer(s)      2 years and 4 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 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 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 different environments to configure hibernate?
What are different environments to configure hibernate?  Hi, What are different environments to configure hibernate? Thanks
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
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 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 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?  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
What is the Best Jewelry for a Specific Type of Outfit?
What is the Best Jewelry for a Specific Type of Outfit? The best jewelry... to let the fashion trends tell you what to wear. For example, a movie premiere.... For work you will choose a more relaxed type of the best jewelry because you don't
JavaScript type of Operator
JavaScript type of Operator       The JavaScript type of operator returns the datatype of an operand. You can see in the given example that we have used different variables
different kinds of actions in Struts
different kinds of actions in Struts  What are the different kinds of actions in Struts
different JDBC drivers available
different JDBC drivers available  What are the different JDBC drivers available
type casting
type casting  int n=20; n=sizeof((char)(float)n); what is n value
Different JRE
Different JRE  Java is platform independent. The why different JRE's there for differen operating systems
Different between getRequestParameterMap() and getRequestParameterValuesMap()
Different between getRequestParameterMap() and getRequestParameterValuesMap()  What is the different between getRequestParameterMap() and getRequestParameterValuesMap
Type casting
Type casting  how to type cast a string value to byte array
Different tables present in MySQL
Different tables present in MySQL  What are the different tables present in MySQL? Which type of table is generated when we are creating a table in the following syntax: create table employee(eno int(2),ename varchar(10))?  
fastest type of JDBC driver
fastest type of JDBC driver  What is the fastest type of JDBC driver
Document Type Definition
Document Type Definition  What is Document Type Definition
Java type casting
Java type casting  What is Downcasting
type casting
List (object type) <Object> totalList(int pi){ try{ Query q...type casting  <--bean class-->method calllist is of object type...){ return null; } how to type cast object type to entity type
type mismatch
type mismatch  Statement s= con.createStatement(); this line gives error of "type mismatch" I am using eclips nd new to servlet nd JDBC, Please help me, Thank you
data type
data type  which data type is used to store video file in mysql databse
data type
data type  what are the date types in the java and vb.net? what is the difference between java and vb.net?   Hi Friend, java data types are: byte short int long float double char boolean
type casting purpose
type casting purpose  what is type casting , could u explain with practical example
Fastest type of JDBC Driver
Fastest type of JDBC Driver  hello, What is the fastest type of JDBC driver?   hii, Type 4 is the fastest JDBC driver
What is Linux?
What is Linux?        ...; Linux is a free Unix-type operating system originally developed by Linus... of GNU worked together to develop what we now take for granted, a derivative
 

 

 

DMCA.com