Subquery using derived table in Hibernate HQL

Posted by Vladimir on Stack Overflow See other posts from Stack Overflow or by Vladimir
Published on 2010-03-12T15:26:48Z Indexed on 2010/03/12 15:27 UTC
Read the original article Hit count: 737

Filed under:

hql

|

derived

|

table

I have a Hibernate HQL question. I'd like to write a subquery as a derived table (for performance reasons). Is it possible to do that in HQL? Example:

FROM Customer WHERE country.id in (SELECT id FROM (SELECT id FROM Country where type='GREEN') derivedTable)

(btw, this is just a sample query so don't give advices on rewriting it, is just the derived table concept I'm interested in) Thanks.

© Stack Overflow or respective owner

Related posts about hql

HQL Query Not Running

as seen on Stack Overflow - Search for 'Stack Overflow'
select new UpdateCountDataBean(count(elements(am.actionId)) as noOfUpdates, am.pname as name) from ActivityMaster am group by am.pname The UpdateCountDataBean is created by me while the second class i.e. ActivityMaster is POJO class. java.lang.NullPointerException at org.hibernate.hql.ast.tree… >>> More
Whats wrong with this HQL query?

as seen on Stack Overflow - Search for 'Stack Overflow'
did i encounter a hibernate bug or do i have an error i dont see: select enty.number from EntityAliasName enty where enty.myId in ( select cons.myId from Consens cons where cons.number in ( select ord.number from Orders ord where ord.customer = :customer and ord.creationDate… >>> More
Hibernate Query Exception

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a hibernate query I'm trying to get working but keep getting an exception with a not so helpful stack trace. I'm including the code, the stack trace, and hibernate chatter before the exception is thrown. If you need me to include the entity classes for MessageTarget and GrpExclusion let… >>> More
hql equivalent query to this sql query

as seen on Stack Overflow - Search for 'Stack Overflow'
Select top 1 from <tablename> what is hql query for the above ? >>> More
Subquery using derived table in Hibernate HQL

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a Hibernate HQL question. I'd like to write a subquery as a derived table (for performance reasons). Is it possible to do that in HQL? Example: FROM Customer WHERE country.id in (SELECT id FROM (SELECT id FROM Country where type='GREEN') derivedTable) (btw, this is just a sample query so… >>> More

Related posts about derived

Does it seems logical to statically cast base pointer to Derived ...static_cast<Derived *> (Base poi

as seen on Stack Overflow - Search for 'Stack Overflow'
class A { public: A() { cout<<"In A"; } }; class B : public A { public: B() { cout<<"In B"; } }; int main() { A *a=new A(); B * b=static_cast<B*>(a); } >>> More
Calling a method with an instance of derived class of derived generic type

as seen on Stack Overflow - Search for 'Stack Overflow'
Okay, so I have classes class B<T> : A<T> class L : K and a method void Method(A<K> a) {...} What I would like to do is this b = new B<L>(); Method(b); //error But it is not possible to b to the correct type. Indeed it is not possible to make this cast A<K>… >>> More
C# generic - returning objects of the derived class?

as seen on Stack Overflow - Search for 'Stack Overflow'
public class BaseClass{ public static T Find<T>(object value){ -- db.get<T>("params", value); } } public class Derived: BaseClass{ } ... void someMethod(){ Derived obj = Derived.Find<Derived>(1); } In the above code how do I change Derived obj = Derived.FindDerived<Derived>(1);… >>> More
Why is the this-pointer needed to access inherited attributes?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, assume the following class is given: class Base{ public: Base() {} Base( const Base& b) : base_attr(b.base_attr) {} void someBaseFunction() { .... } protected: SomeType base_attr; }; When I want a class to inherit from this one and include a new attribute for the derived class, I would… >>> More
Idiomatic Scala way to deal with base vs derived class field names?

as seen on Stack Overflow - Search for 'Stack Overflow'
Consider the following base and derived classes in Scala: abstract class Base( val x : String ) final class Derived( x : String ) extends Base( "Base's " + x ) { override def toString = x } Here, the identifier 'x' of the Derived class parameter overrides the field of the… >>> More