Get your CodeRanch badge!*
The moose likes Object Relational Mapping and the fly likes hibernate subqueries Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hibernate subqueries" Watch "hibernate subqueries" New topic
Author

hibernate subqueries

rajiv jackz
Greenhorn

Joined: Jul 12, 2010
Posts: 29
Hai to all,

how to perform hibernate subqueries . give me example.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

As Criteria or HQL?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
rajiv jackz
Greenhorn

Joined: Jul 12, 2010
Posts: 29
HQL and Left join and right join in HQL too.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Here you go.
rajiv jackz
Greenhorn

Joined: Jul 12, 2010
Posts: 29
Thanks ..

I am using displaytag for pagging(pagination )and sum of particular column.

when i give page size it is not showing the total. if I remove the page size it is showing the total of particular column.

hear is my code

<display:table name="${getRevenue}" pagesize="15" export="true" class="simple" decorator="org.displaytag.decorator.TotalTableDecorator" >

<display:column property="revenue" title="Revenue" total="true" />

<display:column property="revenueShare" title="Revnue Share " total="true" /> can you provide solution?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: hibernate subqueries
 
Similar Threads
sql syntax question
How to get the records from data base in chunk
Correlated subqueries in HQL Select Clause
Special Association Mapping in Hibernate
SQL to HQL (Having issue in Left Outer Join)