$B$7$c$C$F$s$G$9!#(B $B$3$A$i$N4D6-$G4JC1$J%F%9%H$r9T$C$F$_$^$7$?!#(B 1.DBFluteConfig$B$rJQ99$;$::#$^$GDL$j$G$N8!:w$r<B9T!#(B 2.DBFluteConfig$B$N(BUTILDATE_AS_TIMESTAMP $B$r@_Dj$7$F$$$k2U=j$r%3%a%s%H%"%&%H$7$F8!:w$r<B9T!#(B 3.PreparedStatement$B$N(BsetDate$B$rL@<(E*$K8F$S=P$7$F8!:w$r<B9T!#(B 4.PreparedStatement$B$N(BsetTimestamp$B$rL@<(E*$K8F$S=P$7$F8!:w$r<B9T!#(B $B"(<B9T$7$?(BSQL$B$O!"F|IU9`L\$N(BFromTo$B$r>r7o$K$7$?%+%&%s%HJ8$G$9!#(B $B7k2L$O!"(B $B!!(B1 $B5Z$S(B 4 $B$O(B INDEX FAST FULL SCAN $B$H$J$j!"(B $B!!(B2 $B5Z$S(B 3 $B$O(B INDEX RANGE SCAN$B$H$J$j$^$7$?!#(B $B%G!<%?>e$NF|IU$K;~9o$^$G$r@_Dj$7!"8!:w>r7o$NF|IU$K$b8!:w7k2L$,0[$J$k$h$&$K;~9o$r;XDj$7$?(Bjava.util.Date$B$+$i(B java.sql.Date $B5Z$S(B java.sql.Timestamp $B$K$=$l$>$lJQ49$7$F>e5-(B3$B5Z$S(B4$B$G$N%F%9%H9T$$$^$7$?!#(B $B7k2L$O!"(B $B!!(BsetDate $B$r8F$S=P$7$?>l9g$O;~9o$O9MN8$5$l$:$KF|IU$N$_$G7k2L$,<hF@$G$-$k!#!J$3$N$H$-$O!"(BINDEX RANGE SCAN$B!K(B $B!!(BsetTimestamp $B$r8F$S=P$7$?>l9g$O;~9o$^$G9MN8$5$l$?8!:w7k2L$,JV5Q$5$l$k!#!J$?$@$7!"(BINDEX FAST FULL SCAN $B!K(B $B%$%s%G%C%/%9$OMxMQ$5$l$F$$$^$7$?$,!"MxMQ$N$5$lJ}$,0c$$$^$7$?!#(B $B$^$?!"(B 1 $B5Z$S(B 2 $B$G>r7o$rJQ$($:$K%+%&%s%HJ8$+$i0lMw<hF@$K$7$?>l9g!"(B 1 $B$O(BTABLE ACCESS FULL $B$G$N8!:w$H$J$j!"(B 2 $B$O(B INDEX RANGE SCAN $B$H$J$j$^$7$?!#(B kubo <dbflute@gmail.com>: > $B5WJ](B(jflute)$B$G$9!#(B > > > > $B$7$c$C$F$s$5$s!"(Bdbflute-oracle-example $B$K$F!"(B > > JDBC$BD>@\MxMQ$GF|IU<~$j$r8!>Z$9$k%F%9%H=q$-$^$7$?!#(B > > > > VendorPlainTest.java > > test_PreparedStatement_bindDate_timeHandling_Tx() > > > > $B"((BOracle10g XE $B$K$F!"(Bojdbc5.jar$B!"(Bojdbc6.jar$B$NN>J}$G%0%j!<%s(B > > > > Oracle$B$N(BDATE$B7?$KBP$7$F!"(BJDBC$B$K$*$$$F(B java.sql.Date $B$G(B > > $B<h$j07$&$H!"8!:w>r7o$bCM<hF@$b;~J,IC$,@Z$j<N$F$i$l$F(B > > $B$7$^$&$3$H$,>e5-$N%F%9%H$G$o$+$j$^$9!#(B > > $B$J$N$G!"(BDATE$B7?$KBP$7$F$O!"(Bjava.sql.Timestamp $B$G<h$j07$&(B > > $B$N$,4pK\$H9M$($i$l$^$9!#(B > > > > $B$?$@!"$7$c$C$F$s$5$s$N4D6-$G$N8=>]$,!"(B > > $B!V(Bjava.sql.Date $B$G@_Dj$9$k$H5U$K%$%s%G%C%/%9$,MxMQ$5$l$k!W(B > > $B$H$$$&$3$H$K$J$k$N$G$"$l$P!"$+$J$j$d$d$3$7$$LdBj$H$J$j$^$9!#(B > > > > $B>u673NG'$NA0$KO@M}$r@0M}$7$F$_$^$7$?$,!"(B > > $B>e5-$N$h$&$J$d$d$3$7$$LdBj$J$N$+!"$=$l$H$b$^$?JL$NMW0x$,$"$k$N$+!"(B > > $B3NG'$9$k$?$a$K0J2<$N%H%i%$$r$*4j$$$7$^$9!#(B > > > > DBFluteConfig$B$N=hM}$r$d$a$k$H%$%s%G%C%/%9$,MxMQ$5$l$k$+!)(B > > ValueType$B$O4JC1$KFH<+$N$b$N$K:9$7BX$($i$l$k$N$G!"(B > > JDBC $B$K(B setDate() $B$9$k$+!"(BsetTimestamp() $B$9$k$+$G!"(B > > $B%$%s%G%C%/%9$NMxMQM-L5$N0c$$$,H/@8$7$F$$$k$N$+$I$&$+$r(B > > $B3NG'$7$FD:$1$k$H9,$$$G$9!#(B > > > > $B"($=$b$=$b!"(BOracle11g $B$@$H>e5-$N%F%9%H7k2L$,0c$&$H$+(B > >  $B$@$H$5$i$K$d$d$3$7$/$J$j$^$9$,(B... > > _______________________________________________ > > Seasar-user mailing list > > Seasar-user@ml.seasar.org > > https://ml.seasar.org/mailman/listinfo/seasar-user >