Hi ,
I have installed timesten Release. TimesTen 11.2.2.7.4 . I have keep passthrough setting to 1.
I have created AWT cache group . The table on which i have created AWT cache group .Table which is in oracle having Hash Partition .
Query configured from Application :
Example :
Update table set column1 = 0 ,column2 =1 where column x = ? and column y = ?
If i am pointing my application to oracle then query fired from oracle is
Update table set column1 = 0 ,column2 =1 where column x = ? and column y = ?
Query fired from Timesten data source
Update table set column1 = 0 ,column2 =1 where column x = ?
Now my question is : Column Y is partition column , is this only reason that timesten is skipping And clause in update query ("And Column y= ?" )
Please guide us in such case. if possible please provide example of how to cache partition table in timesten.
Thanks ,