Hai, After changing the version of my dbflute-runtime i got ilike in SQL log. Thanks for your kind replys.... Regards, $B%H%^%9(B <div class="gmail_quote">On Wed, Jun 10, 2009 at 5:47 PM, kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello, Thanks you for watching your log. The problem is that the code doesn't use 'ilike'. Now I don't know why the code doesn't... (Because the example works well) There are several things I want to confirm... 1. Does this code throw the exception? <div class="im"> empCB.query().setEmployeecode_LikeSearch("emp", new LikeSearchOption() {    @Override    public ExtensionOperand getExtensionOperand() { </div>        throw new IllegalStateException();        //return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;    } }.likePrefix()); *I want to confirm that the method is called by DBFlute Framework. 2. Is dbflute-runtime-0.9.5.jar valid on your Runtime Environment   (Did you remove an old jar file 'dbflute-runtime-0.9.4.1.jar' from Runtime Environment?) For example:  {o}  WEB-INF/lib    |-dbflute-runtime-0.9.5.jar    |-other...jar  {x}  WEB-INF/lib    |-dbflute-runtime-0.9.4.1.jar    |-dbflute-runtime-0.9.5.jar    |-other...jar 2009/6/10 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: <div><div></div><div class="h5">> Hai, > > it uses like in SQL not ilike. > > >  EmployeemasterBhv.selectPage():paging() > DEBUG 2009-06-10 17:03:23,437 > [http-8080-1] > ======================================/ > DEBUG 2009-06-10 17:03:23,437 [http-8080-1] > EmployeemasterListPage.prerender():154 --> EmployeemasterBhv.selectPage() > --> ... > DEBUG 2009-06-10 17:03:23,437 [http-8080-1] > $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?!#(Btx=[FormatId=4360, GlobalId=1244620931796/5, BranchId=] > DEBUG 2009-06-10 17:03:23,437 [http-8080-1] > select dflocal.deleteflg as c1, dflocal.costrank as c2, dflocal.address1 as > c3, dflocal.address2 as c4, dflocal.postalcode as c5, dflocal.lastupdated as > c6, dflocal.employeecode as c7, dflocal.employeenamekanji as c8, > dflocal.employeenamekana as c9, dflocal.employeefirstname as c10, > dflocal.employeelastname as c11, dflocal.dob as c12, dflocal.age as c13, > dflocal.joiningdate as c14, dflocal.designation as c15, dflocal.joblevel as > c16, dflocal.yearofexperience as c17, dflocal.housephoneno as c18, > dflocal.mobilephoneno as c19, dflocal.email as c20, dflocal.terminationdate > as c21, dflocal.registerdate as c22 >   from employeemaster dflocal >  where dflocal.employeecode like 'emp%' escape '|' >  offset 0 limit 10 > > > Regards, > $B%H%^%9(B > > > On Tue, Jun 9, 2009 at 8:03 PM, kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> wrote: >> >> Hello, >> >> Please confirm your SQL on console log. >> Does the SQL use 'ilike'$B!)(B >> (where EMPLOYEE_CODE ilike 'emp%') >> >> 2009/6/9 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: >> > hai, >> > >> > I upgraded my dbflute to 0.9.5. >> > >> > EmployeemasterCB empCB = employeemasterBhv.newMyConditionBean(); >> >         empCB.query().setEmployeecode_LikeSearch("emp", new >> > LikeSearchOption() { >> >             @Override >> >             public ExtensionOperand getExtensionOperand() { >> >                 return >> > WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE; >> >             } >> >         }.likePrefix()); >> > >> > if i give "emp" as search condition it retrieves only The values starts >> > with >> > emp. >> > >> > InMy table i have the values >> > >> > emp22 >> > EMP22 >> > emp20 >> > EMP20 >> > ......... >> > ......... >> > .......... >> > >> > The above coding retrieves only emp22 and emp20 >> > I want to retrieve EMP22 and EMP20 also. >> > >> > >> > Thanks >> > $B%H%^%9(B >> > >> > >> > >> > 2009/6/9 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>> >> >> >> >> hai, >> >> >> >> Thanks for your helps!.. >> >> >> >> >> >> >> >> On Tue, Jun 9, 2009 at 6:00 PM, kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> wrote: >> >>> >> >>> Hello, >> >>> >> >>> Sorry! I mistook your DBFlute version. >> >>> The method and class are supported since 0.9.5. >> >>> So please upgrade DBFlute to 0.9.5 if possible. >> >>> >> >>> 2009/6/9 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: >> >>> > hai, >> >>> > >> >>> > cb.query().setMemberName_ >> >>> >> >> >>> >> LikeSearch("s", new LikeSearchOption() { >> >>> >>    @Override >> >>> >>    public ExtensionOperand getExtensionOperand() { >> >>> >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE; >> >>> >>    } >> >>> >> }.likePrefix()); >> >>> > >> >>> > import org.seasar.dbflute.dbway.ExtensionOperand;//Error >> >>> > >> >>> > there is no class in org.seasar.dbflute.dbway like ExtensionOperand >> >>> > >> >>> > >> >>> > >> >>> > 2009/6/9 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> >> >>> >> >> >>> >> Hello, >> >>> >> >> >>> >> Please watch this test case: >> >>> >> The method is 'test_likeSearch_caseInsensitive_Tx()'. >> >>> >> >> >>> >> >> >>> >> >> >>> >> >> >>> >> <a href="https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/various/VendorCheckTest.java" target="_blank">https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/various/VendorCheckTest.java</a> >> >>> >> >> >>> >> cb.query().setMemberName_LikeSearch("s", new LikeSearchOption() { >> >>> >>    @Override >> >>> >>    public ExtensionOperand getExtensionOperand() { >> >>> >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE; >> >>> >>    } >> >>> >> }.likePrefix()); >> >>> >> >> >>> >> This code uses 'ilike' in the SQL. >> >>> >> (But this way is only available at PostgreSQL) >> >>> >> >> >>> >> If you have many many points that must be without case sensitive, >> >>> >> you should create CaseInsensitiveLikeSearchOption as your original >> >>> >> class. >> >>> >> Like this: >> >>> >> >> >>> >> public class CaseInsensitiveLikeSearchOption extends >> >>> >> LikeSearchOption >> >>> >> { >> >>> >>    @Override >> >>> >>    public ExtensionOperand getExtensionOperand() { >> >>> >>        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE; >> >>> >>    } >> >>> >> } >> >>> >> >> >>> >> 2009/6/9 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: >> >>> >> > Hai, >> >>> >> > >> >>> >> > I am using PostgresQL 8.3 >> >>> >> > >> >>> >> > >> >>> >> > >> >>> >> > >> >>> >> > 2009/6/9 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> >> >>> >> >> >> >>> >> >> Hello, this is jflute. >> >>> >> >> >> >>> >> >> For starters, there is one thing I want to confirm. >> >>> >> >> What kind of database do you use? >> >>> >> >> Oracle? MySQL? PostgreSQL? ... >> >>> >> >> >> >>> >> >> 2009/6/9 thomas <<a href="mailto:jp.mcy.10@gmail.com">jp.mcy.10@gmail.com</a>>: >> >>> >> >> > Hai, >> >>> >> >> > >> >>> >> >> > I want to retrieve data without case sensitive using condition >> >>> >> >> > Bean. >> >>> >> >> > >> >>> >> >> > dbflute version 0.9.4.1 >> >>> >> >> > >> >>> >> >> > empCB.query().setEmployeecode_LikeSearch(empcodes,new >> >>> >> >> > LikeSearchOption()); >> >>> >> >> > >> >>> >> >> > How to change this code to get case sensitive result? >> >>> >> >> > >> >>> >> >> > Please give steps to achieve this... >> >>> >> >> > >> >>> >> >> > Thanks in advance. >> >>> >> >> > $B%H%^%9(B >> >>> >> >> > >> >>> >> >> > >> >>> >> >> > _______________________________________________ >> >>> >> >> > 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> >> >>> >> > >> >>> >> > >> >>> >> > _______________________________________________ >> >>> >> > 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> >> >>> > >> >>> > >> >>> > _______________________________________________ >> >>> > 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> >> >> >> > >> > >> > _______________________________________________ >> > 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> > > > _______________________________________________ > 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> </div></div></blockquote></div>