we have updated the default cache settings to -1 in our odata war file. we have a select query in our view table. We added a ttl cache in the view but it is not taking effect.

Below are the two select queries i tried :

1. /*+ cache(ttl:60000) */ select col from t

2. /* cache(tl:60000) */ select col from t

After applying the cache in select query, i hit the odata call once, then change col from table t in database then try the odata call again, i get the new data instead of cached data.

Please let me know if what need to be done to apply ttl cache for one view table.

Thanks,

Prashanthi.