Hello, Chris ! I applied settings you adviced: ++++Don't you want user.langauge=RU user.country=kz?
[oracle@n36 logs]$ echo $JAVA_OPTS -XX:MaxPermSize=128M -Xms256m -Xmx1024m -Duser.language=RU -Duser.country=kz But our java-application gives the following message: 15.01.2014 21:41:01 org.apache.catalina.core.ApplicationContext log MESSAGE = ORA-00604: error occurred at recursive SQL level 1 ORA-12705: invalid or unknown NLS parameter value specified , ERRORCODE = 604 ++++So, there can be problems in a couple of places. If you have an ++++extended characters correctly-stored in the Oracle database, will it ++++display correctly if you try to show it on a web page? Let's make sure ++++that works first, then we'll tackle submitting such characters via forms. ++++Note that using extended characters in GET requests is a nightmare: ++++you should try to avoid it at all costs. There are two state languages in Kazakhstan - Russian and Kazakh and both must be supported. Our Oracle database works in single-byte cyrillic encoding and its size is up to 1 tB now. If we convert one to Unicode it will be ~2 tB which is impossible for us as no disk space. Our java servlet was created based on Oracle UIX technology which is old enough. Within seven years we successfully use this servlet with Oracle Application Server 10g R2/R3 (now OAS 10.1.3.5). There are not any troubles with Kazakh letters displaying on web-pages with Oracle Application Server. But Tomcat gives troubles with Kazakh letters displaying. What difference between Oracle Application Server and Tomcat in characters processing ? In production we still use this servlet with Oracle Application Server. I can see any its settings if you tell me which ones to check. >From Tomcat doc I see that we can convert GET-request to specified code page by using "URIEncoding" in http-connector definition of server.xml. I have tried to use the followng: <Connector port="7785" protocol="HTTP/1.1" connectionTimeout="20000" redirectPort="8443" URIEncoding="Cp1251" <-- also tried Windows-1251, WINDOWS-1251, CP1251 useBodyEncodingForURI="true"/> <--also tried without this one May be we must do some tracing to understand the root of the trouble ? Thank you for your helping me. Waiting for your advices, Timur 2014/1/14 Christopher Schultz <ch...@christopherschultz.net> > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA256 > > Тимур, > > On 1/14/14, 2:44 AM, Тимур Кулибаев wrote: > > The "user.language" and "user.country" system properties for my > > running Tomcat instance are not set. > > They must be set to something. If you are not explicitly-setting them, > then they are defaulting to something, negotiated by the OS and the JVM. > > > In Oracle Apllication Server I also do not see these properties set > > in "ps -ef | grep java" output. I set both properties in JAVA_OPTS > > env.var: > > > > [oracle@n36 logs]$ echo $JAVA_OPTS -XX:MaxPermSize=128M -Xms256m > > -Xmx1024m -Duser.language=ru -Duser.country=RU > > > > Check whether java process has these settings: [oracle@n36 logs]$ > > ps -ef | grep java oracle 17311 1 18 13:31 pts/0 00:00:41 > > > /u02/apache_software/apache-tomcat-7.0.47/apache-tomcat-7.0.47/jdk-6u38-linux/jdk1.6.0_38/bin/java > > > > > - > > -Djava.util.logging.config.file=/u02/apache_software/apache-tomcat-7.0.47/apache-tomcat-7.0.47/conf/logging.properties > > -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager > > -XX:MaxPermSize=128M -Xms256m -Xmx1024m -Duser.language=ru > > -Duser.country=RU > > > -Djava.endorsed.dirs=/u02/apache_software/apache-tomcat-7.0.47/apache-tomcat-7.0.47/endorsed > > > > > - -classpath > > > /u02/apache_software/apache-tomcat-7.0.47/apache-tomcat-7.0.47/bin/bootstrap.jar:/u02/apache_software/apache-tomcat-7.0.47/apache-tomcat-7.0.47/bin/tomcat-juli.jar > > > > > - > > -Dcatalina.base=/u02/apache_software/apache-tomcat-7.0.47/apache-tomcat-7.0.47 > > > -Dcatalina.home=/u02/apache_software/apache-tomcat-7.0.47/apache-tomcat-7.0.47 > > > > > - > > -Djava.io.tmpdir=/u02/apache_software/apache-tomcat-7.0.47/apache-tomcat-7.0.47/temp > > org.apache.catalina.startup.Bootstrap start oracle 17369 17164 0 > > 13:35 pts/0 00:00:00 grep java > > > > After setting "user.language" and "user.country" I tested servlet > > on Tomcat 7 again but it didn't help, trouble persists. What else > > are to be fixed in Tomcat conf ? > > Don't you want user.langauge=RU user.country=kz? > > If your computer is already set up to use that special addition to > WINDOWS-1215, then you should probably be good to go. > > > PS: I'm in Kazakhstan, at GMT+6, so sorry for delay with answer. > > It's no problem at all. > > So, there can be problems in a couple of places. If you have an > extended characters correctly-stored in the Oracle database, will it > display correctly if you try to show it on a web page? Let's make sure > that works first, then we'll tackle submitting such characters via forms. > > Note that using extended characters in GET requests is a nightmare: > you should try to avoid it at all costs. > > - -chris > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1 > Comment: GPGTools - http://gpgtools.org > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > > iQIcBAEBCAAGBQJS1VXKAAoJEBzwKT+lPKRYJOsP/13p6CoZ9sJ9oHq9ErHkiyqD > j3zf8+gTbqEt+bUlQwlc8gy1rVBX3VO+GxIW0f0q8RDwDKwu16fn7KOWp31o6fxV > RO/FFvUNZCC4glbvm0Gc40VcpKbCfTkfEVL3g4YKHclYns2cInFsB9IeoOyeFuea > jJd0w0SEF1K8207ZWzx9zog5gpboN5y3piAXaESUI4y1g0V4ppp0+ESGlc5GJrnb > cZZ8bW4o8TXE2/kwMXcqI3E+R3L70yHnRTUV9cyhKbI7BAeTniHsDrFCcfx49uab > FQwocb1//ELHmCQDvSkaXF6ztfNuAf/uLTWNk84CyvFWEvgK/gm5uXDBH5zfbyym > kQEpaheNcUPrWqkXmw4L8QF8wPx7LeY2GEnyNslvkHVxAetswSn8S2kjgvwCcL98 > s5AumzoGipuqflP5ZI0qPEBuQg9r1BKr7E2oeFrsrgMk7CPRDdF2BpFQtik2xiKq > evuhgMmnCnI6+ZIqEtccwOtpJcybotBtfVBrbXYiIZ7tEZ6hT8OQ4fRmftMu0Hhf > 310wS57v8Yf+yKOs27GDb1camjrIn3kK1wla5p/l02V5/nkHo/o1eozZguRLT75w > aMJ0d0SCb4vcWg0kaqBETBr/bbDKqTUeYK6jhFkvD1YVy6gHXIDkW6Xj9rOXvQ8r > Hj0dCfstr13lWP5tmyHl > =wDf6 > -----END PGP SIGNATURE----- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
