Re: Data sorting problem Tomcat-Oracle
Tim Funk wrote: Tomcat knows nothing about NLS_SORT. Odds are NLS_SORT is probably not set when running on XP. ??? Oracle usually sets values in the registry, and by default only NLS_LANG, from which the other values are derived. If you want to change the defaults, you could either define registry entries for those, or set environment variables. I use Tomcat as service on NT. Could it be, that it doesn't get the System environment varible ? I will try starting Tomcat from the CMD. Regards, Harald Henkel -Tim Harald Henkel wrote: 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- 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: [EMAIL PROTECTED] Web:www.GS-automation.DE - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Data sorting problem Tomcat-Oracle
Ahhh. The archives have a lot of references about System environment variables not being set when run as a service. If you are using the type 4 driver - I don't think it looks for Environment variables or the registry since the driver is pure java. Oracle's support would probably be more helpful for the appropriate connection string. (Or setting) -Tim Harald Henkel wrote: Tim Funk wrote: Tomcat knows nothing about NLS_SORT. Odds are NLS_SORT is probably not set when running on XP. ??? Oracle usually sets values in the registry, and by default only NLS_LANG, from which the other values are derived. If you want to change the defaults, you could either define registry entries for those, or set environment variables. I use Tomcat as service on NT. Could it be, that it doesn't get the System environment varible ? I will try starting Tomcat from the CMD. Regards, Harald Henkel -Tim Harald Henkel wrote: 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Data sorting problem Tomcat-Oracle
Hello Tim. Thanks, I got at last a working solution. Tim Funk wrote: Ahhh. The archives have a lot of references about System environment variables not being set when run as a service. I guess it doesn't have too much to do with that. I now tested running it standalone. If you are using the type 4 driver - I don't think it looks for Environment variables or the registry since the driver is pure java. Oracle's support would probably be more helpful for the appropriate connection string. (Or setting) That was a good hint. Indeed I'm usually using a Jdbc Thin driver and I looked into some Oracle newsgroup. I tried starting Tomcat standalone adding a -Duser.language=en into the java starting command. And this works. Again, thanks for the hint, I wasted a lot of time on this one. Should really ask earlier. With kind regards, Harald Henkel -Tim Harald Henkel wrote: Tim Funk wrote: Tomcat knows nothing about NLS_SORT. Odds are NLS_SORT is probably not set when running on XP. ??? Oracle usually sets values in the registry, and by default only NLS_LANG, from which the other values are derived. If you want to change the defaults, you could either define registry entries for those, or set environment variables. I use Tomcat as service on NT. Could it be, that it doesn't get the System environment varible ? I will try starting Tomcat from the CMD. Regards, Harald Henkel -Tim Harald Henkel wrote: 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- 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: [EMAIL PROTECTED] Web:www.GS-automation.DE - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Data sorting problem Tomcat-Oracle
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: [EMAIL PROTECTED] Web:www.GS-automation.DE - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Data sorting problem Tomcat-Oracle
Tomcat knows nothing about NLS_SORT. Odds are NLS_SORT is probably not set when running on XP. -Tim Harald Henkel wrote: 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 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]