Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: synchronize cache with DBMS changes?

  1. #1
    Join Date
    Jun 2003
    Posts
    5

    Default synchronize cache with DBMS changes?

    If there are changes made to the underlying DBMS, how to programmatically invalidate the cache?
    Thanks

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: synchronize cache with DBMS changes?

    Call
    mondrian.rolap.CachePool.instance().flush()
    I'd like to provide a better way of flushing the cache a in future release, in which case, this method may change/disappear.

  3. #3

    Default RE: synchronize cache with DBMS changes?

    hi,
    I have added such sentence in the page testpage.jsp.
    It works when I open this page everytime.
    But it failed to refresh the data in the table when I do it via a button.
    Since I wand to refresh the data anytime during doing olap analysis. If I re-open this page, everything is reset. So I put a button
    like this
    <wcf:imgbutton id="flushButton01" img="reload" tooltip= "toolb.reload" href="testpage.jsp?isFlush=yes" />
    and at the begin of this page, check the paramter isFlush, and flush the cache.But nothing changed..
    How can I solved this problem?
    is this because the query pape is included in to this testpage.jsp or ?
    thanks.
    Marty

  4. #4

    Default RE: synchronize cache with DBMS changes?

    This should work

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.