Databases
StackOverflow2013
Postsdbo
POCF ORM Many-To-Many with StructKeyColumn same as PK for related object
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCF ORM Many-To-Many with StructKeyColumn same as PK for related object
    text
    copied!<p>Background: I'm attempting to change a Transfer ORM based app to a Hibernate ORM app as transparently as possible.</p> <p>I'm having problems with ManyToManys with a collection type of Struct, when the primary key of the related table is the struct key</p> <p>Transfer would let you do this: </p> <pre><code>&lt;manytomany name="Timezone" table="RegionTimezones" lazy="false"&gt; &lt;link column="RegionID" to="regions.Region"/&gt; &lt;link column="TimezoneID" to="regions.Timezone"/&gt; &lt;collection type="struct"&gt; &lt;key property="TimezoneID"/&gt; &lt;/collection&gt; &lt;/manytomany&gt; </code></pre> <p></p> <p>The equivalent Hibernate/CFProperty tag is:</p> <pre><code>&lt;cfproperty name="Timezones" fieldtype="many-to-many" linktable="RegionTimezones" cfc="Timezone" singularName="Timezone" FKColumn="TimezoneID" inversejoincolumn="RegionID" type="struct" structkeytype="string" structkeycolumn="TimezoneID" /&gt; </code></pre> <p>However this errors with "Repeated column in mapping for collection: Region.Timezones column: TimezoneID"</p> <p>It appears that structkeycolumn cannot be the PK of another table. </p> <p>My problem is that I have lots of existing calling code that takes advantage of Transfer's way of doing things.</p> <p>Does anyone know of any workarounds for this? I have herd people talking of a One-To-Many with link table, but can't find any references of how to do this in CF?</p> <p>Thanks, Dave</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload