Please help me with mapping

rc22 · **Joined:** Mon Mar 08, 2004 8:56 pm **Posts:** 5

Hi

I have the following schema, how do I map it to Hibernate (create *.hbm.xml file)?

Schema:

Code:

CREATE TABLE categories (
      cat_id           INT     NOT NULL,
      parent_cat_id    INT,
      PRIMARY KEY(cat_id),
      FOREIGN KEY cat_id REFERENCES categories(cat_id)
)

CREATE INDEX categories_parent_cat_id ON categories(parent_cat_id);

david · **Posted:** Thu Mar 11, 2004 9:53 pm

The foreign keys not quite right. Anyway, I would suggest you try out Middlegen as it will generate mapping documents from your database directly. This way you can make changes and the see what the mapping document is - good way to learn quickly.

rc22 · **Joined:** Mon Mar 08, 2004 8:56 pm **Posts:** 5

Thanks for the suggestion, I actually used Middlegen to generate the mapping documnts for my SQL schema but somehow I don't think they look right.

The foreign key should be this:

Code:

FOREIGN KEY parent_cat_id REFERENCES categories(cat_id)

david · **Posted:** Thu Mar 11, 2004 10:17 pm

OK - so show me the mapping generated for the categories table. It should be fine.