$B5WJ]$5$s(B<div><br></div><div>$B$O$^$C$F$7$^$C$?$N$G!"65$($F2<$5$$!#(B</div><div><br></div><div>$B$J$*(B SQL$BJ8$r2<5-$K=$@5$9$l$PDL$j$^$9$N$G!"5^$$$G$O$$$^$;$s$,!#(B</div><div><br></div><div>$B$^$?(B /*IF$B!!$K$7$F$bF1MM$G!"JQ2=$"$j$^$;$s!#(B</div><div><br></div><div>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</div>
<div><br></div><div>$B;VB<(B</div><div><br></div><div><br></div><div>$BDL$k(B SQL$BJ8(B</div><div><br></div><div><div> WHERE</div><div><span class="Apple-tab-span" style="white-space: pre; "> </span>user_role.loginname = /*pmb.loginname*/ </div>
<div> <span class="Apple-tab-span" style="white-space: pre; "> </span>AND transaction_screen.screen = /*pmb.screen*/</div></div><div><br></div><div><br></div><div>ERROR$B!!30$@$7!!(BSQL$BJ8(B</div><div><br></div><div><div>-- !SelectLevelPmb!</div>
<div>-- !!String loginname!!</div><div>-- !!String screen!!</div><div>SELECT</div><div> MAX(LEVEL)</div><div> FROM</div><div> transaction_screen</div><div> JOIN tran_role</div><div> ON transaction_screen.transaction = tran_role.transaction</div>
<div> JOIN user_role</div><div> ON user_role.role = tran_role.role</div><div> WHERE</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>user_role.loginname = /*pmb.loginname*/ 'mike'</div>
<div> <span class="Apple-tab-span" style="white-space:pre"> </span>AND transaction_screen.screen = /*pmb.screen*/ '/example/vdr'</div><div><br></div><div>$B<B9T(BLOG</div><div><br></div><div><div><div>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=]</div>
<div>DEBUG 2009-03-20 17:39:44,529 [main] </div><div>-- !SelectLevelPmb!</div><div>-- !!String loginname!!</div><div>-- !!String screen!!</div><div>SELECT</div><div> MAX(LEVEL)</div><div> FROM</div><div> transaction_screen</div>
<div> JOIN tran_role</div><div> ON transaction_screen.transaction = tran_role.transaction</div><div> JOIN user_role</div><div> ON user_role.role = tran_role.role</div><div>
WHERE</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>user_role.loginname = 'mike' 'mike'</div><div> <span class="Apple-tab-span" style="white-space:pre"> </span>AND transaction_screen.screen = '/example/menu' '/example/vdr'</div>
<div>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=]</div><div>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.</div>
<div>/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *</div><div>The SQL failed to execute!</div><div><br></div><div>[Advice]</div><div>Please confirm the SQLException message.</div><div><br></div><div>
[SQLState]</div><div>42601</div><div><br></div><div>[ErrorCode]</div><div>0</div><div><br></div><div>[SQLException]</div><div>org.seasar.framework.exception.SSQLException</div><div>[ESSR0072]SQL$B$GNc30(B(SQL=[-- !SelectLevelPmb!</div>
<div>-- !!String loginname!!</div><div>-- !!String screen!!</div><div>SELECT</div><div> MAX(LEVEL)</div><div> FROM</div><div> transaction_screen</div><div> JOIN tran_role</div><div> ON transaction_screen.transaction = tran_role.transaction</div>
<div> JOIN user_role</div><div> ON user_role.role = tran_role.role</div><div> WHERE</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>user_role.loginname = ? 'mike'</div>
<div> <span class="Apple-tab-span" style="white-space:pre"> </span>AND transaction_screen.screen = ? '/example/vdr'], Message=[0], ErrorCode=42601, SQLState={3})$B$,H/@8$7$^$7$?(B</div><div><br></div><div>[NextException]</div>
<div>org.postgresql.util.PSQLException</div><div>ERROR: syntax error at or near "'mike'"</div><div><br></div><div>[Behavior]</div><div>TranRoleBhv.outsideSql().selectList()</div><div><br></div><div>[OutsideSql]</div>
<div>org/seasar/ef/example/agile/dbflute/exbhv/TranRoleBhv_selectLevel.sql</div><div><br></div><div>[ParameterBean]</div><div>org.seasar.ef.example.agile.dbflute.exbhv.pmbean.SelectLevelPmb</div><div>{mike,/example/menu}</div>
<div><br></div><div>[Statement]</div><div>org.seasar.extension.jdbc.impl.PreparedStatementWrapper</div><div><br></div><div>[Display SQL]</div><div>-- !SelectLevelPmb!</div><div>-- !!String loginname!!</div><div>-- !!String screen!!</div>
<div>SELECT</div><div> MAX(LEVEL)</div><div> FROM</div><div> transaction_screen</div><div> JOIN tran_role</div><div> ON transaction_screen.transaction = tran_role.transaction</div>
<div> JOIN user_role</div><div> ON user_role.role = tran_role.role</div><div> WHERE</div><div><span class="Apple-tab-span" style="white-space:pre"> </span>user_role.loginname = 'mike' 'mike'</div>
<div> <span class="Apple-tab-span" style="white-space:pre"> </span>AND transaction_screen.screen = '/example/menu' '/example/vdr'</div><div>* * * * * * * * * */</div><div>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></div></div>