Originally posted by Paul Sturrock: What you say sounds very surprising. The container does't play any part in ordering of SQL results sets.
How do you sort your results? Can you show us the SQL you use and the code you call the query from?
I have a employee table having employeeid, employee name and address as it fields. Sql being used is select employeeid, employeename, address from emplyoee order by 2 asc
Code is pretty stright forward SQLQuery sqlQuery = createQuery(queryString); where queryString is above mentioned query and createQuery is a private method which gets the SQLQuery object form HibernateSessionImpl
Returned resultset is not sorted correctly in websphere
What does createQuery(queryString) do? Does it keep the column order as defined in your query? Using "order by 2" requires a fixed column order. What happens if you change this to "order by employeename", is the ordering more consistant?
subject: Sorting problem with HibernateSqlQuery with Websphere