Hello,

I am using hibernate 3.2, and oracle 9.2.2.

I am having some issues and not sure the best approach to take.

I was interested in using the table per hierarchy design for an application. However, the tables are already written and the field constraints are all set to not null. Thus, this approach will not work for me. I am not sure what approach to take now.

My application structure is as follows:
CLASSXInt - interface
ClASSA - attribs: X, Y, Z - implements CLASSXInt
CLASSB - attribs: A, B, C - extends CLASSA
CLASSC - attribs: E, F, G - extends CLASSB

This structure cannot change.

One table (TABLE123) is used for most of the data contained in all the classes. What I mean by "most", is that one field in TABLE123 is reference data for the data in another table (TABLE456). In other words, I need to pull the value of TABLE123, then use it to get the actual meaningful data from TABLE456.

The constraints on all of the fields in both tables is set to NOT NULL and cannot be changed. What is the best approach to setting up hibernate to work with this situation? Thanks.

I need to be able to do full CRUD on CLASSA, CLASSB, and CLASSC.