I'm getting the following exception:


org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list


[FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=null,role=net.iss.sp.entity.Asset.networkInterfaces,tableName=NetworkInterface,tableAlias=networkint1_,origin=Asset asset0_,colums={asset0_.AssetID ,className=net.iss.sp.entity.NetworkInterface}}]


[select count( asset ) from net.iss.sp.entity.Asset asset left join fetch asset.networkInterfaces left join fetch asset.owner left join fetch asset.criticality ];


nested exception is java.lang.IllegalArgumentException: org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list

[FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=null,role=net.iss.sp.entity.Asset.networkInterfaces,tableName=NetworkInterface,tableAlias=networkint1_,origin=Asset asset0_,colums={asset0_.AssetID ,className=net.iss.sp.entity.NetworkInterface}}]


[select count( asset ) from net.iss.sp.entity.Asset asset left join fetch asset.networkInterfaces left join fetch asset.owner left join fetch asset.criticality ]


I've read the hibernate release notes:

http://www.hibernate.org/250.html?cmd=prntdoc

And I understand how the example in the release notes is illegal in that they are asking for instances of a joined class (i.e. b), and not instances of A who is the owner.

But, that's not the same thing I'm doing here. I'm asking for Asset to be joined with all of it's relationships, but only counting on the instances of Asset. So I'm asking for the equivalent of count(A) in the example so Asset is the owner. Why is that not valid?

I can think of several ways to fix this like dropping the joins, but what happens when I need a join to express something in the where clause? I'm just trying to count the maximum results that could occur from my query, but I'm trying to do it generically so I can write reusable pagination.

Thanks
Charlie

I'm having a similar issue, any clue what's wrong ?

query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=v,role=null,tableName=public.file_visit_counter,tableAlias=filevisitc1_,origin=public.file file0_,colums={file0_.id ,className=com.gsi.core.domain.FileVisitCounter}}]


I also tried



I also tried



The visits is defined in File as

Yes drop the fetch joins from your query.



Here you are fetch joining against file.visits, but you aren't using that in your where clause so as far as counting goes it shouldn't alter your
results to have them present or to take them away.



In all of the above cases the joins are only present to eagerly load some relational object. I don't know why it works, but it does. Fetch joining in count queries doesn't seem to work.

Now if you need to load a relationship in order to query across it then you'd do an inner join file.visits so something like:



That works for me when I need something loaded so I can put it in my where clause.

Charlie

Thanks a lot, that makes perfect sense.

The thing I try to achieve is a pagination thing. I use HibernatePage(search on the hibernate.org) to only get a window of the data. The problem with that is using scroll and last() on the HQL/SQL will take as much as extracting the data! So what I try to achieve here is to make the count as a HQL/SQL by striping dynamicaly the query and run it hoping that with will take lot less.

I have case where the last() takes 1.2sec - a lot indeed. Now same query with count(*) takes 21ms! My problem can also be the fact that I'm running Postgresql 7.4.7 but I'm upgrating to 8.2 so I hope that will speed up my queries.

My best - I'd have give you a credit for reply but I just realized that you answered the question by yourself - can you give yourself a credit :) ?

Q-2