Hi delpouve, the HQL query "FROM Executive e WHERE e.company.id = 1" works fine, but the HQL Query "FROM Company c" return the exception from MySQL:

"Unknown column 'executives0_.CompanyId' in 'field list'"

[]s

Ary Junior

excuse me to insist but in company mapping file do you have
<set
name="executives"
table="Executive"
lazy="false"
inverse="true"
cascade="all"
sort="unsorted"
order-by="Nome ASC"
>
<key
column="CompanyId"
/>
<one-to-many
class="br.com.valoriza.imf.site.persistence.Executive"
/>
</set>
or
<set
name="persons"
table="Person"
lazy="false"
inverse="true"
cascade="all"
sort="unsorted"
order-by="Nome ASC"
>
<key
column="CompanyId"
/>
<one-to-many
class="br.com.valoriza.imf.site.persistence.Person"
/>
</set>


The first is wrong, you cannot do that this way

Ok, I understood, but why query "FROM Executive e WHERE e.company.id = 1" works and query "FROM Company c" does not work when I uses the first mapping?

[]s

Ary Junior

the first uses the mapping many(person) to one (company) declared on the person mapping file
the second uses the one(company) to many(executives) declared on the company mapping file, which in your case is wrong

Then, when I will have a reference for a Company and want to get all executives I will have that to execute the query "FROM br.com.valoriza.imf.site.persistence.Executive e WHERE e.company.id = ?" instead execute the method getExecutives()? That is correct?

yes you're right since you cannot have directly getExecutives() but only getPersons().
But maybe it could be usefull for you to implement a getExecutives()method which do the simple test isInstanceOf().... on person collection

I accept however I did not like. In any way thanks very much.

[]s

Ary Junior