subquery « Map « JPA Q&A





1. How to reference a map name for a subquery in an HQL order by clause    stackoverflow.com

I've got an HQL statement like this:

select new map (f1 as field1, (select ...) as field2)
from ...
where ...
order by field2;
It fails saying "Unknown column 'field2'". I experienced this in general that ...

2. Column not mapped on subquery    forum.hibernate.org

Hello. I am using Hibernate 3 and have the following tables: system -------- id name module -------- id name system_module -------- id_system id_module I am trying to create a subquery that gives me a list of modules NOT assigned to a system, ie. that are IN the module table but NOT IN system_module table. Pretty straight forward SQL but I can't ...

3. subquery with non-child    forum.hibernate.org