Hi,

I have a problem that has been troubling me for days..

Given following database table with varchar2 column:

testColumn
-----------
'1'
'2'
'R1'
'R2'

When i use criteria API and add order clause "testColumn asc" on some environments it returns order 1,2,R1,R2 which is right, but on some environments it returns R1, R2, 1, 2.

I have tried many combinations, but I found that on my local machine, by switching to JVM 1.6.0_35 it gives wrong ordering, but on 1.7.0 it gives correct ordering, but unforunatly on our TeamCity buildserver it gives wrong ordering even on 1.7.0.

We use hibernate 3.6.10. Database is Oracle 11g.

What could be wrong?

Not anybody knows?