[Seasar-user:21936] Re: S2JDBCでデータ更新順を制御する方法について

[Koichi Kobayashi]

$B>.NS(B (koichik) $B$G$9!#(B

2$B$D$N!VFHN)$7$?!W%H%i%s%6%/%7%g%s(BA$B$H(BB$B$,$"$k>l9g!"(B
$B$=$l$i$rJB9T$K<B9T$7$?7k2L$,(B

1. A$B$r3+;O"*(BA$B$r%3%_%C%H"*(BB$B$r3+;O"*(BB$B$r%3%_%C%H(B
2. B$B$r3+;O"*(BB$B$r%3%_%C%H"*(BA$B$r3+;O"*(BA$B$r%3%_%C%H(B

$B$N!V$I$A$i$+!W$HF1$8$G$"$l$P!"$=$l$O ＠ 5$7$$$H(B
$B$$$&$3$H$K$J$j$^$9!#(B
# $BD>Ns2=2DG=@-(B(serializability)$B$H$$$$$^$9!#(B

A$B$r ＠ h$K3+;O$7$?$J$i(B1$B$HF1$8$G$J$1$l$P$J$i$J$$(B
$B$H$$$&$o$1$G$O$J$/!"$I$A$i$r ＠ h$K3+;O$7$h$&$,!"(B
$B$I$A$i$r ＠ h$K%3%_%C%H$7$h$&$,!">e5-(B1$B$H(B2$B$N(B
$B!V$I$A$i$+!W$HF1$87k2L$K$J$l$P!"$=$l$O(B
$B ＠ 5$7$$$N$G$9!#(B

$B$G$9$+$i!"(BA$B$, ＠ h$K3+;O$7$?>l9g$G$"$C$F$b!"(B
B$B$, ＠ h$K%3%M%/%7%g%s$r<hF@$7$F%3%_%C%H$7$?>l9g$O(B
$B>e5-(B2$B$HF1$87k2L$K$J$C$F ＠ 5$7$$F0:n$H$J$j$^$9!#(B

$B$h$C$F(BS2$B$H$7$F$O%H%i%s%6%/%7%g%s$r3+;O$7$?=gHV$K(B
$B1~$8$F%3%M%/%7%g%s$r3d$jEv$F$k$h$&$J@)8f$O0l ＠ Z(B
$B9T$C$F$$$^$;$s!#(B
Java$B$N%b%K%?(B(synchronized$B%*%V%8%'%/%H(B)$B$r$I$N(B
$B%9%l%C%I$,3MF@$9$k$+$K0MB8$7$^$9!#(B

$B$b$7!"(BA$B$r ＠ h$K3+;O$7$?$J$i(BA$B$, ＠ h$K%3%M%/%7%g%s$r(B
$B<hF@$7$J$1$l$P$J$i$J$$(B($B$*$=$i$/$O%3%_%C%H$b(BA$B$,(B
$B ＠ h$K9T$o$l$J$1$l$P$J$i$J$$(B)$B$N$G$"$l$P!"$=$l$O(B
A$B$H(BB$B$N%H%i%s%6%/%7%g%s$K0MB84X78$,$"$k(B($BFHN)$7$F(B
$B$$$J$$(B)$B$3$H$K$J$j!"%"%W%jB&$G2?$i$+$N@)8f$r$9$k(B
$BI,MW$,$"$j$^$9!#(B
$BJ]<i$H$$$&$3$H$G?'!9Fq$7$$$H$O;W$$$^$9$,!#!#!#(B


On Tue, 26 Aug 2014 20:39:10 +0900, Masaki Chiba <elphas5814 ＠ gmail.com> wrote:

> $B=i$a$^$7$F!"@iMU$H?=$7$^$9!#(B
> $B;d$O!"(BS2JDBC$B$r;HMQ$7$?%7%9%F%`$NJ]<i$r9T$C$F$$$^$9!#(B
> 
> $BJ]<i$GH/@8$7$?%H%i%V%k$NBP1~$K$D$$$F8!F$Cf$J$N$G$9$,!"(B
> S2JDBC$B$K$D$-$^$7$FITL@$JE@$,$"$k$?$a!"<ALd$5$;$FD:$-$^$9!#(B
> 
> $B$*K;$7$$Cf!"BgJQ?=$7Lu$"$j$^$;$s$,!"$465<x$NDx!"59$7$/$*4j$$CW$7$^$9!#(B
> 
> $B<ALdFbMF!"H/@8;v>]$N>\:Y$O0J2<$NDL$j$G$9!#(B
> $B!Z<ALd![(B
> $B-!(BS2JDBC$B$N ＠ _DjJQ99$G%3%M%/%7%g%s<hF@=g$r@)8f2DG=$+!)(B
> $B%H%i%s%6%/%7%g%s3+;O=g$H%3%M%/%7%g%s<hF@=g$,F10l$H$J$k$h$&$K@)8f$9$k;v$O2DG=$G$7$g$&$+!)(B
> 
> $B$d$j$?$$$N$O!"!V(BmaxPoolSize$B!W$rD6$($k%3%M%/%7%g%s<hF@;~!"(B
> $B%H%i%s%6%/%7%g%s$,3+;O$5$l$?=g$K2rJ|$5$l$?%3%M%/%7%g%s$r3d$jEv$F$k$H8@$&;v$G$9!#(B
> 
> $B-"-!$,2DG=$G$"$l$P!"@_DjJ}K!$K$D$$$F$465<x2<$5$$!#(B
> URL$B$r;29M$K$5$;$FD:$-!"!V(BmaxWait$B!W$N ＠ _Dj$,M-8z$G$"$k$H9M$($^$7$?$,!"(B
> $B$3$l$O!"%3%M%/%7%g%s8O3i$7$?>l9g$KBT$D ＠ _Dj$N$?$a!"=gHV$rC4J]$9$k$H$$$&@_Dj$H$O0[$J$k$H9M$($^$7$?!#(B
> 
> <$B3NG'$7$?(BURL>
> http://s2container.seasar.org/2.4/ja/jdbc.html
> 
> $B!Z;v>]![(B
> $B0J2<$NN.$l$G!"(BDB$B99?7$N5UE>$,H/@8$7$^$7$?!#(B
> 1.$BF10l%/%i%$%"%s%H$+$i(BA$B!"(BB$B$N=g$K%G!<%?$r<u?.(B
> 2.$B%H%i%s%6%/%7%g%s(BA$B!"(BB$B$N=g$K3+;O(B
> 3.$BIi2Y$K$h$j0l;~E*$K!V(BmaxPoolSize$B!W$rD6$($k%3%M%/%7%g%s@\B3$,H/@8!"%H%i%s%6%/%7%g%s(BA$B$,%3%M%/%7%g%s<hF ＠ BT$A>uBV$XA+0\(B
> 4.$B%3%M%/%7%g%s2rJ|$5$l$?%?%$%_%s%0$G%H%i%s%6%/%7%g%s(BB$B$,%3%M%/%7%g%s$r<hF@!"%H%i%s%6%/%7%g%s(BA$B$h$jA0$K(BDB$B99?7$r<B;\(B
> 5.$B%H%i%s%6%/%7%g%s(BA$B$,%3%M%/%7%g%s$r<hF@$7!"(BDB$B99?7$r<B;\(B
>  $BK\;v>]$O!"%H%i%s%6%/%7%g%s3+;O$7$?=g$K%3%M%/%7%g%s<hF@=g$r@)8f$G$-$l$P!"(B
> $B2sHr=PMh$kLdBj$H9M$($F$*$j$^$9!#(B
> 
> <DB$B99?7;~$N%m%0FbMF(B>
> DB$B99?7;~$N%m%0=PNOFbMF$G$9!#-$!A-'$G%G!<%?(BB$B$, ＠ h$K%3%M%/%7%g%s<hF@$7!"(BDB$B99?7$, ＠ h$K=hM}$5$l$^$7$?!#(B
> $B-!(BJava$B%"%W%j$+$i99?70MMj(B($B%G!<%?(BA)
> $B-"(BJava$B%"%W%j$+$i99?70MMj(B($B%G!<%?(BB)
> $B-#(BDEBUG TransactionImpl - $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?!#(B($B%G!<%?(BA)
> $B-$(BDEBUG TransactionImpl - $B%H%i%s%6%/%7%g%s$r3+;O$7$^$7$?!#(B($B%G!<%?(BB)
> 
> $B-%(BDEBUG ConnectionPoolImpl - $BO ＠ M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(B($B%G!<%?(BB)
> $B-&(BDEBUG AutoInsertImpl -  DB$B99?7(B($B%G!<%?(BB)
> $B-'(BDEBUG TransactionImpl - $B%H%i%s%6%/%7%g%s$r%3%_%C%H$7$^$7$?!#(B($B%G!<%?(BB)
> $B-((BDEBUG ConnectionWrapperImpl - $BO ＠ M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(B($B%G!<%?(BB)
> 
> $B-)(BDEBUG ConnectionPoolImpl - $BO ＠ M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(B($B%G!<%?(BA)
> $B-*(BDEBUG AutoInsertImpl DB$B99?7(B($B%G!<%?(BA)
> $B-+(BDEBUG TransactionImpl - $B%H%i%s%6%/%7%g%s$r%3%_%C%H$7$^$7$?!#(B($B%G!<%?(BA)
> $B-,(BDEBUG ConnectionWrapperImpl - $BO ＠ M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(B($B%G!<%?(BA)
> 
> $B!Z4D6-![(B
> Java$B%"%W%j%1!<%7%g%s%5!<%P$r9=C[!"(B
> S2JDBC$B$r;HMQ$7!"(BDB$B99?7=hM}$r<BAu$7$F$*$j$^$9!#(B
> 
> <OS>
> Linux Red Hat Enterprise Linux 5.5($B%+!<%M%k%P!<%8%g%s!'(B2.6.18-194.el5PAE)
> 
> <$B%"%W%j%1!<%7%g%s9=@.(B>
> $B!&(BJava 1.5
> $B!&(BPostgreSQL 8.4
> $B!&(BS2JDBC
> 
> <jdbc.dicon$B ＠ _Dj(B>
> $B!&(BmaxPoolSize 10
> $B!&(BmaxWait $BDj5A$J$7(B
> 
> $B>pJs$,ITB-$7$F$$$k$h$&$J$i!"$4;XE&$/$@$5$$!#(B
> 
> $B$^$?!"4{=P$NLdBj$G$4$6$$$^$7$?$iBgJQ?=$7Lu$"$j$^$;$s!#(B
> 
> $B$43NG'$h$m$7$/$*4j$$CW$7$^$9!#(B
> 
> $B0J>e$G$9!#(B


-- 
{
  name: "Koichi Kobayashi",
  mail: "koichik ＠ improvement.jp",
  blog: "http://d.hatena.ne.jp/koichik/",
  twitter: "@koichik"
}