hai, cb.query().setMemberName_<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">LikeSearch("s", new LikeSearchOption() {    @Override    public ExtensionOperand getExtensionOperand() {        return WayOfPostgreSQL.OperandOfLikeSearch.CASE_INSENSITIVE;    } }.likePrefix());</blockquote><div> <pre>import org.seasar.dbflute.dbway.ExtensionOperand;//Error there is no class in org.seasar.dbflute.dbway like ExtensionOperand </pre> </div> <div class="gmail_quote"> 2009/6/9 kubo <<a href="mailto:dbflute@gmail.com">dbflute@gmail.com</a>> <blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> 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; <div><div></div><div class="h5">    } } 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. >> > トマス >> > >> > >> > _______________________________________________ >> > 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>