1 Reply Latest reply on Jun 22, 2015 7:55 AM by Steven Hawkins

    How to use admin api of an embedded server remotely ?

    Raj Kumar Newbie

      Hi Team,

       

      I am novice to Teiid and don't understand entirely how it works. We are using one of the application that uses Teiid as embedded app and provides us interface to talk to multiple data sources.

       

      Lately we saw the metadata refresh doesn't happen in the application even when database has been changed. So, we believe that Teiid might be caching something and we want to clear the cache. I couldn't find any document that states how to use admin api of ambedded server remotely.

       

      Please note we have added the transport and we are able to expose the JDBC port connection to embedded server but not sure how can we clear the cache and see the cache contents?

       

      Also, is it possible to see all the VDBs deployed on remote embedded server by any chance? Instead of knowing before hand to connect to one of them for querying it.

       

      Any quick response will be very helpful. It is for production environment and we don't want to restart the servers every now and then.

       

      PS: We are also thinking to switch off teiid cache completely but not sure what values will suffice? If you can help here too. Current Settings we have -

       

      <property name="useDisk" value="true"/>

      <property name="processorBatchSize" value="256"/>

      <property name="maxOpenFiles" value="64"/>

      <property name="maxFileSize" value="2048"/>

      <property name="maxProcessingKb" value="-1"/>

      <property name="maxReserveKb" value="-1"/>

      <property name="maxBufferSpace" value="51200"/>

      <property name="memoryBufferSpace" value="-1"/>

      <property name="inlineLobs" value="true"/>

      <property name="maxStorageObjectSize" value="8388608"/>

      <property name="memoryBufferOffHeap" value="false"/>

       

      Thanks,
      Raj

        • 1. Re: How to use admin api of an embedded server remotely ?
          Steven Hawkins Master

          > Lately we saw the metadata refresh doesn't happen in the application even when database has been changed.

           

          A running vdb uses a snapshot of the source metadata - it does not change at runtime.  A vdb restart, redeploy, or a new vdb version is needed to fetch or define new source metadata.

           

          > So, we believe that Teiid might be caching something and we want to clear the cache.

           

          In embedded there is no cache that spans a vdb or server restart.

           

          > I couldn't find any document that states how to use admin api of ambedded server remotely.

           

          There currently is no remote admin option for Teiid embedded.

           

          > Also, is it possible to see all the VDBs deployed on remote embedded server by any chance? Instead of knowing before hand to connect to one of them for querying it.

           

          Not with embedded.  The eap based distribution does provide a remote admin interface though.

           

          > PS: We are also thinking to switch off teiid cache completely but not sure what values will suffice?

           

          No, those settings are for the disk/memory utilization of the engine.