1. Getting Started with Cache Guide
  2. Create Static Asynchronous WriteThrough Cache Groups
  3. Create Static Asynchronous WriteThrough Cache Group
  4. Verify Static AWT Cache Group

Verify Static AWT Cache Group

Since this is a static AWT cache group, all changes made on the TimesTen database are automatically propagated to the Oracle database.

The following example inserts a new row, deletes an existing row, updates an existing row in the customers cache table, and commits the changes on the TimesTen database.


Description of writequicks7.eps follows
Description of the illustration writequicks7.eps

Connect to ttIsql as sales, then: 

Command> INSERT INTO customers VALUES (342, "West", "Jane Stone");
1 row created.
Command> DELETE FROM customers WHERE cust_num=122;
1 row deleted.
Command> UPDATE customers SET region="East" WHERE cust_num=663; 
1 row updated.
Command> COMMIT;
Command> exit;
Disconnecting...
Done.

You can verify this by connecting to the Oracle database. As the Oracle database schema user sales, use SQL*Plus to query the contents of the customer table: 

SQL> SELECT * FROM customers;
cust_num  region  name 
-----------------------------------------
342       West    Jane Stone
663       East    Pat Reed

Since this is a quick guide on how to create a static AWT cache group, see Cache Concepts and Asynchronous WriteThrough (AWT) Cache Group in the Oracle TimesTen In-Memory Database Cache Guide for a more thorough understanding of the concepts behind and the options for a static AWT cache group.