Its been a while and seem this is still an issue even with latest stable release in railo and coldbox.
I am not using railo4.1.2.005 for testing this issue. Same issue apply with coldbox-3.8.1.
However when I drill down Active Entity which is extending VirtualEntityService.cfc
I have set the properties names to persistent=false;
property name=“entityName” type=“string” persistent=false;
property name=“datasource” type=“string” persistent=false;
And also the extended
coldbox.system.orm.hibernate.BaseORMService set all the properties to persistent=false;
/**
- The queryCacheRegion name property for all query caching produced in this service
*/
property name=“queryCacheRegion” type=“string” default=“ORMService.defaultCache” persistent=false;
/**
- The bit that tells the service to enable query caching, disabled by default
*/
property name=“useQueryCaching” type=“boolean” default=“false” persistent=false;
/**
- The bit that enables event handling via the ORM Event handler such as interceptions when new entities get created, etc, enabled by default.
*/
property name=“eventHandling” type=“boolean” default=“true” persistent=false;
/**
- The system ORM event handler to transmitt ORM events to
*/
property name=“ORMEventHandler” persistent=false;
/**
- The system ORM utility object
*/
property name=“ORM” persistent=false;
/**
- The bit that enables automatic hibernate transactions on all save, saveAll, update, delete methods
*/
property name=“useTransactions” type=“boolean” default=“true” persistent=false;
/**
- The bit that determines the default return value for list(), createCriteriaQuery() and executeQuery() as query or array
*/
property name=“defaultAsQuery” type=“boolean” default=“true” persistent=false;
/**
- All calculated and parsed dynamic finders’ and counters’ HQL will be stored here for easier execution
*/
property name=“HQLDynamicCache” type=“struct” persistent=false;
That seem to return the query set for the direct fields.
Remove persistent=false; from them and the " invalid parameter for query, ambiguous column name" comes back again.
What is the effect of persistent=false and could that be a way forward?
Please note I am not an expert in CFML programming and could be doing something totally wrong