<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:$B%a%$%j%*(B
}
</style>
</head>
<body class='hmmessage'>
$B>.NS(B (koichik) $BMM(B<br><br>$BAaB.$NJV?.!"$"$j$,$H$&$4$6$$$^$9!#(B<br>$B7k2L$H$7$F$O$^$@2r7h$7$F$$$J$$>uBV$H$J$C$F$*$j$^$9!#(B<br><br>$BA02sBP1~$7$F$$$?$@$$$?7o$K$D$$$F;d$NJ}$N8@MUB-$i$:$JE@$,(B<br>$B$"$j$^$7$?$N$G%$%s%i%$%s$K$F$4Js9p$5$;$F$$$?$@$-$^$9!#(B<br><br>> Date: Fri, 1 May 2009 00:00:02 +0900<br>> From: koichik@improvement.jp<br>> To: seasar-user@ml.seasar.org<br>> Subject: [Seasar-user:17352] Re: $B%H%i%s%6%/%7%g%s=hM}$K$D$$$F(B<br>><br>> $B>.NS(B (koichik) $B$G$9!%(B<br>><br>> Date: Thu, 30 Apr 2009 22:18:13 +0900<br>> From: $B4d85(B $B$b$!!<$#(B <immobility323@hotmail.co.jp><br>> To: <seasar-user@ml.seasar.org><br>> Subject: [Seasar-user:17350] $B%H%i%s%6%/%7%g%s=hM}$K$D$$$F(B<br>><br>> > $B#1%H%i%s%6%/%7%g%s$N=hM}$O0J2<$NDL$j$G$9!#(B<br>> ><br>> > 1.$B$"$k%F!<%V%k$N$"$k9`L\$N:GBgCM!J%+%&%s%?$_$?$$$J$b$N!K$r<hF@$9$k!#(B<br>> > 2.$B<hF@$7$?FbMF$r%$%s%/%j%a%s%H$9$k!#(B<br>> > 3.2$B$G%$%s%/%j%a%s%H$7$?9`L\$r%-!<$H$7$F(B2$B$D$N%F!<%V%k!J(B1$B$N%F!<%V%k$r4^$`!K$K(BInsert$B$r9T$&!#(B<br>> > 4.3$B$G(BInsert$B$7$?FbMF$r<hF@$7$F!"2hLL$KI=<($9$k!#(B<br>><br>> $B$3$N$d$jJ}$@$HJ#?t$N%H%i%s%6%/%7%g%s$,JB9T$K(B<br>> $B<B9T$5$l$?>l9g!$(B1 $B$GF1$8CM$rFI$_<h$C$F$7$^$$!$(B<br>> 3 $B$GF1$8%-!<$r;}$D%l%3!<%I$r(B insert $B$7$F$7$^$$$^$9!%(B<br>> $B$J$N$G!$(B<br>><br>> > $B8=:_5/$-$F$$$k8=>]$O!"=hM}(B3$B$G<B;\$7$?(Bsave()$B$,=hM}(B4$B$N(BcreateQuery$B<B9T;~$KH?1G$5$l$F$$$k$h$&$G(B<br>> > $B%(%i!<$,H/@8$7$J$$4V$OLdBj$J$$$N$G$9$,!"0lEY%(%i!<$,H/@8$9$k$H=hM}(B1$B$N(BcreateQuery$B<B9T;~$K(B<br>> > ERROR: duplicate key value violates unique constraint "aaaaa_bbbbb_pkey"$B$,H/@8$7!"(B<br>> > $B$=$l0J9_$N=hM}A4$F$r<B9T$9$k$3$H$,$G$-$J$$>uBV$H$J$C$F$$$^$9!#(B<br>> ><br><br><br><br>$B0lEY%(%i!<$,H/@8$9$k$H=hM}(B3$B$G<B;\$7$?(Bsave()$B$NFbMF$,;D$C$F$$$k$h$&$G!"(B<br>$B%(%i!<$,H/@8$7$?8e$K9T$o$l$k%H%i%s%6%/%7%g%s$N=hM}(B1$B$N(B<br>createQuery$B<B9T;~$K(BInsert$B$H$7$F=hM}$5$l$F$7$^$&$?$a$K!"(B<br>ERROR: duplicate key value violates unique constraint "aaaaa_bbbbb_pkey"$B$r(B<br>$BH/@8$5$;!"$=$l0J9_$N=hM}(B(1$B!A(B4)$BA4$F$r7QB3$G$-$J$/$J$k>uBV$G$9!#(B<br><br><br><br><br>> > $B:G=i$K=PNO$5$l$k%(%i!<FbMF$O0J2<$NDL$j$G$9!#(B<br>> ><br>> > [ESSR0072]SQL$B$GNc30(B(SQL=[insert into *******_t_answer_history (answer_starttime, answer_endtime, get_total_score, right_per_answer, necessary_time, pass_ornot, add_user, update_user, user_id, lesson_id, answer_count) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)], ErrorCode=0, SQLState=23505)$B$,H/@8$7$^$7$?(B<br>> > ERROR: duplicate key value violates unique constraint "*******_t_answer_history_pkey"<br>><br>> $B$H$J$j$^$9!%(B<br>> 1 $B$G(B select $B!A(B for update $B$r;H$&$+!$(B2 $B$N(B update $BJ8$N(B<br>> where $B$K99?7A0$N%+%&%s%?$NCM$r4^$a$F99?7$G$-$?9T?t$r(B<br>> $B%A%'%C%/$9$k(B (0 $B9T$N>l9g$O%j%H%i%$$9$k(B) $B$J$I$7$F$/$@$5$$!%(B<br>><br>> > $BBgJQ62=L$G$9$,!"0J2<$N(Bdicon$B%U%!%$%k$r4p$K%H%i%s%6%/%7%g%s=hM}$r3NG'$7$?$H$3$m!"(B<br>> > $B2<5-%m%0$N$h$&$J%(%i!<$,H/@8$7$F$$$k$N$G$9$,!"$=$N>l9g$N=$@5J}K!$r$465<x4j$($^$;$s$G$7$g$&$+!#(B<br>> ($BN,(B)<br>> > org.seasar.framework.exception.InvocationTargetRuntimeException: [ESSR0043]com.*******.signup.service.ConfirmServiceImpl$$EnhancedByS2AOP$$47b232 $B$,8F$S=P$7$?BP>]$,IT@5$G$9!#M}M3$O(Borg.seasar.framework.exception.SIllegalStateException: [ESSR0311]$B%H%i%s%6%/%7%g%s$,3+;O$5$l$F$$$^$;$s(B<br>><br>> $B$3$N%a%C%;!<%8$OJ8;zDL$j%H%i%s%6%/%7%g%s$r3+;O$;$:$K(B<br>> JDBC $B%3%M%/%7%g%s$r<hF@$7$?>l9g$K%9%m!<$5$l$^$9!%(B<br>> j2ee.dicon $B$N(B<br>><br>> > <component name="connectionPool"<br>> > class="org.seasar.extension.dbcp.impl.ConnectionPoolImpl"><br>> > <property name="timeout">600</property><br>> > <property name="maxPoolSize">30</property><br>> > <property name="allowLocalTx">false</property><br>><br>> $B$3$N(B allowLocalTx $B$,(B true ($B%G%U%)%k%H(B) $B$N>l9g$O(B<br>> $B%H%i%s%6%/%7%g%s$,3+;O$5$l$F$$$J$/$F$b!$<+F0(B<br>> $B%3%_%C%H%b!<%I$N%3%M%/%7%g%s$r<hF@$9$k$3$H$,(B<br>> $B$G$-$^$9!%(B<br>><br>> $B$7$+$7!$$3$N(B j2ee.dicon $B$G$O(B allowLocalTx $B$,(B<br>> false $B$G$"$k$?$a!$Nc30$,%9%m!<$5$l$^$9!%(B<br>><br>> > at com.*******.signup.service.ConfirmServiceImpl.<init>(ConfirmServiceImpl.java:35)<br>><br>> $B$3$N%/%i%9$N%3%s%9%H%i%/%?$G(B Hibernate $B$N(B Session $B$r(B<br>> $B;HMQ$7$F$$$^$9$,!$%H%i%s%6%/%7%g%s$,3+;O$5$l$F(B<br>> $B$$$J$$$N$,860x$G$9!%(B<br>><br>> $B%3%s%9%H%i%/%?$KBP$7$F$O@k8@E*%H%i%s%6%/%7%g%s$O(B<br>> $BE,MQ$G$-$J$$$N$G!$%3%s%9%H%i%/%?$G(B Hibernate Session $B$r(B<br>> $B;HMQ$9$k$N$r$d$a$k$+!$<jF0$G%H%i%s%6%/%7%g%s$r3+;O$9$k$+!$(B<br>> j2ee.dicon $B$G(B allowLocalTx $B$r(B true $B$K$9$k$+$7$F$/$@$5$$!%(B<br>><br><br><br><br><property name="allowLocalTx">false</property>$B$K$D$$$F$O(B<br><br>http://ml.seasar.org/archives/seasar-user/2006-July/004117.html<br><br>$B$N%Z!<%8$r;29M$K$5$;$F$$$?$@$$$F@_Dj$r9T$C$?ItJ,$H$J$C$F$*$j$^$9!#(B<br><br>$B8=:_$NLdBj$O!"(B<br><br>> $B%3%s%9%H%i%/%?$G(B Hibernate Session $B$r;HMQ$9$k$N$r$d$a$k(B<br>> $B<jF0$G%H%i%s%6%/%7%g%s$r3+;O$9$k(B<br><br>$B$HJV?.$$$?$@$$$?$N$G$9$,!"6qBNE*$K$I$N$h$&$KBP=h$9$l$P$$$$$N$+(B<br>$BJ,$+$i$J$$>uBV$H$J$C$F$*$j$^$9!#(B<br><br>$B$b$7!"$h$m$7$1$l$P;29M$N%5%$%HEy$r$4Ds<(4j$($^$;$s$G$7$g$&$+!#(B<br><br>$B2?B4$h$m$7$/$*4j$$$$$?$7$^$9!#(B<br><br>><br>> --<br>> <component name="koichik"><br>> <property name="fullName">"Koichi Kobayashi"</property><br>> <property name="email">"koichik@improvement.jp"</property><br>> <property name="blog">"http://d.hatena.ne.jp/koichik"</property><br>> </component><br>><br>> _______________________________________________<br>> Seasar-user mailing list<br>> Seasar-user@ml.seasar.org<br>> https://ml.seasar.org/mailman/listinfo/seasar-user<br><br><br /><hr />Hotmail$B;K>e:GB.!*$5$i$KMFNLL5@)8B$K!*(B <a href='http://clk.atdmt.com/GBL/go/139457978/direct/01/' target='_new'>$B?J2=$7$?(BHotmail$B$r:#$9$0;n$7$F$_$k(B</a></body>
</html>