There is a hsql code: "select p from project p where p.manager=? order by p.company.name asc". When the "order by p.company.name asc" section is removed from the code, I will get the right result of project data. But I didn't get anything if this section is presented.
And then, I find that there are some wanted project data with company null value, so "p.company.name" is trouble code in the order section. But I don't know how to recorrect this hsql code.
I hope get all the proper project data whenever it's company property is null or not with dictionary order(The project data with company null value should be arranged at front position).
Look forward to your reply!