http://www.hibernate.org/ForumMailingli ... AskForHelp

read and understand!

Hibernate version:
2.1.7

Name and version of the database you are using:
Oracle 9iR2

Hello hibernate team,

I guess my former post was a bit unprecise/unclear ...
therefore I'll give it a second chance/try:

I have the following legacy database model:

Table Object_States (
object_id number -- primary key
...
)

Table Person (
person_id number -- pk, fk on Object_States(object_id)
...
)

Table Order (
order_id number -- pk, fk on Object_States(object_id)
...
)

many more tables like Person/Order

I know, this DB design could lead to controversional discussions -
it is a legacy db-schema anyway ... so I have no way to change it!

My problem is, how to map this so called subtype (sometimes called arc)
right ...

What I need is an unidirectional one-to-one mapping as a primary key association! There is no need/way to navigate from Object_States back
to Person, Order, whatever ...

I would really appreciate, if I can ommit another column Object_State_Id
in all these tables, as the primary key in all tables are OIDs, so identity is given for the whole schema!

Any hints, suggestions, etc. are highly welcome, as I'm getting under timepressure slowly ...

Even a now way would help me ... so I know, that I have to find a workaround ...

Thx in advance
from snowy Vienna

K:)