<html>
<head>
<style>
P
{
margin:0px;
padding:0px
}
body
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body>koichi$B$G$9!#(B<BR>
<BR>
$B$*@$OC$K$J$C$F$*$j$^$9!#(B<BR>
<BR>
S2-2.4.16 <BR>
S2Dao-1.0.45(S2Pager)<BR>
Oracle10g<BR>
<BR>
$B>e5-$N4D6-$GAaB.(BPagerResultSetFactoryRownumWrapper$B$r;HMQ$5$;$F$b$i$C$F$$$k$N$G$9$,(B<BR>
SQLException$B$,H/@8$7$F$7$^$$$^$9!#(B<BR>
<BR>
$B<BAu$H$7$F$O(B<BR>
PagerCondition$B$r(Bimplements$B$7$F$$$k8!:w>r7o%/%i%9$KDI2C$G%W%m%Q%F%#$r;}$?$;$?>e(B<BR>
Dao$B$N(Bselect$B%a%=%C%I$K0z?t$GEO$7$F$$$^$9!#(B<BR>
<BR>
$B!!(B@SqlFile<BR>
$B!!(B@Arguments("condition")<BR>
$B!!(Bpublic List<CompanyBean> selectByPagerCondition(CompanyPagerCondition condition);<BR>
<BR>
$B$3$l$G(B PagerCondition$B$N>r7o$N$_M-8z$N>l9g$OLdBj$J$$$N$G$9$,!"(B<BR>
condition$B$KDj5A$7$F$$$k!"Nc$($P4k6HL>$J$I$N>r7o$bM-8z$K$J$k$H(B<BR>
$B%+%&%s%H$r<h$k(BSQL$B<B9T$N;~E@$G(BSQLException: IN$B$^$?$O(BOUT$B%Q%i%a!<%?$,$"$j$^$;$s(B $B$,H/@8$7$^$9!#(B<BR>
<BR>
<BR>
$B%G%P%C%0$7$F$_$^$9$H(B<BR>
org.seasar.dao.pager.AbstractPagerResultSetFactory#getCount(PreparedStatement ps, String baseSQL)$B$N(B<BR>
L183$B!!(BpsCount = ps.getConnection().prepareStatement(countSQL);<BR>
$B$K$F!"(Bps$B$K$O%Q%i%a!<%?>pJs$,$"$k$N$G$9$,!"(B<BR>
psCount$BFb$K%Q%i%a!<%?$,4^$^$l$F$$$J$$!)$h$&$G$7$?!#(B<BR>
PreparedStatement$B$NFbMF$K$/$o$7$/$J$$$N$G$h$/$o$+$i$J$$$N$G$9$,(B<BR>
$B>e5-$N5-=R$G%Q%i%a!<%?>pJs$,%3%T!<$5$l$k$N$G$7$g$&$+(B<BR>
baseSQL$B$NJ}$O!"(BSqlLog#getRawSql() $B$NL$2C9)$N(BSQL$B$,EO$C$F$/$k$H$$$&$3$H$J$N$G(B<BR>
$B$?$V$s(BpsCount$BFb$K%Q%i%a!<%?>pJs$,F~$C$F$$$J$$$N$,860x$@$m$&$H;W$C$F$$$k$N$G$9$,!&!&!&(B<BR>
<BR>
$B$40U8+$r$*J9$+$;2<$5$$!#(B<BR>
$B$h$m$7$/$*4j$$$7$^$9!#(B<BR>
<BR><br /><hr />$B%@%&%s%m!<%IL5NA!*%^%$%/%m%=%U%H$N:G?7%V%i%&%6(BMSN$BHG$r:#$9$0BN83(B <a href='http://clk.atdmt.com/GBL/go/msnjpqjl0040000003gbl/direct/01/' target='_new'>http://promotion.msn.co.jp/ie7/</a></body>
</html>