Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: how to modify the SCHEMA on the fly ????

  1. #1

    Default how to modify the SCHEMA on the fly ????

    Hi,
    i am testing some schemas over my DATABASE. When i modify the schema i see that MONDRIAN doesn't know that the SCHEMA has changed. So i tried to do a mondrian.rolap.rolapSchema.flush() in the JSP before sending the MDX request but no effect !!!
    i tried mondrian.rolap.CachePool.instance.flush() to flush the cache but no effects too !!!
    So i am obliged to restart TOMCAT ?
    Is there another way to tell TOMCAT that the Schema changed ?
    eric

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

    Default RE: how to modify the SCHEMA on the fly ????

    Schemas are cached based upon their URL. There is no way to remove them from the cache. Hence the behavior you are seeing.
    One workaround is to generate the schema to a file with a different name.
    Another is to programmatically build a schema rather than generate an XML file.
    Another is to put the entire XML schema inline in the connect string, using the CatalogContent property. See mondrian.rolap.RolapConnectionProperties.

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.