1 INSERTING 5 RECORDS IN TARGET DB
2 +---------------------------------------+
9 +---------------------------------------+
10 SQL> +-----------+---------------------+-----------+
12 +-----------+---------------------+-----------+
18 +-----------+---------------------+-----------+
21 SQL> CACHING THROUGH SITE1
22 cachetable -U root -P manager -t t1
24 Statement Executed: Rows Affected = 1
25 Statement Executed: Rows Affected = 1
26 Statement Executed: Rows Affected = 1
27 Statement Executed: Rows Affected = 1
28 Statement Executed: Rows Affected = 1
35 INSERTING 5 RECORDS IN CACHED TABLE t1 AT CSQL
36 Statement Executed: Rows Affected = 1
37 Statement Executed: Rows Affected = 1
38 Statement Executed: Rows Affected = 1
39 Statement Executed: Rows Affected = 1
40 Statement Executed: Rows Affected = 1
41 INSERTING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
42 Statement Executed: Rows Affected = 1
43 Statement Executed: Rows Affected = 1
44 Statement Executed: Rows Affected = 1
45 Statement Executed: Rows Affected = 1
46 Statement Executed: Rows Affected = 1
53 UPDATING 5 RECORDS IN CACHED TABLE t1 AT CSQL
54 Statement Executed: Rows Affected = 5
55 UPDATING 5 RECORDS AT NON CACHED TABLE t2 AT CSQL
56 Statement Executed: Rows Affected = 5
63 DELETING 7 RECORDS IN CACHED TABLE t1 AT CSQL
64 Statement Executed: Rows Affected = 7
65 DELETING 7 RECORDS AT NON CACHED TABLE t2 AT CSQL
66 Statement Executed: Rows Affected = 7
73 +---------------------------------------+
80 +---------------------------------------+
81 SQL> SQLRowCount returns 0
82 SQL> Statement Executed