mapping related objects NOT using PK's, FK's?

chaseja · **Joined:** Fri Oct 03, 2003 8:44 am **Posts:** 11

Hibernate version:
2.1.6

Is it possible to relate to objects without using their PK's/FK's in the mapping docs?

i.e.
(in this example, the two tables are related by the email address)

Code:

<class name="Account" table="account">
  <id name="id" column="user_id" type="java.lang.String">
    <generator class="assigned" />
  </id>
  <property name="emailAddress" column="email" type="java.lang.String"/>
</class>


<class name="User" table="user">
  <id name="id" type="java.lang.Integer" column="user_id" unsaved-value="null">
    <generator class="native" />
  </id>

  <property name="emailAddress" type="java.lang.String" column="email" />
  <!-- here's the relation I'd like to achieve -->
  <set name="accounts" table="account">
    <key column="email"/>
    <one-to-many class="Account"/>
  </set>
</class>

Is this somehow possible (I know the above mapping won't do it)?

Jon

duggant · **Joined:** Mon May 03, 2004 1:25 pm **Posts:** 31

we had a similar problem, and we solved it using Hibernate3 dynamic filters., but that only works if the actual primary key produces a super set of the set you want to produce.

op90 · **Joined:** Sun Oct 17, 2004 4:43 am **Posts:** 4

duggant wrote:

we had a similar problem, and we solved it using Hibernate3 dynamic filters., but that only works if the actual primary key produces a super set of the set you want to produce.

I guess you could also use the "were" within the set definition

anthony · **Posted:** Tue Oct 19, 2004 4:58 am

yes but the where clause in collection is static (HB2)