Using hibernate2.jar (dated 8/8/2004), no readme or version file in jar, not sure what the version is.

Database is Oracle

Generated sql is;
Hibernate: select 'some fields'... from atable_name where
some_criteria order by this.COLUMN_A asc

Code for order by is;
criteria.addOrder(Order.asc("columnA"));
criteria.addOrder(Order.desc("columnB"));

Problem;
Why isn't columnB appearing in the order by portion of the sql and don't tell me that you can only have one order by. If so the method is inappropriatley name and should be changed to setOrder.

Apologies for lack of hibernate version I did not set this up, so I am not sure what version was downloaded.

That's odd. I've dont that successfully many times, although I always chain them up liKe:

criteria.addOrder(Order.asc("columnA")).addOrder(Order.desc("columnB"));

Don't know if that makes a difference.

My advice: 1) turn on Hibernate logging and set it to debug level so you can see what it's doing. 2) Get jiggy with your debugger. You'll learn a lot more if you trace down into the hibernate code that's adding the order clause.