Hi,

We have working with a number of dataobjects which are lying in multilevel inheritence hierarchy. Object's hierarchy is like,

BasicObject < ServerObject < Folder < AObject

All the objects do have 'OBJECT_ID' field with it.

Now if I want to fire a query on 'basic object' table, like

from ServerObject where OBJECT_ID = 1

We are getting an invalid query exception stating that OBJECT_ID column is ambiguous (Because it presents in both tables i.e. in ServerObject as well as in BasicObject).

Query formed by hibernate is:

select serverObj0_.OBJECT_ID as OBJECT_ID, serverobj0_.NAME as NAME1_, serverobj0_1_.VERSION as VERSION from ServerObject serverobj0_ inner join BasicObject serverobj0_1_ on serverobj0_.OBJECT_ID = serverobject0_1_.OBJECT_ID where (OBJECT_ID=1)

This problem can be avoid by manipulating the query a little, like

from ServerObject as s where s.OBJECT_ID = 1

i.e. by providing Alias in the query. But
is there any way to get this work done without aliases?
can Hibernate handle this alias problem itself?

Thanks
Mohit.

We are waiting for any suggestion. Please tell us, should we elaborate the query?

This is the correct way to do it through Hibernate unless you use native SQL queries. Perhaps I misunderstand your question.