1 Reply Latest reply on Jun 2, 2014 4:26 PM by shawkins

    Cached results returned for Select query

    teiiduser

      Hello,

       

      I am updating blob data in a row and reading it back - all using Java. When I see the results in the table, the data is updated but, when I read them using select query, new results dont show up. Also, when I restart my server and run the select query again, the new data is shown. Is this a cache issue? How can I get around it?

       

      Thank you!

        • 1. Re: Cached results returned for Select query
          shawkins

          Unless you have enable result set caching, materialization, etc. Teiid should not proactively cache data beyond its intended scope.  Can you give an example of the selects and/or code involved?  Are you saying that the data values or the blob content doesn't seem to change or both?