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.
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]
