I'm using hibernate 3.2 with oracle 10g. I'm trying to get the case-insensitive "select/order by" to work by changing NLS_SORT and NSL_COMP at session level within the DB (the default session setting). However, after the change my query result is still case-sensitive when sorted. It suggests that something (not me) is changing the NLS_ setting on the sessions. I'm using c3p0 for the pool and spring managed hibernate sessions. Any pointer would be greatly appreciated.