tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Harald Henkel <h.hen...@gs-automation.de>
Subject Data sorting problem Tomcat<->Oracle
Date Tue, 23 Nov 2004 15:02:24 GMT
Hello all.

I have a strange problem with data sorting using an Oracle 8.1.7
database.

I set the database to use binary sorting (NLS_SORT=BINARY), independent
from GERMAN language setting.
When I'm doing a select on a table with values like
A1, A2, ... AA, AB, ... I get the correct result according to binary
sorting.
Yet, if I'm doing this from Tomcat (4.1.24 on WinXP) the data returned
is sorted in GERMAN sorting 
order, i.e. AA, AB, ..., A1, A2, ...

So it seems either Tomcat ignores the setting of the NLS_SORT
environment variable,
or it is implicitly (by Tomcat) or explicitly (by some library code,
which I didn't find yet) overridden.

Anybody got an idea, of which might be the case ?

Thanks in advance,
Harald Henkel

-- 
Harald Henkel

GS automation GmbH
Winterstra├če 2
82223 Eichenau
Germany
Tel:    + 49-8141-35 731-37
Fax:    + 49-8141-35 731-38
Mobile: + 49-178-7829126
e-mail: H.Henkel@GS-automation.DE
Web:    www.GS-automation.DE

---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message