Dynamic datasource definitions aren't uniquely cached with query caching


Recently we migrated a server from ACF. We have a number of queries that are dynamic datasources but cached for short amounts of time to alleviate recalls. We started noticing data switching for customers, and after a bunch of testing…Lucee doesn’t cache the datasource as well? For example, if we need to grab a same-content dataset from DB1, Select * From Customers Where Name = “Joe”, then another call comes in for the data in DB2…we’re presenting the data from DB1 because of the cache.

With ACF, it caches to datasource…so we get all of the Joe’s in DB1 when the call comes in for DB1, and DB2 etc…

is this a bug? Obviously it would seem that if you’re truly caching the data…SELECT from Datasource2 and getting data from datasource1 is incorrect…and a pretty big issue…at least for us…


Windows, mysql (souldnt matter)...Lucee


Michael Offner


John Egbert



Fix versions


Affects versions