$BJV?.CY$/$J$j$^$7$F?=$7Lu$"$j$^$;$s!#(B $B$d$^$J$+$G$9!#(B RDB$B$O(BDB2$B!"(BJDBC$B%I%i%$%P$O(BType4$B!J(Bcom.ibm.db2.jcc.DB2Driver$B!K$r;HMQ$7$F$*$j$^$9!#(B DefaultPagerCondition$B$r;HMQ$7!"$+$D(BFOR UPDATE$B$r;HMQ$7$?>l9g$K=P$k%(%i!<$N(B $B%9%?%C%/%H%l!<%9$O2<5-$K$J$j$^$9!#(B (0) [ESSR0071]SQL$B$GNc30(B(ErrorCode=-228, SQLState=42620)$B$,H/@8$7$^$7$?!#(B $BM}M3$O(Borg.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[select   aaa,bbb  from   xx where   aaa = ? for update with rs], Error org.seasar.framework.exception.SQLRuntimeException: [ESSR0071]SQL$B$GNc30(B(ErrorCode=-228, SQLState=42620)$B$,H/@8$7$^$7$?!#(B $BM}M3$O(Borg.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[select    aaa,    bbb  from    xx  where    ship_aaa = ?  for update with rs], ErrorCode=-228, SQLState=42620)$B$,H/@8$7$^$7$?(B      at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:37)      at org.seasar.extension.jdbc.impl.BasicResultSetFactory.createResultSet(BasicResultSetFactory.java:36)      at org.seasar.dao.pager.PagerResultSetFactoryWrapper.createResultSet (PagerResultSetFactoryWrapper.java:63)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.createResultSet(BasicSelectHandler.java:173)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java :162)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:135)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:120)      at org.seasar.dao.impl.SelectDynamicCommand.execute (SelectDynamicCommand.java:55)      at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)      at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java :64)      at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43)      at org.seasar.framework.aop.interceptors.InterceptorChain.invoke(InterceptorChain.java:42)      at jp.co.hoge.dao.XXDao$$EnhancedByS2AOP$$c1758fd$$MethodInvocation$$findXX2.proceed ()Ljava.lang.Object;(MethodInvocationClassGenerator.java:???)      at jp.co.hoge.dao.XXDao$$EnhancedByS2AOP$$c1758fd.findXX(Ljp.co.hoge.domain.XX;)Ljp.co.hoge.domain.XX;(XXDao$$EnhancedByS2AOP$$c1758fd.java:???)      at jp.co.hoge.service.XXServiceImpl.serchXX(XXServiceImpl.java:319)      at jp.co.hoge.service.XXServiceImpl$$EnhancedByS2AOP$$c1eb4c4.serchXX$$invokeSuperMethod$$(Ljp.co.hoge.dto.XXDto;)Ljp.co.hoge.dto.XXDto;(XXServiceImpl$$EnhancedByS2AOP$$c1eb4c4.java:???)      at jp.co.hoge.service.XXServiceImpl$$EnhancedByS2AOP$$c1eb4c4$$MethodInvocation$$serchXX0.proceed()Ljava.lang.Object;(MethodInvocationClassGenerator.java:???)      at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed (NestedMethodInvocation.java:45)      at jp.co.hoge.aop.XXBeforeAdvice.invoke(XXBeforeAdvice.java:82)      at jp.co.hoge.aop.XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f.invoke$$invokeSuperMethod$$(Lorg.aopalliance.intercept.MethodInvocation ;)Ljava.lang.Object;(XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f.java:???)      at jp.co.hoge.aop.XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f$$MethodInvocation$$invoke0.proceed()Ljava.lang.Object;(MethodInvocationClassGenerator.java:??? )      at org.seasar.framework.aop.interceptors.InterceptorLifecycleAdapter.invoke(InterceptorLifecycleAdapter.java:45)      at jp.co.hoge.aop.XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f$$MethodInvocation$$invoke0.proceed ()Ljava.lang.Object;(MethodInvocationClassGenerator.java:???)      at jp.co.hoge.aop.XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f.invoke(Lorg.aopalliance.intercept.MethodInvocation;)Ljava.lang.Object;(XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f.java:???)      at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43)      at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:40)      at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed (NestedMethodInvocation.java:43)      at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:50)      at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java :43)      at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:50)  Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[select    aaa,    bbb  from    xx  where    aaa = ?  for update with rs], ErrorCode=-228, SQLState=42620)$B$,H/@8$7$^$7$?(B      at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:62)      at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:57)      at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:73)      at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java:35)      at org.seasar.extension.jdbc.impl.BasicResultSetFactory.createResultSet(BasicResultSetFactory.java:36)      at org.seasar.dao.pager.PagerResultSetFactoryWrapper.createResultSet(PagerResultSetFactoryWrapper.java:63)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.createResultSet(BasicSelectHandler.java:173)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:162)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:135)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute (BasicSelectHandler.java:120)      at org.seasar.dao.impl.SelectDynamicCommand.execute(SelectDynamicCommand.java:55)      at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)      at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke (PagerS2DaoInterceptorWrapper.java:64)      at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43)      at org.seasar.framework.aop.interceptors.InterceptorChain.invoke(InterceptorChain.java :42)      at jp.co.hoge.dao.XXDao$$EnhancedByS2AOP$$c1758fd$$MethodInvocation$$findXX2.proceed()Ljava.lang.Object;(MethodInvocationClassGenerator.java:???)      at jp.co.hoge.dao.XXDao$$EnhancedByS2AOP$$c1758fd.findXX (Ljp.co.hoge.domain.XX;)Ljp.co.hoge.domain.XX;(XXDao$$EnhancedByS2AOP$$c1758fd.java:???)      at jp.co.hoge.service.XXServiceImpl.serchXX(XXServiceImpl.java:319)      at jp.co.hoge.service.XXServiceImpl$$EnhancedByS2AOP$$c1eb4c4.serchXX$$invokeSuperMethod$$ (Ljp.co.hoge.dto.XXDto;)Ljp.co.hoge.dto.XXDto;(XXServiceImpl$$EnhancedByS2AOP$$c1eb4c4.java:???)      at jp.co.hoge.service.XXServiceImpl$$EnhancedByS2AOP$$c1eb4c4$$MethodInvocation$$serchXX0.proceed()Ljava.lang.Object;( MethodInvocationClassGenerator.java:???)      at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:45)      at jp.co.hoge.aop.XXBeforeAdvice.invoke(XXBeforeAdvice.java:82)      at jp.co.hoge.aop.XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f.invoke$$invokeSuperMethod$$(Lorg.aopalliance.intercept.MethodInvocation;)Ljava.lang.Object;(XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f.java:???)      at jp.co.hoge.aop.XXBeforeAdvice$$EnhancedByS2AOP$$c13b81f$$MethodInvocation$$invoke0.proceed ()Ljava.lang.Object;(MethodInvocationClassGenerator.java:???)  Caused by: com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -228, SQLSTATE: 42620, SQLERRMC: SQL_CURSH200C1      at com.ibm.db2.jcc.b.sf.e(sf.java :1680)      at com.ibm.db2.jcc.b.sf.a(sf.java:1239)      at com.ibm.db2.jcc.c.jb.h(jb.java:139)      at com.ibm.db2.jcc.c.jb.a(jb.java:43)      at com.ibm.db2.jcc.c.w.a(w.java:30)      at com.ibm.db2.jcc.c.cc.g (cc.java:161)      at com.ibm.db2.jcc.b.sf.n(sf.java:1219)      at com.ibm.db2.jcc.b.tf.gb(tf.java:1818)      at com.ibm.db2.jcc.b.tf.d(tf.java:2294)      at com.ibm.db2.jcc.b.tf.X(tf.java:508)      at com.ibm.db2.jcc.b.tf.executeQuery (tf.java:491)      at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:71)      at org.seasar.framework.util.PreparedStatementUtil.executeQuery(PreparedStatementUtil.java :35)      at org.seasar.extension.jdbc.impl.BasicResultSetFactory.createResultSet(BasicResultSetFactory.java:36)      at org.seasar.dao.pager.PagerResultSetFactoryWrapper.createResultSet(PagerResultSetFactoryWrapper.java :63)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.createResultSet(BasicSelectHandler.java:173)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:162)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute (BasicSelectHandler.java:135)      at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:120)      at org.seasar.dao.impl.SelectDynamicCommand.execute(SelectDynamicCommand.java:55)      at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)      at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke(PagerS2DaoInterceptorWrapper.java:64)      at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed (NestedMethodInvocation.java:43)      at org.seasar.framework.aop.interceptors.InterceptorChain.invoke(InterceptorChain.java:42)      at jp.co.hoge.dao.XXDao$$EnhancedByS2AOP$$c1758fd$$MethodInvocation$$findXX2.proceed ()Ljava.lang.Object;(MethodInvocationClassGenerator.java:???)      at jp.co.hoge.dao.XXDao$$EnhancedByS2AOP$$c1758fd.findXX(Ljp.co.hoge.domain.XX;)Ljp.co.hoge.domain.XX;(XXDao$$EnhancedByS2AOP$$c1758fd.java:???) >PagerCondition$B$N%W%m%Q%F%#(Blimit$B$,(B-1$B$N>l9g$O(BPager$B$r;HMQ$7$J$$$h$&$K=$@5$7$?$$$H(B <div style="direction: ltr;">>$B;W$$$^$9!#(B(TYPE_SCROLL_INSENSITIVE$B$H(BCONCUR_READ_ONLY$B$r;HMQ$7$J$$$h$&$K$7$^$9!#(B)</div>$B$3$NBP1~$rF~$l$F$$$?$@$1$l$P(BS2Pager$B$H(BFOR UPDATE$B$NJ;MQ$,2DG=$H$J$k$H;W$$$^$9!#(B $B$h$m$7$/$*4j$$CW$7$^$9!#(B <div>06/12/26 $B$K(B Seto Azusa <<a href="mailto:azusa@fieldnotes.jp">azusa@fieldnotes.jp</a>> $B$5$s$O=q$-$^$7$?(B:<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> $B$;$H$"$:$5$G$9!#(B On Mon, 25 Dec 2006 19:59:29 +0900 Seto Azusa <<a href="mailto:azusa@fieldnotes.jp">azusa@fieldnotes.jp</a>> wrote: > S2Dao1.0.38$B0JA0$O!"(BS2Pager$B;HMQ;~$K(BFOR UPDATE$B$r4^$`(BSQL$BJ8$GNc30$,H/@8$9$kLdBj$,(B > $B$"$C$?$N$G$9$,!"(B 1.0.39$B$GBP1~$7$F$$$^$9!#(B[DAO-42] > # PagerCondition$B$N%W%m%Q%F%#(Blimit$B$r(B-1($B%G%U%)%k%H(B)$B$K$9$kI,MW$,$"$j$^$9!#(B $B$9$_$^$;$s!"Aa$H$A$j$7$F$^$7$?(Bm(__)m PagerCondition$B$N%W%m%Q%F%#(Blimit$B$,(B-1$B$N>l9g$O(BPager$B$r;HMQ$7$J$$$h$&$K=$@5$7$?$$$H(B $B;W$$$^$9!#(B(TYPE_SCROLL_INSENSITIVE$B$H(BCONCUR_READ_ONLY$B$r;HMQ$7$J$$$h$&$K$7$^$9!#(B) $B$D$$$F$O!"G'<1$K0c$$$,$J$$$+3NG'$7$?$$$N$G!"%9%?%C%/%H%l!<%9$@$1$G7k9=$G$9$N$G(B $BAw$C$F$/$@$5$i$J$$$G$7$g$&$+!)(B -- $B$;$H$"$:$5(B <a href="mailto:azusa@fieldnotes.jp">azusa@fieldnotes.jp</a> <a href="http://www.fieldnotes.jp/d/">http://www.fieldnotes.jp/d/ </a> _______________________________________________ Seasar-user mailing list <a href="mailto:Seasar-user@ml.seasar.org">Seasar-user@ml.seasar.org</a> <a href="https://ml.seasar.org/mailman/listinfo/seasar-user"> https://ml.seasar.org/mailman/listinfo/seasar-user</a> </blockquote></div>