I have a mapping of where I have a base table (Tasks) and then an extending table (CRS) but the CRS table actually have date for three different objects. Some of the fields are in common and some are unique. Ignoring the inheritance of the common fields to keep this simple, I have join statements in my three extending classes such as:



Each of the three instances join on the CRS table and everything works correctly but when looking at the log I see that a join is performed 3 times on CRS table:



I see why this is happening but I would think that Hibernate would be able to tell that the joined table is the same in all these instances and to just select all fields for all three concrete classes. Is there anyway around this?

Posting this in case someone else runs into this same issue:

I never did find a good solution for this. I ended up creating an abstract object (ChangeRequest) which has all the things from CRS table defined on it through XML. I then set all the getters and setters on the ChangeRequest object to package/default access and made my final classes (with discriminator value still intact) all extend ChangeRequest and have public pass through methods for the items which users of the class should have access to.

Not an ideal solution by any means but except for abstracting the database out more (which may be a good idea but would still have more joins), this is the best solution I could come up with and it still stop the multiple join from occurring,