Hibernate Community • View topic - HQL order by not working

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL order by not working - wrong order ?

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

EDH

Post subject: HQL order by not working - wrong order ?

Posted: Sun Jun 13, 2010 5:42 am

Beginner

Joined: Mon Aug 23, 2004 12:44 am
Posts: 25

I'm using hibernate 3.3.2.

I've got a very simple HQL that results in the following query being executed by Hibernate:

Code:

    select
        undimdefim0_.CODE as CODE20_
    from
        TAX_UD_DEF undimdefim0_ 
    order by
        undimdefim0_.CODE asc

However the results are returned in the wrong order, even though I've got the order by:

Code:

Afzender
Categorie
IscedStudiegebied
1Xyz

The same query executed in Oracle SQL Developer does return the rows in the right order:

Code:

1Xyz
Afzender
Categorie
IscedStudiegebied

Why is this happening ? Why is the sort order different although the exact same query is executed ?
Am I doeing something wrong ?

Any advice would be welcome.
Thanks,
EDH

Top

Page 1 of 1

[ 1 post ]

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