I can say this is not a ColdBox issue, but I haven’t seen this sort of error before.
Application Execution ExceptionError Type: Application : [N/A]
Error Messages: coldfusion.runtime.UndefinedVariableException: Variable EXECUTEQUERY is undefined.
Root cause :org.hibernate.HibernateException: coldfusion.runtime.UndefinedVariableException: Variable EXECUTEQUERY is undefined.
Tag Context:
ID: CF_CFPAGE
LINE: 814
Template: D:\Projects\ColdFusion\ContentBox2.0Base\coldbox\system\orm\hibernate\BaseORMService.cfc
ID: CF_UDFMETHOD
LINE: 1472
Template: D:\Projects\ColdFusion\ContentBox2.0Base\coldbox\system\orm\hibernate\BaseORMService.cfc
ID: CF_UDFMETHOD
LINE: 800
Template: D:\Projects\ColdFusion\ContentBox2.0Base\coldbox\system\orm\hibernate\BaseORMService.cfc
The code is something like this.
for(var x = 1; x lte qCats.recordcount; x++) {
var props = {
left = qCats.left_id,
right = qCats.right_id,
name = qCats.name,
type = qCats.type,
description = qCats.desc
};
var cat = catService.new(properties=props);
catService.Save(cat);
}
What I think the error is, is there is a property in the Entity that is an M2O and it is being set to an empty string (assumption). If I replace the line with the save to EntitySave() I get the exact same error as well, so the only thing that is not listed above is the column called parent which is the M20 column.
When dumping the entity created, all but the parent is set and it just says empty string. This column property is defined as.
property name=“parent” column=“parentId” fieldtype=“many-to-one” CFC=“Category” fkcolumn=“parentId”;
Is there some trick needed here?
Any thoughts?