Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 2.something

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

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

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Has anybody have problems like this when trying to order a query answer? I try to order on field name and it works fine for names starting with uppercase letters, but names starting with a lower case letter always gets order last, no matter what letter it starts with. For example I get the resulting list in this order:

Angela A
Boris B
Charlotte C
Michael M
Warner W
angela b
boris c
charlotte d

Of course I want it in this order:
Angela A
angela b
Boris B
boris c
Charlotte C
charlotte d
Michael M
Warner W


Does anybody know what is wrong?

Regards

Pich

in ASCII comparisons, which is what most String comparisons do, all capital letters are greater than lower case letters :)

http://www.lookuptables.com/

Are you doing your ordering in HQL (order by clause)? Wrap your ordering column in upper() or lower():

errr, lower than

Thanks a lot, worked like a charm!