Hibernate Community • View topic - Order by null values

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Order by null values

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

joelrewers

Post subject: Order by null values

Posted: Tue Mar 07, 2006 7:06 am

Newbie

Joined: Mon Feb 06, 2006 8:53 am
Posts: 7
Location: Antwerp Belgium

Hi All

I have a problem with sorting in Hibernate.

I have a collections of documents with an User attached to it. The User can have a null value.

When I ask all documents (select * from documents) all documents are returned, also the one with no User.

When I sort on User (Order by documents.User) I only get the ones where user is not null

How can I sort on user and retrieve all the documents

Top

sergey

Post subject:

Posted: Tue Mar 07, 2006 4:49 pm

Contributor

Joined: Wed May 11, 2005 4:59 pm
Posts: 1766
Location: Prague, Czech Republic

Try this:

Code:

select document from Document document left join document.User user order by user

(or order by user.id)

Top

joelrewers

Post subject:

Posted: Tue Mar 07, 2006 5:56 pm

Newbie

Joined: Mon Feb 06, 2006 8:53 am
Posts: 7
Location: Antwerp Belgium

It works, I added left join fetch to retrieve only the documents.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » NHibernate 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