TimesTen : Why can I see the row in the 2nd cache grid node?
edited Jan 10, 2014 7:29AM in Gateways, Oracle Lite, Oracle DB Mob. Server, TimesTen (MOSC) 2 commentsAnswered ✓
Hi,
I got 2 TT caches against the same Oracle backend server. I've configured them to be dynamic awt global cache group. When I insert the row in 1 cache. I can verify that the row is also inserted in Oracle. But when I select the query from the 2nd cache, I don't see the row.
This is my cache group setup:
create dynamic asynchronous writethrough global cache group mycache from tobecache (
F1 NUMBER(38) NOT NULL,
F2 NUMBER(38) NOT NULL,
F3 CHAR(5 BYTE),
primary key (F1, F2));
insert into tobecache values (1,1,'a');
on the 2nd cache, I did this select with no row return:
I got 2 TT caches against the same Oracle backend server. I've configured them to be dynamic awt global cache group. When I insert the row in 1 cache. I can verify that the row is also inserted in Oracle. But when I select the query from the 2nd cache, I don't see the row.
This is my cache group setup:
create dynamic asynchronous writethrough global cache group mycache from tobecache (
F1 NUMBER(38) NOT NULL,
F2 NUMBER(38) NOT NULL,
F3 CHAR(5 BYTE),
primary key (F1, F2));
insert into tobecache values (1,1,'a');
on the 2nd cache, I did this select with no row return:
0