<div dir="ltr">$B@P0fMM(B<div><br></div><div>$B$*@$OC$K$J$C$F$*$j$^$9!#%(%k%F%C%/%9$N:4F#$G$9!#(B</div><div><br></div><div>$B;~4V$,$?$C$F$7$^$$62=L$G$9$,!"K\7o2r7h$7$?;]!"$4O"MmCW$7$^$9!#(B</div><div>3.2.5$B$GLdBj;v>]$,5/$-$J$$$3$H$r3NG'$$$?$7$^$7$?!#(B<br></div><div>$B0J2<$K3:Ev$7$F$$$?$H9M$($F$*$j$^$9!#(B</div><div><br></div><div>$B%j%j!<%9%N!<%H(B</div>
<div><div>---------------------------------------------------------------------------------------------------------------------</div><div>$B%*%s%a%b%j%/%(%j%-%c%C%7%e$rM-8z$K$7$?;~$N3HD%%/%(%j$N=hM}$K$*$1$k%a%b%j3d$jEv$F%m%8%C%/$r=$@5$7$^$7$?!#(B(Tatsuo Ishii)</div><div>$B%P%$%s%I%Q%i%a!<%?IU$-$N3HD%%/%(%j$G!"(B1024 $B%P%$%H0J>e$ND9$$%/%(%jJ8;zNs$,EO$5$l$?$H$-$K!"(B $B==J,$J%a%b%j3d$jEv$F$,$G$-$F$$$^$;$s$G$7$?!#(B</div>
<div>---------------------------------------------------------------------------------------------------------------------</div><div><br></div></div><div>$B$h$m$7$/$*4j$$$$$?$7$^$9!#(B</div><div class="gmail_extra"><br><div class="gmail_quote">
2013$BG/(B7$B7n(B26$BF|(B 13:31 $B:4F#?5(B <span dir="ltr"><<a href="mailto:s_sato@eltex.co.jp" target="_blank">s_sato@eltex.co.jp</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
$B@P0fMM(B<br>
<br>
$B$*@$OC$K$J$C$F$*$j$^$9!#%(%k%F%C%/%9$N:4F#$G$9!#(B<br>
<br>
$B$42sEz$"$j$,$H$&$4$6$$$^$9!#(B<br>
$B$^$:$O!"(Bpgpool-II3.2.5$B$G:F8=$7$J$$$+3NG'$5$;$FD:$-$^$9!#(B<br>
<br>
3.2.5$B$G$b:F8=$7$?>l9g$O!":F8=%W%m%0%i%`$r=`HwCW$7$^$9$N$G!"(B<br>
$B$=$N:]$O$h$m$7$/$*4j$$$$$?$7$^$9!#(B<br>
<br>
2013$BG/(B7$B7n(B9$BF|(B 15:10 Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>>:<br>
<div class=""><div class="h5">> $B@P0f$H?=$7$^$9!#(B<br>
><br>
> pgpool-II3.2.4$B$G$N4{CN$N%/%(%j%-%c%C%7%e<~$j$N>c32$H$7$F$O!"0J2<$,$"$j$^$9!#(B<br>
><br>
> <a href="http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=a6d91284223576d82f9eef689493c883d1efcc69" target="_blank">http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=a6d91284223576d82f9eef689493c883d1efcc69</a><br>
><br>
> $B$3$l$K3:Ev$7$F$$>l9g$K$O!"EvJ}$G:F8=$G$-$k4D6-(B($B:F8=%W%m%0%i%`$J$I(B)$B$J$I(B<br>
> $B$r$4Ds6!D:$1$l$PD4::2DG=$H;W$$$^$9!#(B<br>
> --<br>
> Tatsuo Ishii<br>
> SRA OSS, Inc. Japan<br>
> English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
> Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
><br>
>> $B$*@$OC$K$J$C$F$*$j$^$9!#%(%k%F%C%/%9$N:4F#$H?=$7$^$9!#(B<br>
>><br>
>> $BA02s!"Ld$$9g$o$;$5$;$FD:$-$^$7$?!V(B[pgpool-general-jp: 1169] $B%/%(%j%-%c%C%7%e$NIT@5!W$N7QB3$7$?Ej9F$K$J$j$^$9!#(B<br>
>><br>
>> PostgreSQL 9.2.4 $B$H(Bpgpool-II 3.2.4 $B$N4D6-$GF0:n8!>Z9T$C$F$$$^$9$,!"(B<br>
>> $BF1$8(BSELECT$B$G>o$KF1$87k2L$,JV$k$O$:$N$b$N$,!"(BSELECT$B$9$kETEY!"(BSELECT$B7k2L$,0c$C$F$7$^$&!"$H$$$&>I>u$,H/@8$7$^$9!#(B<br>
>> $B%*%s%a%b%j%/%(%j%-%c%C%7%e5!G=$rM-8z$K$7$?>l9g$N$_!"H/@8$7$^$9!#(B<br>
>> SELECT$B7k2L$,0c$C$F$7$^$&>l9g!"%-%c%C%7%e$+$i(BSELECT$B7k2L$rJV$7$F$$$k$H$$$&(Bpgpool$B$N%m%0$,=P$F$*$j$^$9!#(B<br>
>><br>
>> DB$B$O(B HS/SR$B%/%i%9%?$G!"(Bpgpool$B$O(Bmaster-slave$B%b!<%I$K$J$j$^$9!#(B<br>
>><br>
>> [$B3F<o4D6-(B]<br>
>> Apache Tomcat Version 7.0.29<br>
>> $B%3%M%/%7%g%s%W!<%j%s%0(B tomcat-dbcp.jar(Apache Tomcat $BIUB0(B)<br>
>> JDBC$B%I%i%$%P!<(B postgresql-9.1-902.jdbc4.jar<br>
>> PostgreSQL (9.2.4)<br>
>> pgpool-II (3.2.4)<br>
>> Java 1.7.0_05-b06<br>
>> Web$B%5!<%P!<(B Apache 2.2.23<br>
>><br>
>> [SQL$B$N@8@.J}K!(B]<br>
>> SQL$B$O(B PreparedStatement $B$r;H$C$F<B9T$7$F$$$^$9$,!"(BLIMIT$B6g$H(BOFFSET$B6g$O(B<br>
>><br>
>> StringBuilder sb = new StringBuilder();<br>
>> sb.append(original);<br>
>> sb.append(apendOrderby(criteria));<br>
>> sb.append(" LIMIT ");<br>
>> sb.append(criteria.getCriteriaResult().getLimit());<br>
>> sb.append(" OFFSET ");<br>
>> sb.append(criteria.getCriteriaResult().getStart() - 1);<br>
>><br>
>> $B$N$h$&$K!"(BSQL$BCf$KD>@\Kd$a9~$s$G$$$^$9!#(B<br>
>><br>
>> $B8DJL$N8!:w>r7o$K$O%W%l!<%9%[%k%@!<$r;HMQ$7$F$$$^$9$N$G!"(B<br>
>> $BH/9T$5$l$k(BSQL$B$N%$%a!<%8$H$7$F$O(B<br>
>><br>
>> SELECT<br>
>> employee_id<br>
>> ,first_name<br>
>> ,last_name<br>
>> ,email<br>
>> ,phone_numeric<br>
>> ,hire_date<br>
>> ,job_id<br>
>> ,salary<br>
>> ,commission_pct<br>
>> ,manager_id<br>
>> ,department_id<br>
>> FROM<br>
>> employee<br>
>> WHERE<br>
>> department_id = ?<br>
>> ORDER BY<br>
>> employee_id limit 10 offset 10;<br>
>><br>
>> $B$N$h$&$K$J$j$^$9!#<B:]$N(BSQL$B$O$b$C$HD9$$$G$9!#(B<br>
>><br>
>> $B%3%M%/%7%g%s$O(BTomcat$B$N%3%M%/%7%g%s%W!<%j%s%0$r;HMQ$7$F$$$F!"(B<br>
>> JNDI$B$G%k%C%/%"%C%W$7$F<hF@$7$F$$$^$9!#(B<br>
>><br>
>> $B>e5-$N(BSELECT$B$r(Bpsql$B$GC10l$N(BSQL$B$H$7$F!"H/9T$7$?>l9g$O!"LdBj;v>]$OH/@8$7$^$;$s$,!"%"%W%j%1!<%7%g%s$+$i<B9T$9$k$H;v>]H/@8$7$^$9!#(B<br>
>> $B%*%s%a%b%j%/%(%j%-%c%C%7%e5!G=$rM-8z$K$7$?>l9g$N$_:F8=$7!"%*%s%a%b%j%/%(%j%-%c%C%7%e5!G=$rL58z$K$9$k$HLdBj;v>]$O:F8=$;$:$K!"2~A1$7$^$9!#(B<br>
>><br>
>> $B%*%s%a%b%j%/%(%j%-%c%C%7%e5!G=$O6&M-%a%b%j!<$r;HMQ$7$F$$$^$9!#(B<br>
>> pgpool$B$N%*%s%a%b%j%/%(%j%-%c%C%7%e5!G=$N@_Dj$H$7$F$O!"0J2<$N$H$*$j$G$9!#(B<br>
>> memory_cache_enabled = on<br>
>> memqcache_method = 'shmem'<br>
>> memqcache_memcached_host = 'localhost'<br>
>> memqcache_memcached_port = 11211<br>
>> memqcache_total_size = 67108864<br>
>> memqcache_max_num_cache = 1000000<br>
>> memqcache_expire = 0<br>
>> memqcache_auto_cache_invalidation = on<br>
>> memqcache_maxcache = 409600<br>
>><br>
>> $B!V(BSHOW pool_cache$B!W%3%^%s%I$+$i%-%c%C%7%e%9%H%l!<%8$N%(%s%H%j$,0lGU$G$J$$$3$H$O3NG':Q$_$G$9!#(B<br>
>><br>
>> $B<ALd;v9`(B<br>
>> -------------------------------------------------------------------------------------------------------------------------------<br>
>> 1. $B%^%K%e%"%k$r8+$k$H0J2<5-=R$,$4$6$$$^$9$,!"%*%s%a%b%j%/%(%j%-%c%C%7%e5!G=$G$O(BSQL$B$ND9$5$K@)8B$,$"$j$^$9$G$7$g$&$+!#(B<br>
>><br>
>> $B!V%*%s%a%b%j%/%(%j%-%c%C%7%e$O!"Ld$$9g$o$;$N(BSELECT$BJ8(B($B3HD%Ld$$9g$o$;$N>l9g$O99$K%P%$%s%I%Q%i%a!<%?(B)$B$H(B<br>
>>$B!!(B $B8!:w7k2L$r%Z%"$G5-O?$7!"(B2$B2sL\0J9_$KF1$8(BSELECT$BJ8$,H/9T$5$l$?>l9g$K!"%-%c%C%7%e$+$i7k2L$rJV$7$^$9!#!W(B<br>
>><br>
>> 2. $BH/9T$9$k(BSQL$B$O>e5-$N(BSQL$B$N$h$&$J%$%a!<%8$G$9$,!":G8e$N(Boffset$BCM$@$1$,(B0$B!"(B10$B!"(B20$B$H$$$&$h$&$KJQ2=$7$^$9!#(B<br>
>>$B!!(B SQL$B$,D9$9$.$F!"2a5n$K%-%c%C%7%e$7$?;w$?(BSQL$B$HF10l$H$_$J$5$l$F!"%-%c%C%7%e$+$i7k2L$rJV$7$F$$$k$H$$$&$3$H$O$"$j$^$;$s$G$7$g$&$+!)(B<br>
>><br>
>> 3. $B860x$rFCDj$9$k$?$a$K!"3NG'$9$Y$-9`L\$,$"$j$^$7$?$i!"65$($FD:$1$J$$$G$7$g$&$+!)(B<br>
>><br>
>> ------------------------------------------------------------------------------------------------------------------------------<br>
>><br>
>> $B$42sEz$O0lIt$G$b$h$/!"2?$+%R%s%H$K$J$k$b$N$G$b9=$$$^$;$s$N$G!"$h$m$7$/$*4j$$$$$?$7$^$9!#(B<br>
>><br>
>> --<br>
>> ―――――――――――――――――――――――――<br>
>> $B:4F#!!?5(B<br>
>> $B3t<02q<R%(%k%F%C%/%9(B<br>
>> $B%7%9%F%`%^%M!<%8%a%s%H%5!<%S%9It(B<br>
>> $B")(B240-0005$B!!2#IM;TJ]EZ%vC+6h?@8MD.(B134<br>
>> $B2#IM%S%8%M%9%Q!<%/!!%$!<%9%H%?%o!<(B14$B3,(B<br>
>> $BEEOC!'(B045-332-7865$B!!(BFax$B!'(B045-332-6644<br>
>> URL $B!'(B<a href="http://www.eltex.co.jp/" target="_blank">http://www.eltex.co.jp/</a><br>
>> facebook$B!'(B<a href="http://www.facebook.com/ELTEXinc" target="_blank">http://www.facebook.com/ELTEXinc</a><br>
>> ――――――――――――――――――(c)ELTEX, Inc.<br>
>> _______________________________________________<br>
>> pgpool-general-jp mailing list<br>
>> <a href="mailto:pgpool-general-jp@sraoss.jp">pgpool-general-jp@sraoss.jp</a><br>
>> <a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp" target="_blank">http://www.sraoss.jp/mailman/listinfo/pgpool-general-jp</a><br>
<br>
<br>
<br>
--<br>
―――――――――――――――――――――――――<br>
$B:4F#!!?5(B<br>
$B3t<02q<R%(%k%F%C%/%9(B<br>
$B%7%9%F%`%^%M!<%8%a%s%H%5!<%S%9It(B<br>
$B")(B240-0005$B!!2#IM;TJ]EZ%vC+6h?@8MD.(B134<br>
$B2#IM%S%8%M%9%Q!<%/!!%$!<%9%H%?%o!<(B14$B3,(B<br>
$BEEOC!'(B045-332-7865$B!!(BFax$B!'(B045-332-6644<br>
URL $B!'(B<a href="http://www.eltex.co.jp/" target="_blank">http://www.eltex.co.jp/</a><br>
facebook$B!'(B<a href="http://www.facebook.com/ELTEXinc" target="_blank">http://www.facebook.com/ELTEXinc</a><br>
――――――――――――――――――(c)ELTEX, Inc.<br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div>―――――――――――――――――――――――――</div><div>$B:4F#!!?5(B</div><div>$B3t<02q<R%(%k%F%C%/%9(B</div><div>$B%7%9%F%`%^%M!<%8%a%s%H%5!<%S%9It(B</div><div>$B")(B240-0005$B!!2#IM;TJ]EZ%vC+6h?@8MD.(B134</div><div>$B2#IM%S%8%M%9%Q!<%/!!%$!<%9%H%?%o!<(B14$B3,(B</div>
<div>$BEEOC!'(B045-332-7865$B!!(BFax$B!'(B045-332-6644</div><div>URL $B!'(B<a href="http://www.eltex.co.jp/" target="_blank">http://www.eltex.co.jp/</a></div><div>facebook$B!'(B<a href="http://www.facebook.com/ELTEXinc" target="_blank">http://www.facebook.com/ELTEXinc</a></div>
<div>――――――――――――――――――(c)ELTEX, Inc.</div>
</div></div>