You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by No...@bmi.gv.at on 2003/12/01 11:23:44 UTC

RE: Mapping question

Hello Eric,
the descriptor as example:

<class-descriptor 
  class="at.gv.bmi.ClassA"
  table="TableA"
  >
  <field-descriptor 
     name="fieldA"
     column="A"
     jdbc-type="CHAR"
     primarykey="true"
  />
  <field-descriptor 
     name="fieldB"
     column="B"
     jdbc-type="CHAR"
  />
  <collection-descriptor
     name="joinAB"
     element-class-ref="at.gv.bmi.ClassB"
  >
     <inverse-foreignkey field-ref="fieldY"/>
  </collection-descriptor>
</class-descriptor>


<class-descriptor 
  class="at.gv.bmi.ClassB"
  table="TableB"
  >
  <field-descriptor 
     name="fieldX"
     column="X"
     jdbc-type="CHAR"
     primarykey="true"
  />
  <field-descriptor 
     name="fieldY"
     column="Y"
     jdbc-type="CHAR"
  />
  <field-descriptor 
     name="fieldZ"
     column="Z"
     jdbc-type="CHAR"
  />
</class-descriptor>

The join has to be made from ClassA:B to ClassB:Y, ie the where condition
has to be 
where A0.B = A1.Y instead of A0.A = A1.Y
What do I have to do to get this join?

Thanks,
Norbert.

-----Original Message-----
From: eric barbe [mailto:ebarbe@deliasystems.com]
Sent: Freitag, 28. November 2003 15:08
To: OJB Users List
Subject: RE: Mapping question


Hi,

I don't really understand you're pb. ;o(
Is it : any field from my class A can be THE foreign key (mykey in this
case) from my class B ?

Regards

Éric

-----Message d'origine-----
De : Norbert.Woegerbauer@bmi.gv.at
[mailto:Norbert.Woegerbauer@bmi.gv.at]
Envoyé : jeudi 27 novembre 2003 17:49
À : ojb-user@db.apache.org
Objet : RE: Mapping question


Thanks, I defined it like that, but:

>If A is 1 and B is n.
>In A class descriptor write :

><collection-descriptor name="relation_name_in_A_class"
>element-class-ref="url.B">
>	<inverse-foreignkey field-ref="mykey"/>
></collection-descriptor>

>And in B class descriptor write this

><field-descriptor name="mykey" column="mycolumn" jdbc-type="INTEGER"/>
>Here mykey is the foreignkey but not a primary key !

OJB generates statements where mykey points to the pk of class A. The
generated join looks like: A.pk = B.mykey
We need: A.anyField = B.mykey
In fact I think we've a m:n mapping without intermediary table...
What can we do (the database model cannot be changed)?
Is there a possibility to add to the collection-descriptor something like
<foreignkey field-ref="anyField"/> similar to the <inverse-foreignkey/>
element?

Thanks again.

-----Message d'origine-----
De : Norbert.Woegerbauer@bmi.gv.at
[mailto:Norbert.Woegerbauer@bmi.gv.at]
Envoyé : jeudi 27 novembre 2003 16:57
À : ojb-user@db.apache.org
Objet : Mapping question


Hi,

I've got a 1:n mapping from table A to table B. But the foreign key field of
table A is not it's primary key. I can't find how to tell OJB to use another
field to join table B.
Thanks for help, Norbert.


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org




---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org