That was it! Thanx Mark!
_______________________ Scott Stroz http://www.boyzoid.com On Apr 13, 2009, at 5:46 PM, Mark Mandel wrote: > > Do you have a onetomany pointing at this object? > > It's the only thing I can think of. > > Mark > > On Tue, Apr 14, 2009 at 7:36 AM, Scott Stroz <sc...@boyzoid.com> > wrote: >> Can you guys take a look at this object definition and let mw know if >> anything jumps out at you that would cause a 'duplicate column' >> error when >> trying to save the object? >> <object name="eventcommittee" table="EVNT_COMMITTEE" >> decorator="com.usdaa.groupServices.event.eventCommittee"> >> <compositeid> >> <property name="id" /> >> <property name="groupUserId" /> >> <manytoone name="position" /> >> </compositeid> >> <property name="id" type="numeric" column="EVENT_NO" >> nullable="false" /> >> <property name="groupUserId" type="numeric" column="COMM_MEMBER_ID" >> nullable="false" /> >> <property name="active" type="string" column="ACTIVE_FLAG" >> nullable="false" >> /> >> <property name="lastModifiedDate" type="date" >> column="LAST_MODIFIED_DATE" >> nullable="true" /> >> <property name="lastModifiedBy" type="string" >> column="LAST_MODIFIED_BY" >> nullable="true" /> >> <property name="createdBy" type="string" column="CREATED_BY" >> nullable="true" >> /> >> <property name="createdDate" type="date" column="CREATED_DATE" >> nullable="true" /> >> >> <manytoone name="position"> >> <link to="committeeposition" column="COMM_ID" /> >> </manytoone> >> </object> >> The SQL statement that is trying to be run is: >> INSERT INTO EVNT_COMMITTEE( >> EVENT_NO, >> COMM_MEMBER_ID, >> ACTIVE_FLAG, >> LAST_MODIFIED_DATE, >> LAST_MODIFIED_BY, >> CREATED_BY, >> CREATED_DATE, >> COMM_ID, >> EVENT_NO) >> VALUES ( >> (param 1) , >> (param 2) , >> (param 3) , >> (param 4) , >> (param 5) , >> (param 6) , >> (param 7) , >> (param 8) , >> (param 9) ) >> And the really weird thing is that the value for 'param 1' is >> correct and >> the value for 'param 9' is NULL. So its seems as if Transfer is not >> only trying to insert the same column twice, but using different >> values. >> I am fairly certain I am doing something wrong, but I can't seem to >> find it. >> Thanx in advance. >> _______________________ >> Scott Stroz >> http://www.boyzoid.com >> >> >> >> >>> >> > > > > -- > E: mark.man...@gmail.com > 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 transfer-dev@googlegroups.com To unsubscribe from this group, send email to transfer-dev-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---