JoinColumn with constant value ?

leonchen · **Joined:** Tue Oct 04, 2005 3:30 am **Posts:** 3

Hi,

please see the link
http://edocs.bea.com/kodo/docs41/full/h ... joins.html

Table T1 has column FK
Table T2 has column PK1 and PK2

I want create a ManyToOne relation, join column T1.FK to T2.PK1 and also want to specify that T2.PK2 has the value 'a'.

Can I achieve this by hibernate?

Thanks

ge0ffrey · **Joined:** Thu Oct 13, 2005 4:19 am **Posts:** 98

I've tried several approaches on doing this, but hbm2ddl always fails on it - and I never got a chance to activate it.
Is it possible to disable hbm2ddl for a single class?

ge0ffrey · **Joined:** Thu Oct 13, 2005 4:19 am **Posts:** 98

The classic hibernate manual mentions an interesting thing:

column and formula attributes may even be combined within the same property or association mapping to express, for example, exotic join conditions.

<many-to-one name="homeAddress" class="Address"
insert="false" update="false">
<column name="person_id" not-null="true" length="10"/>
<formula>'MAILING'</formula>
</many-to-one>

Apparently this isn't possible in annotations yet:
http://opensource.atlassian.com/project ... se/ANN-210