XXXXX is not mapped - using ORM - org.hibernate.hql.ast.QuerySyntaxException

[Jason]

I keep getting errors that XXXX is not mapped.  I think I have everything setup correctly but I am obviously missing something.

I am trying to run this: 

var r = ormService.findIt("from StudentAssessment as a where a.StudentId = :StudentId", { studentId=Arguments.oStudent.geStudentId()} );

writeDump(r); abort;

The StudentAssessment object looks like:

component accessors="true" persistent="true" table="StudentAssessments" extends="coldbox.system.orm.hibernate.ActiveEntity" {

property name="StudentId" fieldtype="Id" ormtype="string" length="32" column="StudentId";

property name="AssessmentId" fieldtype="Id" ormtype="string" length="32" column="AssessmentId";

property name="Created" ormtype="timestamp";

}

And the error I continue to get is:

Application Execution Exception

Error Type: org.hibernate.hql.ast.QuerySyntaxException : 0
Error Messages: StudentAssessment is not mapped [from StudentAssessment as a where a.StudentId = :StudentId]

Any help on this would be much appreciated.  I have received this error before but found work arounds, but I kind of want to know what this is caused from.

Thanks!

[Andrew Scott]

ORM is case sensitive in HQL, check your case or spelling.

-- 

Regards,

Andrew Scott

WebSite: http://www.andyscott.id.au/

Google+: http://plus.google.com/113032480415921517411

--
--
You received this message because you are subscribed to the Google Groups "ColdBox Platform" group.
To post to this group, send email to col...@googlegroups.com
To unsubscribe from this group, send email to coldbox-u...@googlegroups.com
For more options, visit this group at http://groups-beta.google.com/group/coldbox
For News, visit http://blog.coldbox.org
For Documentation, visit http://wiki.coldbox.org
 
 
 

[Jason Fill]

Andrew,

Thanks for the prompt reply.  I have looked at case and spelling and I don't see anything odd - I even stripped things out a bit. I am now working with.

var r = ormService.findIt("from StudentAssessment" );

writeDump(r); abort;

Which I would think that would work without issues. 

I am able to do:

writeDump(entityNew("StudentAssessment"));

abort;

Which will give me a new entity.  But I still get that mapped error on the top sample.  Any other thoughts?

[Andrew Scott]

This is just a guess, but the ORM Service in ColdBox already sets the entity name.

-- 

Regards,

Andrew Scott

WebSite: http://www.andyscott.id.au/

Google+: http://plus.google.com/113032480415921517411