$B5WJ]$5$s(B<div> </div><div>$BAaB.$N%3%a%s%H$"$j$,$H$&$4$6$$$^$7$?!#(B</div><div> </div><div>$B:G=i$OA0$N6uGr$O$J$5$=$&$K8+$($?$N$G!"99$K$?$7$F$7$^$$$^$7$?!#(B</div><div>$B:FEY6uGr$r:o$j$^$7$?$i!">e<j$/9T$-$^$7$?!#(B</div><div> </div><div>$B$*<j?t$r$*$+$1$7$^$7$?!#(B</div><div> </div><div>$B;VB<(B <div class="gmail_quote"> 2009/03/20 19:28 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>>: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">$B5WJ]$G$9!#(B $B;VB<$5$s!"$3$s$P$s$O(B <div class="im"> > user_role.loginname =  /*pmb.loginname*/    'mike' >    AND transaction_screen.screen =   /*pmb.screen*/     '/example/vdr' </div>$B%P%$%s%IJQ?t%3%a%s%H$H%F%9%HCM$N4V$K6uGr!V(B    $B!W$,(B $BF~$C$F$$$k$h$&$K8+$($^$9!#$3$A$i$N6uGr$r:o$C$F(B $B$b$&0lEY;n$7$FD:$1$J$$$G$7$g$&$+!)(B $B!V(B/*pmb.loginname*/    'mike'$B!W(B $B"-(B $B!V(B/*pmb.loginname*/'mike'$B!W(B $B!V(B*pmb.screen*/     '/example/vdr'$B!W(B $B"-(B $B!V(B*pmb.screen*/'/example/vdr'$B!W(B $B$A$J$_$K4pE@%F!<%V%k$N$H$"$k%+%i%`$N(B Max$BCM$r<hF@$9$k$N$G$"$l$P!"(B transactionScreenBhv.scalarSelect(new ScalarQuery<TransactionScreenCB>{    public void query(TransactionScreenCB cb) {        cb.specify().columnLevel();        cb.query()... // $B$=$NB>9J$j9~$_>r7o(B    } }); $B$G!"<B8=2DG=$G$9!#(B dbflute-basic-example$B$N(BBehaviorMiddleTest$B$N(B test_scalarSelect_max_Tx()$B$K(BExample$B<BAu$"$j$^$9!#(B 2009/3/20 Masanobu Shimura <<a href="mailto:mikeshimura@gmail.com">mikeshimura@gmail.com</a>>: <div><div></div><div class="h5">> $B5WJ]$5$s(B > $B$O$^$C$F$7$^$C$?$N$G!"65$($F2<$5$$!#(B > $B$J$*(B SQL$BJ8$r2<5-$K=$@5$9$l$PDL$j$^$9$N$G!"5^$$$G$O$$$^$;$s$,!#(B > $B$^$?(B /*IF$B!!$K$7$F$bF1MM$G!"JQ2=$"$j$^$;$s!#(B > dbflute runtime 0.9.3$B!"(BS2 2.4.33 $B$G!"(B dbflute-basic-example$B$O!"(BERROR$B$J$/DL$j$^$9!#(B > $B;VB<(B > > $BDL$k(B SQL$BJ8(B >    WHERE > user_role.loginname =  /*pmb.loginname*/ >    AND transaction_screen.screen =   /*pmb.screen*/ > > ERROR$B!!30$@$7!!(BSQL$BJ8(B > -- !SelectLevelPmb! > -- !!String loginname!! > -- !!String screen!! > SELECT >         MAX(LEVEL) >     FROM >         transaction_screen >             JOIN tran_role >                 ON transaction_screen.transaction = tran_role.transaction >             JOIN user_role >                 ON user_role.role = tran_role.role >     WHERE > user_role.loginname =  /*pmb.loginname*/    'mike' >    AND transaction_screen.screen =   /*pmb.screen*/     '/example/vdr' > $B<B9T(BLOG > DEBUG 2009-03-20 17:39:44,519 [main] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, > GlobalId=1237538384068/0, BranchId=] > DEBUG 2009-03-20 17:39:44,529 [main] > -- !SelectLevelPmb! > -- !!String loginname!! > -- !!String screen!! > SELECT >         MAX(LEVEL) >     FROM >         transaction_screen >             JOIN tran_role >                 ON transaction_screen.transaction = tran_role.transaction >             JOIN user_role >                 ON user_role.role = tran_role.role >     WHERE > user_role.loginname =  'mike'    'mike' >    AND transaction_screen.screen =   '/example/menu'     '/example/vdr' > DEBUG 2009-03-20 17:39:44,627 [main] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?!#(Btx=[FormatId=4360, > GlobalId=1237538384068/0, BranchId=] > DEBUG 2009-03-20 17:39:44,627 [main] END > org.seasar.ef.example.agile.logic.TransactionLogic#GetLevel(mike, > /example/menu) Throwable:org.seasar.dbflute.exception.SQLFailureException: > Look! Read the message below. > /* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > The SQL failed to execute! > [Advice] > Please confirm the SQLException message. > [SQLState] > 42601 > [ErrorCode] > 0 > [SQLException] > org.seasar.framework.exception.SSQLException > [ESSR0072]SQL$B$GNc30(B(SQL=[-- !SelectLevelPmb! > -- !!String loginname!! > -- !!String screen!! > SELECT >         MAX(LEVEL) >     FROM >         transaction_screen >             JOIN tran_role >                 ON transaction_screen.transaction = tran_role.transaction >             JOIN user_role >                 ON user_role.role = tran_role.role >     WHERE > user_role.loginname =  ?    'mike' >    AND transaction_screen.screen =   ?     '/example/vdr'], Message=[0], > ErrorCode=42601, SQLState={3})$B$,H/@8$7$^$7$?(B > [NextException] > org.postgresql.util.PSQLException > ERROR: syntax error at or near "'mike'" > [Behavior] > TranRoleBhv.outsideSql().selectList() > [OutsideSql] > org/seasar/ef/example/agile/dbflute/exbhv/TranRoleBhv_selectLevel.sql > [ParameterBean] > org.seasar.ef.example.agile.dbflute.exbhv.pmbean.SelectLevelPmb > {mike,/example/menu} > [Statement] > org.seasar.extension.jdbc.impl.PreparedStatementWrapper > [Display SQL] > -- !SelectLevelPmb! > -- !!String loginname!! > -- !!String screen!! > SELECT >         MAX(LEVEL) >     FROM >         transaction_screen >             JOIN tran_role >                 ON transaction_screen.transaction = tran_role.transaction >             JOIN user_role >                 ON user_role.role = tran_role.role >     WHERE > user_role.loginname =  'mike'    'mike' >    AND transaction_screen.screen =   '/example/menu'     '/example/vdr' > * * * * * * * * * */ > DEBUG 2009-03-20 17:39:44,640 [main] $B%H%i%s%6%/%7%g%s$r%m!<%k%P%C%/$7$^$7$?!#(Btx=[FormatId=4360, > GlobalId=1237538384068/0, BranchId=] </div></div>> _______________________________________________ > 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" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</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" target="_blank">https://ml.seasar.org/mailman/listinfo/seasar-user</a> </blockquote></div> </div>