1 ----------------------------------README---------------------------------------
2 This contains an example program that demonstrates usage of jdbc interface through gateway on cached table.
7 It inserts 10 rows in cached table t1.
8 Select rows with f1 value 0 to 9 and displays
9 Update rows where f1 value is 0,2,4,6,8
10 Select rows with f1 value 0 to 9 and displays
11 Delete rows where f1 value is 0,3,6,9
12 Select rows with f1 value 0 to 9 and displays
17 Use the make command to compile
23 1. Set CACHE_TABLE=true in csql.conf file
25 2. Set the necessary enviroment variables using the setup script
26 under the csql root directory
30 3. Add an entry into csqlds.conf using csqlds tool mentioned as below.
32 $ csqlds -U <tdbusername> -P <password> -D <dsnname> -N <tdbname> -a
36 Note# tdb->target database
38 5. Create table t1 with two fields f1 integer(primary key) and f2 of length 10 string in mysql and cache the table.
42 6. Run the class file created by make
58 After update, listing tuples:
69 After delete, listing tuples: