Execute the following script and the error will occur:
CREATE TABLE Country (
Code CHAR(3) PRIMARY KEY,
Name VARCHAR,
Continent VARCHAR,
Region VARCHAR,
SurfaceArea DECIMAL(10,2),
IndepYear SMALLINT,
Population INT,
LifeExpectancy DECIMAL(3,1),
GNP DECIMAL(10,2),
GNPOld DECIMA
Gurmehar,
"I need to understand when we mean LOCK, is this lock is acquired on entire
Cache or on record we are trying to update .
Please clarify ." - Ignite uses record level locking.
Jay,
I would avoid entire cache locks due to performance reasons, but if it's
really necessary, lock object cache
