Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Message-ID: <000901c5632e$71069770$2000a8c0@Arkat>
From: "TomohitoNakayama" <tomonaka@basil.ocn.ne.jp>
To: "Derby Development" <derby-dev@db.apache.org>
References: <001801c562f7$23798da0$2000a8c0@Arkat>
Subject: Re: All of derby_all fails when environment corresponding
 derbyLocale_**.jar exists in CLASSPATH
Date: Sat, 28 May 2005 11:39:11 +0900
Mime-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; format=flowed; charset=iso-2022-jp;
 reply-type=response

Hello.


I tried to execute derby_all again without derbyLocale_ja.jar and found next 
tests are failed.


derbyall/derbyall.fail:jdbcapi/parameterMapping.java
derbyall/derbyall.fail:i18n/urlLocale.sql
derbyall/derbyall.fail:i18n/messageLocale.sql
derbyall/derbyall.fail:i18n/iepnegativetests_ES.sql
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/NSinSameJVM.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/maxthreads.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/runtimeinfo.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/sysinfo.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/testProperties.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/testconnection.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/timeslice.java
derbyall/derbynetmats/derbynetmats.fail:derbynet/NSinSameJVM.java
derbyall/derbynetmats/derbynetmats.fail:derbynet/maxthreads.java
derbyall/derbynetmats/derbynetmats.fail:derbynet/runtimeinfo.java
derbyall/derbynetmats/derbynetmats.fail:derbynet/sysinfo.java
derbyall/derbynetmats/derbynetmats.fail:derbynet/testProperties.java
derbyall/derbynetmats/derbynetmats.fail:derbynet/testconnection.java
derbyall/derbynetmats/derbynetmats.fail:derbynet/timeslice.java


Seeing their **.diff, next contains difference caused by locale problem.

derbyall/derbyall.fail:i18n/messageLocale.sql
derbyall/derbyall.fail:i18n/iepnegativetests_ES.sql
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/NSinSameJVM.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/maxthreads.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/runtimeinfo.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/sysinfo.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/testProperties.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/testconnection.java
derbyall/derbynetclientmats/derbynetmats.fail:derbynet/timeslice.java


Taking aside testing barrier, almost all of these locale problem seems not 
so harmful.
Generated messages was reasonable as Japanese message.

But derbyall/derbyall.fail:i18n/iepnegativetests_ES.sql, some characters are 
corrupted.

For example...
 47a47
> ERROR XIE0J: Un delimitador no es v?lido o se ha utilizado m?s de una vez.
51 del
< ERROR XIE0J: Un delimitador no es v EnC:>225< lido o se ha utilizado m 
EnC:>225< s de una vez.


I think we can avoid this testing problem in SunVM configuring sytem 
property of user.language/user.country/user.variant.

http://java.sun.com/j2se/corejava/intl/reference/faqs/index.html :
Can I set the default locale from outside an application?
This depends on the implementation of the Java platform you're using. The 
initial default locale is normally determined from the host operating 
system's locale. Versions 1.4 and higher of Sun's JREs let you override this 
by setting the user.language, user.country, and user.variant system 
properties from the command line. For example, to select Locale("th", "TH", 
"TH") as the initial default locale, you would use:
java -Duser.language=th -Duser.country=TH -Duser.variant=TH MainClass
Since not all runtime environments provide this feature, it should only be 
used for testing.

But there remains unclearness around other vm .....

Best regards.

/*

         Tomohito Nakayama

         tomonaka@basil.ocn.ne.jp
         tomohito@rose.zero.ad.jp

         Naka
         http://www5.ocn.ne.jp/~tomohito/TopPage.html

*/
----- Original Message ----- 
From: "TomohitoNakayama" <tomonaka@basil.ocn.ne.jp>
To: "Derby Development" <derby-dev@db.apache.org>
Sent: Saturday, May 28, 2005 5:03 AM
Subject: All of derby_all fails when environment corresponding 
derbyLocale_**.jar exists in CLASSPATH


> Hello.
>
> I executed derby_all with new configuration and found this phenomena.
>
> Adding derbyLocale_ja_JP.jar to classpath and ,
> all of derby_all was failed because all result message was generated in 
> Japanese ....
>
> I didn't realized this , because I had not included derbyLocale_ja_JP.jar 
> to classpath before ....
>
> //Further more,from this time , environment variable "LANG" was set to 
> "en" as next ....
> //LANG="en"
> //This configuration was done to avoid lang problem of "svn diff" around 
> upgraded subversion, 1.2.0.
> //But it does not work for derby.
> //I wonder how programs judges locale information ...
> //System property in JDK ....?
>
> I think this is bug around test itself ......
>
> Best regards.
>
> /*
>
>         Tomohito Nakayama
>         tomonaka@basil.ocn.ne.jp
>         tomohito@rose.zero.ad.jp
>
>         Naka
>         http://www5.ocn.ne.jp/~tomohito/TopPage.html
>
> */
>
>
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.322 / Virus Database: 267.0.0 - Release Date: 2005/05/27
>
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.322 / Virus Database: 267.0.0 - Release Date: 2005/05/27
>
> 


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.322 / Virus Database: 267.2.0 - Release Date: 2005/05/27