test/cache/Durability/exp.test001.ksh.SunOS

   1 INSERTING 5 RECORDS IN TARGET DB
   2 +---------------------------------------+
   3 | Connected!                            |
   4 |                                       |
   5 | sql-statement                         |
   6 | help [tablename]                      |
   7 | quit                                  |
   8 |                                       |
   9 +---------------------------------------+
  10 SQL> +-----------+---------------------+-----------+
  11 | f1        | f2                  | f3        |
  12 +-----------+---------------------+-----------+
  13 | 1         | Bijay               | 10        |
  14 | 2         | Jiten               | 20        |
  15 | 3         | Praba               | 30        |
  16 | 4         | Kisor               | 40        |
  17 | 5         | Nihar               | 50        |
  18 +-----------+---------------------+-----------+
  19 SQLRowCount returns 5
  20 5 rows fetched
  21 SQL> CACHING THROUGH SITE1
  22 cachetable -U root -P manager -t t1
  23 Statement Executed
  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
  29 Server Killed
  30
  31 Durablity = TRUE
  32 Server Started
  33 Checking Durability
  34 Durability Works Fine
  35 +---------------------------------------+
  36 | Connected!                            |
  37 |                                       |
  38 | sql-statement                         |
  39 | help [tablename]                      |
  40 | quit                                  |
  41 |                                       |
  42 +---------------------------------------+
  43 SQL> SQLRowCount returns 0
  44 SQL> Statement Executed