[Seasar-user:21163] Re: 特定の言語に対する「ALTER SESSION SET NLS_*」発行後に検索用のDAOメソッドを実行するとエラーが発生する。

[Hiroyuki Ohnaka]

$BBgCf(B($B$;$H(B)$B$G$9!#(B

$B?dB,$K$J$j$^$9$,(B...

Oracle$B$N%G!<%?%Y!<%9$N(BNLS*$B4XO"$N%Q%i%a!<%?$H(BJVM$B$N%m%1!<%k$,%^%C%A(B
$B$7$F$$$F$$$J$$$3$H$,860x$J2DG=@-$,$"$j$^$9!#(B

($B%+%i%`>pJs$r3JG<$9$k(B org.seasar.framework.util.CaseInsensitiveMap $B$G(B
$B%G%U%)%k%H%m%1!<%k$G(B toLowerCase $B$7$F$$$k$?$a(B)

$B0J2<$NJ}K!$G(BJVM$B$N%m%1!<%k$[E-MAIL ADDRESS DELETED]$J$N$KJQ99$9$k$H$I$&$J$j$^$9!)(B

http://d.hatena.ne.jp/yehara/20090122/1232589563

2011$BG/(B11$B7n(B16$BF|(B23:45 toshio akasaka <[E-MAIL ADDRESS DELETED]>:
> akasaka$B$H?=$7$^$9!#(B
>
> $B0J2<$rMxMQ$7$F%"%W%j%1!<%7%g%s3+H/$r$7$F$*$j$^$9!#(B
> Seaser2-2.4.39
> SAStruts-1.0.4-sp5
> S2Dao-1.0.49
>
> $B$^$?F0:n4D6-$O0J2<$NDL$j$G$9!#(B
> OS$B!'(BWindowsXP
> AP$B%5!<%P!<!'(BTomcat6
> DB$B!'(BOracle 10g Express
>
> $B"!LdBj(B
> $BFCDj$[E-MAIL ADDRESS DELETED]$KBP$9$k!V(BALTER SESSION SET NLS_*$B!WH/9T8e$K8!:wMQ$N(BDAO$B%a%=%C%I$r<B9T$9$k$H%(%i!<$,H/@8$9$k!#(B
>
> $B"!:F8=<j=g(B
> $B-!9q:]2=BP1~$N$?$a!"0J2<$N(BSQL$B$r<B9T$7$^$9!#(B
> ALTER SESSION SET NLS_SORT = 'CANADIAN FRENCH';
> ALTER SESSION SET NLS_COMP = 'LINGUISTIC';
>
> $B-"-!8e!"(BDAO$B$N8!:w=hM}$r9T$&$H0J2<$N%(%i!<$,H/@8$7$^$9!#(B
>
> $B%(%i!<FbMF$O0J2<$NDL$j$G$9!#(B
> #############################################################
> WARN  ,$B%F!<%V%k(B(XXX)$B$,8+$D$+$j$^$;$s(B
>
> org.seasar.dao.MethodSetupFailureRuntimeException:
> [EDAO0019]xxxDao$B$N(Bupdate$B%a%=%C%I$N=i4|2=;~$KNc30$,H/@8$7$^$7$?!#M}M3$O(Borg.seasar.dao.MethodSetupFailureRuntimeException:
> [EDAO0019]xxxDao$B$N(Bupdate$B%a%=%C%I$N=i4|2=;~$KNc30$,H/@8$7$^$7$?!#M}M3$O(Borg.seasar.framework.exception.SRuntimeException:
> [EDAO0020]Primary Key$B$N$_$N%F!<%V%k$r(BSQL$BJ8$N<[E-MAIL ADDRESS DELETED]@.$G99?7$9$k$3$H$O$G$-$^$;$s(B
>  at
> org.seasar.dao.impl.DaoMetaDataImpl.setupMethod(DaoMetaDataImpl.java:219)
>  at
> org.seasar.dao.impl.DaoMetaDataImpl.setupMethod(DaoMetaDataImpl.java:187)
>  at
> org.seasar.dao.impl.DaoMetaDataImpl.setupSqlCommand(DaoMetaDataImpl.java:171)
>  at org.seasar.dao.impl.DaoMetaDataImpl.initialize(DaoMetaDataImpl.java:162)
>  at
> org.seasar.dao.impl.DaoMetaDataFactoryImpl.createDaoMetaData(DaoMetaDataFactoryImpl.java:167)
>  at
> org.seasar.dao.impl.DaoMetaDataFactoryImpl.getDaoMetaData(DaoMetaDataFactoryImpl.java:131)
>  at
> org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:51)
>  at
> org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java:71)
>  at
> org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:53)
>  at
> org.seasar.framework.container.customizer.AspectCustomizer$LookupAdaptorInterceptor.invoke(AspectCustomizer.java:198)
> Caused by: org.seasar.framework.exception.SRuntimeException:
> [EDAO0020]Primary Key$B$N$_$N%F!<%V%k$r(BSQL$BJ8$N<[E-MAIL ADDRESS DELETED]@.$G99?7$9$k$3$H$O$G$-$^$;$s(B
>  at
> org.seasar.dao.impl.AbstractAutoStaticCommand.setupUpdatePropertyTypes(AbstractAutoStaticCommand.java:111)
>  at
> org.seasar.dao.impl.UpdateAutoStaticCommand.setupPropertyTypes(UpdateAutoStaticCommand.java:46)
>  at
> org.seasar.dao.impl.AbstractAutoStaticCommand.<init>(AbstractAutoStaticCommand.java:45)
>  at
> org.seasar.dao.impl.UpdateAutoStaticCommand.<init>(UpdateAutoStaticCommand.java:33)
>  at
> org.seasar.dao.impl.DaoMetaDataImpl.createUpdateAutoStaticCommand(DaoMetaDataImpl.java:589)
>  at
> org.seasar.dao.impl.DaoMetaDataImpl.setupUpdateMethodByAuto(DaoMetaDataImpl.java:574)
>  at
> org.seasar.dao.impl.DaoMetaDataImpl.setupMethodByAuto(DaoMetaDataImpl.java:385)
>  at
> org.seasar.dao.impl.DaoMetaDataImpl.setupMethod(DaoMetaDataImpl.java:216)
>  ... 195 more
> #############################################################
>
> $B>e5-$N>l9g!"(BXXX$B%F!<%V%k$N%a%?%G!<%?$N<hF@$K<:GT$7$F$$$k$h$&$G$9!#(B
> $B:#$N$H$3$m!"!V(BNLS_COMP$B!W$,!V(BLINGUISTIC$B!W$+$D!V(BNLS_SORT$B!W$,!V(BCANADIAN FRENCH$B!W$N>l9g$N$_H/@8$9$k$h$&$G$9!#(B
>
> $B860x$HBP1~J}K!$r$465<(4j$($^$;$s$G$7$g$&$+!)(B
>
> $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>
>