rollforwardrecovery.out

derby database source code.good for you.

27         
28         
29         
30         
101        
102        
103        
104        
105        
106        
107        
108        
109        
110        
111        
112        
113        
114        
115        
116        
117        
118        
119        
120        
121        
122        
123        
124        
125        
126        
127        
128        
129        
130        
1000       
1001       
ij> select * from t4;
C1         
-----------
101        
102        
103        
104        
105        
106        
107        
108        
109        
110        
111        
112        
113        
114        
115        
116        
117        
118        
119        
120        
121        
122        
123        
124        
125        
126        
127        
128        
129        
130        
1001       
ij> autocommit off;
ij> insert into t3 (c1) values(100), 99, 999;
3 rows inserted/updated/deleted
ij> insert into t3 (c1) values(0), (-1);
2 rows inserted/updated/deleted
ij> --let's do some updates .
update t4 set c1 = c1 -1;
31 rows inserted/updated/deleted
ij> update t3 set c1 = c1 + 1;
67 rows inserted/updated/deleted
ij> update t3 set c2 = 'rollforward';
67 rows inserted/updated/deleted
ij> commit;
ij> delete from t2;
5 rows inserted/updated/deleted
ij> delete from t2;
0 rows inserted/updated/deleted
ij> delete from t4;
31 rows inserted/updated/deleted
ij> delete from t3;
67 rows inserted/updated/deleted
ij> rollback;
ij> connect 'jdbc:derby:wombat;shutdown=true';
ERROR 08006: Database 'wombat' shutdown.
ij> disconnect;
ij> connect 'jdbc:derby:wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat';
ij> select * from t1;
A          
-----------
1          
2          
3          
4          
5          
ij> select * from t2;
B          
-----------
1          
2          
3          
4          
5          
ij> select * from t3;
C1         |C2                  
--------------------------------
2          |rollforward         
3          |rollforward         
4          |rollforward         
5          |rollforward         
6          |rollforward         
7          |rollforward         
8          |rollforward         
9          |rollforward         
10         |rollforward         
11         |rollforward         
12         |rollforward         
13         |rollforward         
14         |rollforward         
15         |rollforward         
16         |rollforward         
17         |rollforward         
18         |rollforward         
19         |rollforward         
20         |rollforward         
21         |rollforward         
22         |rollforward         
23         |rollforward         
24         |rollforward         
25         |rollforward         
26         |rollforward         
27         |rollforward         
28         |rollforward         
29         |rollforward         
30         |rollforward         
31         |rollforward         
102        |rollforward         
103        |rollforward         
104        |rollforward         
105        |rollforward         
106        |rollforward         
107        |rollforward         
108        |rollforward         
109        |rollforward         
110        |rollforward         
111        |rollforward