Hibernate Community • View topic - Order by collection size with criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Order by collection size with criteria

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

G.I.Joe

Post subject: Order by collection size with criteria

Posted: Tue Sep 02, 2008 9:59 am

Newbie

Joined: Tue Sep 02, 2008 9:53 am
Posts: 6

Hibernate version:
Whatever ships with JBoss 4.2.2GA

Name and version of the database you are using:
Oracle 11

Hi,
is there any way to order a criteria result by the size of a collection? It's pretty easy with HQL ("... order by size(foo) ..."), but I can't find a way to to this when using criterias.

Top

G.I.Joe

Post subject:

Posted: Tue Sep 02, 2008 10:36 am

Newbie

Joined: Tue Sep 02, 2008 9:53 am
Posts: 6

I did some more searching, and it seems that using "@Formula" is the only way.
I've never worked with @Formula before, so I've created a new formula column for testing, but it doesn't seem to work. If definded the column with

Code:

@Formula(value="1*1")
public Integer foo;

Is this wrong? Google doesn't return anything helpful about the formula annotation.

Top

G.I.Joe

Post subject:

Posted: Mon Jan 12, 2009 10:23 am

Newbie

Joined: Tue Sep 02, 2008 9:53 am
Posts: 6

I ran into the same problem again. Last time I "solved" it by simply not using criteria, but this time I'll have to.
Is there any way to this? This is really important

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum