Ola pessoal,
Estou com grandes dificuldades para fazer o relacionamento entre as tabelas abaixo, o motivo eh, o relacionamento que quero criar nao tem primary key.
Por exemplo:
Tenho as tabelas (e os Entity Bean de cada tabela):
Local:
local_id
local_origem
local_destino
Endereco:
endereco_id
local_geral
endereco_nm
endereco_ds
Em ejb-jar.xml:
<ejb-relation >
<ejb-relation-name>LocalOri-Endereco</ejb-relation-name>
<ejb-relationship-role >
<ejb-relationship-role-name>Endereco-Has-LocalOri</ejb-relationship-role-name>
<multiplicity>Many</multiplicity>
<relationship-role-source >
<ejb-name>Endereco</ejb-name>
</relationship-role-source>
<cmr-field >
<cmr-field-name>localori</cmr-field-name>
</cmr-field>
</ejb-relationship-role>
<ejb-relationship-role >
<ejb-relationship-role-name>LocalOri-do-Endereco</ejb-relationship-role-name>
<multiplicity>One</multiplicity>
<relationship-role-source >
<ejb-name>Local</ejb-name>
</relationship-role-source>
<cmr-field >
<cmr-field-name>endereco</cmr-field-name>
<cmr-field-type>java.util.Collection</cmr-field-type>
</cmr-field>
</ejb-relationship-role>
</ejb-relation>
Em jbosscmp-jdbc:
<ejb-relation>
<ejb-relation-name>LocalOri-Endereco</ejb-relation-name>
<foreign-key-mapping/>
<ejb-relationship-role>
<ejb-relationship-role-name>Endereco-Has-LocalOri</ejb-relationship-role-name>
<key-fields/>
</ejb-relationship-role>
<ejb-relationship-role> <ejb-relationship-role-name>LocalOri-do-Enderecos</ejb-relationship-role-name>
<key-fields/>
</ejb-relationship-role>
</ejb-relation>
Minha duvida eh no jbosscmp-jdbc, qual o key-field devo colocar e aonde.
Gostaria de fazer dois relacionamento nessa tabela:
- Local.local_origem = Endereco.local_geral
- Local.local_destino = Endereco.local_geral
Agradeco desde ja qq ajuda.
Fazendo o primeiro creio que o segundo e copy-paste.
Obrigado mais uma vez
Daniel