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