#85 Foreign Key

[Anonymous]

Hi,

I'm trying to explain my problem :

I have a Oracle table like this :

CREATE TABLE TB_GROUPE_AVION (
V_REGISTRATION VARCHAR2 (255) NOT NULL,
V_TYPE_AVION VARCHAR2 (255) NOT NULL,
V_GROUPE_AVION VARCHAR2 (255) NOT NULL,
CONSTRAINT UK_GROUPE_AVION
UNIQUE (V_GROUPE_AVION),
PRIMARY KEY ( V_REGISTRATION, V_TYPE_AVION ) ) ;

I have another Oracle Table :
CREATE TABLE TB_ELT_CALC_MIB (
V_GROUPE_AVION VARCHAR2 (10) NOT NULL,
V_DESIGNATION VARCHAR2 (50) NOT NULL,
I_D_MASSE NUMBER (4),
F_D_INDEX NUMBER (4,2),
CONSTRAINT PK_TB_ELT_CALC_MIB
PRIMARY KEY (V_GROUPE_AVION, V_DESIGNATION )) ;

ALTER TABLE TB_ELT_CALC_MIB ADD CONSTRAINT FK_GROUPE_AVION
FOREIGN KEY (V_GROUPE_AVION)
REFERENCES BRITAIR.TB_GROUPE_AVION (V_GROUPE_AVION);

I add on this table an integrity constraint to ensure
that :
if a user deletes a record in the TB_GROUPE_AVION table
there mustn't be a record whith this V_GROUPE_AVION
in the TB_ELT_CALC_MIB table.

I'm using Middlegen to generate HBM files because I'm
wsorking with MyEclipse + Oracle + Hibernate 3.0 +
Struts 1.2
But the Foreign Key doesn't appear in the HBM file.
So, I tried to write HBM files correctly but I have an
error with MyEclipse :

Foreign key (FKD201CEDFE3596467:TB_ELT_CALC_MIB
[V_GROUPE_AVION])) must have same number of columns as
the referenced primary key (TB_GROUPE_AVION
[V_REGISTRATION,V_TYPE_AVION])

Coud you help me please
Thanks a lot

Gilles BRUNO