1) I have a query that looks something like this:

from Load l left join l.events e … so on…
order by e.eventLoadType, e.eventType, e.eventSchedOnDoorTime


2) Basically, Load has one to many ‘Events’. Each Event can either be a ‘LoadEvent’ or ‘UnloadEvent’. The ‘discriminator’ is defined in the ‘Event’ base class as follows:

<discriminator column="event_type" not-null="false" type="string" length="10"/>


3) On the Load object I have a ‘bag’ that looks like this:

<bag name="events" inverse="true" cascade="save-update" lazy="true" order-by="event_type">
<key column="event_load_gkey"/>
<one-to-many class="com.xyz.trips.business.entity.Event"/>
</bag>

When I run the query (#1 above), I get an exception saying ‘eventType’ is not a property of Event.

My question is – how do I use a ‘discriminator’ column in ‘order by’. I added a method called, getEventType(), in each of the classes (Event, LoadEvent, UnloadEvent), but that doesn’t help.

Please help! Thanks.

Hi,

did you define the property eventType in the base class as a hibernate property. Otherwise I do not think hibernate will know it though it is a bean property.

If you want to use the discriminator column as a real property you have to define the mapping.

Perhaps this will work, too: