jQuery in Action, 3rd edition
The moose likes Object Relational Mapping and the fly likes any good hql query for this scenario? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "any good hql query for this scenario?" Watch "any good hql query for this scenario?" New topic

any good hql query for this scenario?

Steven Jiang

Joined: Mar 01, 2008
Posts: 22
Hi All

Another query to ask here. we have a table
File(name ,date, file_size).
anyone has simple query to list name of file where the related size is not 0

let me give some sample data.
name date size
a 1/1/2001 0
a 2/1/2002 2
a 3/3/2003 0
b 1/1/2000 3
b 2/2/2001 4

If I run the query, it should list "b" only as "a" has two related size = 0.

I know the sql for it. but seems contain subquery and complex. so I am after a simple HQL

Thanks in advance.


the sql would be

I gotta keep learning...
tabiul mahmood

Joined: Sep 17, 2009
Posts: 18
Not sure why you need the SubQuery

HQL = "from File where size>0" seems sufficient to me as this query will return only Files whose size is > 0. Unless the data that you provided is wrong and there are cases where the File Name is same but the size maybe 0 or other values
I agree. Here's the link: http://aspose.com/file-tools
subject: any good hql query for this scenario?
It's not a secret anymore!