Hi!
I'm new to this forum, however, i've studied Hibernate and i've made some test to look on how it work.
I've noticed that the Order by, in criteria doesn't work for aliases mapping (also if the normal expression works, with the same alias).
So, I've looked at the sources, and i've noticed that, in the class CriteriaLoader, during the translation of orderBy string, the class do not pass the aliasMap to the method that translate the string (and this method, pass an empty aliasMap to the same metod used by expression to translate to SQL string).
There is a why, this is doned so?
There is a problem if i modify the sources, to make the method pass the aliasMap? (i've tryed it, and seem that it work good).

Thanks for the answer!

Greetings!

Luka.

Sorry, i've forgot to say that i use the version 2.1.2 of Hibernate with an Oracle database.

BYE!

This is my first day with hibernate.
I think I have the same problem.
Following the "first use" trail, I'm trying to build the eg demo on pointbase
4.8RE with hibernate 2.1.3.
I get errors on order_by:

[java] Hibernate: select auctionite0_.id as x0_0_, auctionite0_.description
as x1_0_, auctionite0_.ends as x2_0_, max(bids1_.amount) as x3_0_ from AuctionI
tem auctionite0_ left outer join Bid bids1_ on auctionite0_.id=bids1_.item group
by auctionite0_.id , auctionite0_.description , auctionite0_.ends order by au
ctionite0_.ends desc

select has:auctionite0_.ends as x2_0_
order by uses the wrong name (auctionite0_.ends), if i edit the query and replace it with order by x2_0_
everything is OK.

Bug?
How do I solve this?

-----------------------------------------------------------------------------------
Small unrelated editorial remark, the readme.txt says:


There is no such file in the doc directory.

thanks in advance for the help,

Jan

Use a more up-to-date version of your database which does not have this bug.

The pointbase I'm using is the one bundled with the latest J2EE SDK
(22 march 2004).
The pointbase site is very unaccessible but judging from the press releases
4.8 is the latest and recommended version.

thanks,

jan.

I must say that my post is referenced to the Criteria class :).

Using the HQL all work good ^^.

Report this as a bug in pointbase.

I've altready posted the solution in the jira issue :).
(and some other people have posted other solutions too).

The Link of the Jira issue is:
http://opensource.atlassian.com/project ... wse/HB-132

BYE!

thanks guys,
I corrected the bug in pointbase
(it's called mysql now)

jan