escalatelock.out

derby database source code.good for you.

-- it is blocked by the block_escalate_connection
insert into foo values (0, '0'), (0, '1'), (0, '2'), (0, '3'), (0, '4'), (0, '5'), (0, '6'), (0, '7'), (0, '8'), (0, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (10, '0'), (11, '1'), (12, '2'), (13, '3'), (14, '4'), (15, '5'), (16, '6'), (17, '7'), (18, '8'), (19, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (20, '0'), (21, '1'), (22, '2'), (23, '3'), (24, '4'), (25, '5'), (26, '6'), (27, '7'), (28, '8'), (29, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (30, '0'), (31, '1'), (32, '2'), (33, '3'), (34, '4'), (35, '5'), (36, '6'), (37, '7'), (38, '8'), (39, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (40, '0'), (41, '1'), (42, '2'), (43, '3'), (44, '4'), (45, '5'), (46, '6'), (47, '7'), (48, '8'), (49, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (50, '0'), (51, '1'), (52, '2'), (53, '3'), (54, '4'), (55, '5'), (56, '6'), (57, '7'), (58, '8'), (59, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (60, '0'), (61, '1'), (62, '2'), (63, '3'), (64, '4'), (65, '5'), (66, '6'), (67, '7'), (68, '8'), (69, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (70, '0'), (71, '1'), (72, '2'), (73, '3'), (74, '4'), (75, '5'), (76, '6'), (77, '7'), (78, '8'), (79, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (80, '0'), (81, '1'), (82, '2'), (83, '3'), (84, '4'), (85, '5'), (86, '6'), (87, '7'), (88, '8'), (89, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (90, '0'), (91, '1'), (92, '2'), (93, '3'), (94, '4'), (95, '5'), (96, '6'), (97, '7'), (98, '8'), (99, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> insert into foo values (100, '0'), (101, '1'), (102, '2'), (103, '3'), (104, '4'), (105, '5'), (106, '6'), (107, '7'), (108, '8'), (109, '9');
10 rows inserted/updated/deleted
ij(ESCALATE_CONNECTION)> -- check to make sure we have not escalated;
select * from lock_table order by tabname, type desc, mode, cnt, lockname;
USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
---------------------------------------------------------------------------
APP     |UserTran|TABLE   |1   |IX  |FOO         |Tablelock |GRANT|ACTIVE  
APP     |UserTran|TABLE   |11  |IX  |FOO         |Tablelock |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,10)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,100)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,101)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,102)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,103)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,104)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,105)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,106)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,107)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,108)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,109)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,11)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,110)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,111)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,112)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,113)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,114)   |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,12)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,13)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,14)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,15)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,16)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,17)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,18)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,19)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,20)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,21)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,22)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,23)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,24)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,25)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,26)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,27)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,28)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,29)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,30)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,31)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,32)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,33)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,34)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,35)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,36)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,37)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,38)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,39)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,40)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,41)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,42)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,43)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,44)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,45)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,46)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,47)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,48)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,49)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,50)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,51)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,52)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,53)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,54)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,55)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,56)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,57)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,58)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,59)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,60)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,61)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,62)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,63)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,64)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,65)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,66)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,67)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,68)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,69)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,70)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,71)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,72)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,73)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,74)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,75)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,76)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,77)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,78)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,79)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,80)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,81)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,82)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,83)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,84)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,85)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,86)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,87)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,88)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,89)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,9)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,90)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,91)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,92)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,93)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,94)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,95)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,96)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,97)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,98)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(1,99)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(2,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(2,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |FOO         |(2,8)     |GRANT|ACTIVE  
ij(ESCALATE_CONNECTION)> commit;
ij(ESCALATE_CONNECTION)> set connection block_escalate_connection;
ij(BLOCK_ESCALATE_CONNECTION)> commit;
ij(BLOCK_ESCALATE_CONNECTION)> -- see if all the data made it.
select a, data from foo;
A          |DATA      
----------------------
1          |blocker   
0          |0         
0          |1         
0          |2         
0          |3         
0          |4         
0          |5         
0          |6         
0          |7         
0          |8         
0          |9         
10         |0         
11         |1         
12         |2         
13         |3         
14         |4         
15         |5         
16         |6         
17         |7         
18         |8         
19         |9         
20         |0         
21         |1         
22         |2         
23         |3         
24         |4         
25         |5         
26         |6         
27         |7         
28         |8         
29         |9         
30         |0         
31         |1         
32         |2         
33         |3         
34         |4         
35         |5         
36         |6         
37         |7         
38         |8         
39         |9         
40         |0         
41         |1         
42         |2         
43         |3         
44         |4         
45         |5         
46         |6         
47         |7         
48         |8         
49         |9         
50         |0         
51         |1         
52         |2         
53         |3         
54         |4         
55         |5         
56         |6         
57         |7         
58         |8         
59         |9         
60         |0         
61         |1         
62         |2         
63         |3         
64         |4         
65         |5         
66         |6         
67         |7         
68         |8         
69         |9         
70         |0         
71         |1         
72         |2         
73         |3         
74         |4         
75         |5         
76         |6         
77         |7         
78         |8         
79         |9         
80         |0         
81         |1         
82         |2         
83         |3         
84         |4         
85         |5         
86         |6         
87         |7         
88         |8         
89         |9         
90         |0         
91         |1         
92         |2         
93         |3         
94         |4         
95         |5         
96         |6         
97         |7         
98         |8         
99         |9         
100        |0         
101        |1         
102        |2         
103        |3         
104        |4         
105        |5         
106        |6         
107        |7         
108        |8         
109        |9         
ij(BLOCK_ESCALATE_CONNECTION)>