Skip to main content
A
Anonymous
August 31, 2009
Answered

Coldfusion ORM Problem

  • August 31, 2009
  • 1 reply
  • 785 views

Hello,

I'm having some trouble with coldfusion orm. Here's my scenario:

I have 3 main components: component1, component2 and component3. The first component has relationships with the two others, and everything works fine.

The problem is when I try to do the following in component1:


<cfproperty name="component2id" type="numeric">

<cfproperty name="component3id" type="numeric">


<cfproperty name="component2" fieldtype="many-to-one" cfc"Component2" FKColumn="component2id">

<cfproperty name="component3" fieldtype="many-to-one" cfc"Component2" FKColumn="component3id">


If I have a property that references the same column that the FKColumn of another property, coldfusion returns a blank record (not an empty array, cfdump is completelly blank) and the server's exception.log says that a stack overflow happened. Is there something wrong with my code? I can't remove the component2id and component3id properties because I have to filter my entityload function to load an entity with those specific ids.

This topic has been closed for replies.
Correct answer rupesh_kumar

This mapping is not allowed as there are two mapping definition for the same column "component2id" and "component3id". You can just kep the relation property and then use ORMExecuteQuery for doing the filtering. The query would look like this

ORMExecuteQuery("From Component1 comp where comp.component2.id=? and comp.component3.id=?")

1 reply

R
Adobe Employee
rupesh_kumarCorrect answer
Adobe Employee
September 3, 2009

This mapping is not allowed as there are two mapping definition for the same column "component2id" and "component3id". You can just kep the relation property and then use ORMExecuteQuery for doing the filtering. The query would look like this

ORMExecuteQuery("From Component1 comp where comp.component2.id=? and comp.component3.id=?")

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices