Hi David, thanks for your response.
> -----Ursprüngliche Nachricht----- > Von: David Delbecq [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 30. Januar 2007 14:43 > An: Tomcat Users List > Betreff: Re: Return values in wrong sort order > > Looks to me liek a problem of the webapp, not a problem of tomcat. > The oracle thin driver have, i already noticed, to default to > america.american. You webapp will probably need to issue a few alter > session to enable special sorting rule. It is probably working on your > sqlplus client because it is setting correctly the session. Is there any way I can temporarily change the behaviour of the Oracle thin driver? Just to test if this is the source of the issue. If it is, I need to talk to our developers to find a solution within our web application. Regards, Sascha > En l'instant précis du 01/30/07 14:37, Sascha Wehnert s'exprimait en ces > termes: > > Hi folks, > > > > > > > > we encountered a problem (for us) in how Tomcat 5.5.20 returns requested > data. > > > > In our case we selected user data ordered by family name containing > special polish > > > > characters from an Oracle database. As soon as the familiy name starts > with > > > > a special character, the name gets listed at the bottom of the output > and not in > > > > alphabetical order. > > > > > > > > If I run the same query on the database the values returned look pretty > good. So I > > > > assume my Tomcat instance was configured with the wrong settings. $LANG > is set > > > > to de_DE.UTF-8 and JAVA_OPTS includes “-Xms256m -Xmx512m -server - > Dutil.language=de > > > > -Djava.library.path=/opt/apr127/lib -Dfile.encoding=UTF-8”. All settings > are placed in > > > > catalina.sh, of course with an export command in front of them ;-) > > > > > > > > Even if I change $LANG to pl_PL.UTF-8 or use –Dfile.encoding=UTF-8 it > doesn’t change > > > > anything about the sort order. > > > > > > > > Am I missing here some JAVA options? Has anyone of you perhaps come > across > > > > a similar problem and could give me some pointer in the right direction? > > > > > > > > regards, > > > > > > > > Sascha > > > > > > > > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: users@tomcat.apache.org > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED]