EDS Cache Hint TTL doesn't seem to be working

Solution Verified - Updated -

Issue

  • It looks like the ttl set on the cache hint for resultset caching is not working as expected. If you have a look at the logs, I have purposely left it for 3 minutes apart and I was expecting the latter query will go off fetching the data from the database but it did not.
SQL:
/*+ cache ttl:60000 */ select * from WH_SOURCES_D


LOGS:
2014-01-06 17:14:45,362 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1)      START USER COMMAND:     startTime=2014-01-06 17:14:45.362       requestID=6TTYNuMJLR3A.8      txID=null       sessionID=6TTYNuMJLR3A  applicationName=JDBC    principal=app-DAL@teiid-security        vdbName=MV      vdbVersion=1 sql=/*+ cache ttl:60000 */ select * from WH_SOURCES_D
2014-01-06 17:14:46,291 DEBUG [org.teiid.COMMAND_LOG] (Worker6_QueryProcessorQueue1019)         END USER COMMAND:       endTime=2014-01-06 17:14:46.291 requestID=6TTYNuMJLR3A.8      txID=null       sessionID=6TTYNuMJLR3A  principal=app-DAL@teiid-security        vdbName=MV      vdbVersion=1    finalRowCount=-1
2014-01-06 17:17:58,615 DEBUG [org.teiid.COMMAND_LOG] (New I/O server worker #1-1)      START USER COMMAND:     startTime=2014-01-06 17:17:58.615       requestID=6TTYNuMJLR3A.9      txID=null       sessionID=6TTYNuMJLR3A  applicationName=JDBC    principal=app-DAL@teiid-security        vdbName=MV      vdbVersion=1 sql=/*+ cache ttl:60000 */ select * from WH_SOURCES_D
2014-01-06 17:17:59,695 DEBUG [org.teiid.COMMAND_LOG] (Worker7_QueryProcessorQueue1051)         END USER COMMAND:       endTime=2014-01-06 17:17:59.695 requestID=6TTYNuMJLR3A.9      txID=null       sessionID=6TTYNuMJLR3A  principal=app-DAL@teiid-security        vdbName=MV      vdbVersion=1    finalRowCount=-1

Environment

  • Red Hat JBoss Data Services (EDS) 5.3.1

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.