[Seasar-user:17665] Re: [dbflute-ignoreCase in conditionBean]使い方法

[kubo]

Hello,

Please confirm your SQL on console log.
Does the SQL use 'ilike'？
(where EMPLOYEE_CODE ilike 'emp%')

2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>:
> 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
> トマス
>
>
>
> 2009/6/9 thomas <[E-MAIL ADDRESS DELETED]>
>>
>> hai,
>>
>> Thanks for your helps!..
>>
>>
>>
>> On Tue, Jun 9, 2009 at 6:00 PM, kubo <[E-MAIL ADDRESS DELETED]> 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 <[E-MAIL ADDRESS DELETED]>:
>>> > 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 <[E-MAIL ADDRESS DELETED]>
>>> >>
>>> >> Hello,
>>> >>
>>> >> Please watch this test case:
>>> >> The method is 'test_likeSearch_caseInsensitive_Tx()'.
>>> >>
>>> >>
>>> >>
>>> >> https://www.seasar.org/svn/sandbox/dbflute/trunk/dbflute-postgresql-example/src/test/java/com/example/dbflute/postgresql/dbflute/various/VendorCheckTest.java
>>> >>
>>> >> 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 <[E-MAIL ADDRESS DELETED]>:
>>> >> > Hai,
>>> >> >
>>> >> > I am using PostgresQL 8.3
>>> >> >
>>> >> >
>>> >> >
>>> >> >
>>> >> > 2009/6/9 kubo <[E-MAIL ADDRESS DELETED]>
>>> >> >>
>>> >> >> 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 <[E-MAIL ADDRESS DELETED]>:
>>> >> >> > 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.
>>> >> >> > トマス
>>> >> >> >
>>> >> >> >
>>> >> >> > _______________________________________________
>>> >> >> > Seasar-user mailing list
>>> >> >> > [E-MAIL ADDRESS DELETED]
>>> >> >> > https://ml.seasar.org/mailman/listinfo/seasar-user
>>> >> >> >
>>> >> >> >
>>> >> >> _______________________________________________
>>> >> >> Seasar-user mailing list
>>> >> >> [E-MAIL ADDRESS DELETED]
>>> >> >> https://ml.seasar.org/mailman/listinfo/seasar-user
>>> >> >
>>> >> >
>>> >> > _______________________________________________
>>> >> > Seasar-user mailing list
>>> >> > [E-MAIL ADDRESS DELETED]
>>> >> > https://ml.seasar.org/mailman/listinfo/seasar-user
>>> >> >
>>> >> >
>>> >> _______________________________________________
>>> >> Seasar-user mailing list
>>> >> [E-MAIL ADDRESS DELETED]
>>> >> https://ml.seasar.org/mailman/listinfo/seasar-user
>>> >
>>> >
>>> > _______________________________________________
>>> > Seasar-user mailing list
>>> > [E-MAIL ADDRESS DELETED]
>>> > https://ml.seasar.org/mailman/listinfo/seasar-user
>>> >
>>> >
>>> _______________________________________________
>>> Seasar-user mailing list
>>> [E-MAIL ADDRESS DELETED]
>>> https://ml.seasar.org/mailman/listinfo/seasar-user
>>
>
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>
>