Java Mailing List Archive

Home » user-java.ibatis »

Select Query 'LIKE' Issue

suman gona


Replies: Find Java Web Hosting

Author LoginPost Reply

Hello ,

I am using Ibatis 2.3.Issue Persist as Below mentioned.

Query in Respective Configuration XML As:

<select id="getSerialNumber" resultClass="java.lang.String">
 select ifnull(max(account_number),0) from account_details where
account_number like '$pattern$%'

TRIED PATTERS : $pattern$% , %$pattern$%
So Here SQL always retuning Non Zero Value.If suppose In DB '99970' such
data exist ,where i am trying to search for '99980' then also i am getting
Non Zero Values.Ideally in this case DB Should return zero according to

If any one of you understand the scenario please notify me any thing wrong
in this.

Thanks in Advance,
Sent from the iBATIS - User - Java mailing list archive at

To unsubscribe, e-mail: user-java-unsubscribe@(protected)
For additional commands, e-mail: user-java-help@(protected)

©2008 - Jax Systems, LLC, U.S.A.