You can only have one relationship per foreign key - otherwise how is Transfer meant to know which relationship to save on?
Mark On Tue, Sep 22, 2009 at 2:57 AM, Daniel <[email protected]> wrote: > > I have two table entites which have a one-to-many relationship to an > image table. Both are used to attach several pictures to them. Both > using the same reference field 'img_ref_uuid' in the image table. > > It works well for ONE one-to-many realtionship. When I use iSECOND > one-to-many realtioshiop and try to save it, I get an error. > > "Error Type: Database : 42000 > Error Messages: Error Executing Database Query. > Column 'img_ref_uuid' specified twice" > > in variables.transfer.save(imgBean); > > The funny thing IS: It's DOES SAVE correctly to the database. It get > the images as an array in the object whe I read the the object with > transfer... > > > Since it seems to work properly by saving it to the database in the > background, It's strange to get this error message. Maybe I miss here > something or is it a bug? > > <object name="branch" table="branch" > decorator="com.baehler.branch.branch"> > <id name="branch_id" type="UUID" generate="true" /> > <property name="branch_label" type="string" column="branch_label" > nullable="true" /> > ... > <onetomany name="branchimage"> > <link to="asset.image" column="img_ref_uuid"/> > <collection type="array"> > <order property="img_created"/> > </collection> > </onetomany> > </object> > > <object name="product" table="product" > decorator="com.baehler.product.product"> > <id name="prd_id" column="prd_id" type="UUID" > generate="true" /> > <property name="prd_name" type="string" > column="prd_bezeichnung" > nullable="false" /> > .... > <onetomany name="productimage"> > <link to="asset.image" column="img_ref_uuid"/> > <collection type="array"> > <order property="img_created"/> > </collection> > </onetomany> > </object> > > <object name="image" table="image" > decorator="com.baehler.asset.image"> > <id name="img_id" type="UUID" generate="true"/> > <property name="img_src" type="string" column="img_src" > nullable="false" /> > <property name="img_height" type="numeric" column="img_height" > nullable="true" /> > <property name="img_width" type="numeric" column="img_width" > nullable="true" /> > <property name="img_size" type="numeric" column="img_size" > nullable="true" /> > <property name="img_type" type="string" column="img_type" > nullable="false" /> > <property name="img_caption" type="string" column="img_caption" > nullable="true" /> > <property name="img_created" type="date" column="img_created" > ignore- > insert="true" ignore-update="true"/> > <property name="img_updated" type="date" column="img_updated" > nullable="true" /> > <property name="img_tn" type="string" column="img_tn" > nullable="true" /> > </object> > > Daniel > > > -- E: [email protected] T: http://www.twitter.com/neurotic W: www.compoundtheory.com --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
