Problem with maping

dulematic · **Joined:** Wed Jun 14, 2006 11:02 am **Posts:** 2

CREATE TABLE Indeks (
broj VARCHAR2 ( 10 ) NOT NULL,
JMBG VARCHAR2 ( 13 ) NOT NULL,
ime VARCHAR2 ( 30 ) NOT NULL,
prezime VARCHAR2 ( 30 ) NOT NULL,
imeOca VARCHAR2 ( 30 ) NOT NULL,
datumRodjenja DATE,
datumUpisa DATE NOT NULL,
pol NUMBER ( 5 ),
sfrSedisteFakultetaMesto NUMBER ( 5 ),
sfrOpstinaRodjenja NUMBER ( 5 ),
sfrMestoRodjenja NUMBER ( 5 ),
sfrSprema NUMBER ( 5 ),
sfrFakultet NUMBER ( 5 ) NOT NULL,
email VARCHAR2 ( 80 ),
sfrDrzava NUMBER ( 5 ),
status NUMBER ( 2 ),
sfrRokPrijemni NUMBER ( 5 ),
sfrPr VARCHAR2 ( 20 ),
CONSTRAINT PK_Indeks754 PRIMARY KEY (broj)
)

CREATE TABLE Lozinka (
password VARCHAR2 ( 15 ) NOT NULL,
broj VARCHAR2 ( 10 ) NOT NULL,
CONSTRAINT PK_Lozinka1076 PRIMARY KEY (broj)
)

ALTER TABLE Lozinka ADD ( CONSTRAINT FK_Lozinka1748 FOREIGN KEY (broj) REFERENCES Indeks (broj))

Could somebody write me a mapping file for Lozinka?[/img]

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Code:

<class name="Indeks" ...>
  <id name="Broj" column="broj" .../>
  <set name="Lozinka" ...>
    <key column="broj" not-null="true"/>
    <one-to-many class="Lozinka"/>
  </set>
  ...
</class>
<class name="Lozinka" ...>
  <id name="Broj" column="broj" .../>
  <many-to-one name="Indeks" column="broj" insert="false" update="false"/>
  <property name="Password" column="password" type="string" not-null="true"/>
</class>