Hello,

Hibernate 3.x.

I am getting confused on what type of mapping to use in the following scenario.

I have a table lets call it A.
It has a PK (surrogate).

-------------------------
TABLEA
int id (PK)
varchar type NOT NULL
---------------------------

This is mapped as an entity with a sequence, all good here.

Now it has a assocaition to TABLEB
----------------------------
TABLEB
int id (PK/FK) // This is from TABLEA PK and is a FK.
varchar type (PK) // this is from TABLEA and is also a PK
------------------------------------------------

I have been reading through the different types of mappings, and I cannot figure out what this is? I believe TABLEB will be a composite mapping, but I am having trouble figuring out how to map and create with java.

Table A will have a 1 to many of B, so 1 has a set of B.

I figured I could instantiate a TABLEA object, then create a TABLEB object, and add TABLEB to a set in TABLEA, then save TABLEA.

So is TABLEB a entity? (NO HBM) or a value type (I BET IT IS).

Could someone please assist with information on this type of mapping? Any book pages (in Action) book. Or references for this?

Thanks,

The problem is that your table design is nor really relational.
Foreign keys shout be the exact same primary keys on the referred table.

If you had the same amount of field for PK on both tables (ideally, just ID), then your case would be a "one-to-one association on a primary key", which is an association described in item 7.4.2 of the documentation

http://www.hibernate.org/hib_docs/v3/re ... tions.html