I haven't tried it,
But could it be this simple?

<class name="Item" table="ITEM">
    ...
    <set name="bids" inverse="true">
        <key column="ITEM_ID"/>
        <one-to-many class="Bid"/>
    </set>
</class>

That is to say, simply declare which column is the one to be joined,
with the <key /> element?

Gavin


On May 19, 4:34 pm, Gavin Baumanis <beauecli...@gmail.com> wrote:
> Hi Steve,
>
> Am I missing something?
> Can you not just assign a FKey declaraton and a one-to-many
> relationship (or whatever relationship type is required)?
>
> Or is it that the columns in question are not PK columns? and they are
> just normal columns in the database?
> And if this is so,
> Is there a different column that is already designated as the Primary
> Key?
>
> If you have tables with no declared constraints, you can use a
> "natural" primary key.
> which is described in everyone's good friend , Java Peristence with
> Hibernate section 8.1.1
>
> "
> Hibernate supports the use of natural keys.
>
> If you encountered a USERS table in a legacy schema, it’s likely that
> USERNAME is the actual primary key. In this case, you have no
> surrogate identifier that is auto- matically generated. Instead, you
> enable the assigned identifier generator strat- egy to indicate to
> Hibernate that the identifier is a natural key assigned by the
> application before the object is saved:
>
> <class name="User" table="USERS">
>     <id name="username" column="USERNAME" length="16">
>         <generator class="assigned"/>
>     </id>
>      ...
> </class>
> "
>
> I can bring the book with me, tonight to MAD, if you would like it for
> a while.
> All the examples are in Java, but I can follow it - and I'm not a java
> coder by any stretch of the imagination.
>
> Gavin.
>
> On May 16, 2:14 pm, "Steve Onnis" <st...@cfcentral.com.au> wrote:
>
>
>
>
>
>
>
> > I have an instance where i am trying to create a relationship between 2
> > tables, though i am wanting to just match up values in a column in both
> > tables. Is this possible?
>
> > For example, i have a Content table with an ID and a UUID (yes i want/need
> > both) and i have a Languages table with a related UUID and i want to have a
> > orm property that joins those 2 tables up. I cant seem to get it to work.
>
> > Is it even possible?
>
> > Steve

-- 
You received this message because you are subscribed to the Google Groups 
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com.
To unsubscribe from this group, send email to 
cfaussie+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/cfaussie?hl=en.

Reply via email to