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?
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?