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 Morales, David <dm...@indra.es> on 2004/11/03 19:07:19 UTC

problem with foreign keys

I'm new in ojb, and i dont usually speak english, so be patient.... please.

I have an sql statement that uses five tables in my db. So, i think i may use reference-descriptors but i'm not capable.....

i have a class-descriptor like this

**************************************************************
<class-descriptor 
  class="es.indra.aunabill.vo.Tafm_detalle_llamadasJOIN"
  table="AUNABILL_DES.TAFM_DETALLE_LLAMADAS"
>
  <field-descriptor id="0"
    name="cod_factura"
    column="COD_FACTURA"
    jdbc-type="VARCHAR"
    primarykey="true"
  />
 
  <field-descriptor id="8"
    name="tcategoriaId"
    column="TCATEGORIA"
    jdbc-type="VARCHAR"
    access="anonymous"
  />
  <field-descriptor id="20"
    name="cod_tdestinoId"
    column="COD_TDESTINO"
    jdbc-type="VARCHAR"
    access="anonymous"
  />
  
  <reference-descriptor
  	name="tDestinoId"
  	class-ref="es.indra.aunabill.vo.Tdestinos"
  >
  	<foreignkey field-ref="cod_tdestinoId"/>
  </reference-descriptor>
  
  <reference-descriptor
  	name="tCategoriaID"
  	class-ref="es.indra.aunabill.vo.Tdestinos"
  >
  	<foreignkey field-ref="tcategoriaId"/>
  </reference-descriptor>
  
  

</class-descriptor>
************************************************

And this is what i read and have: 

In a field descriptor:
	if "access" is "anonymous" in your bean you dont need getter and setter neither parameter called like this field-	descriptor (property name).

In reference-descriptor
	i dont know how is this... is the name of reference-descriptor anyone?, is the <foreignkey field-ref="tcategoriaId"/> 	set well?? or what name i may have there??.
	If i want to add outer joins according to this configuration, may i write something like this queryCriteria.setPathOuterJoin("tDestinoId");??



Thanks a lot¡¡





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