Hi,
in this case i would try to use the xml substitution for the % character,
so becomes "like '%<value> %'"
I hope this could help
Andrea
On Mon, May 10, 2010 at 8:26 PM, Juan Chung <jiayanch...@gmail.com> wrote:
> when you prepare the parameters before calling ibatis, you could change the
> parameter value like this:
> value = "%" + value + "%";
> So just let Java does this job.
>
>
> good luck;
>
> Juan
>
>
> On 05/10/2010 07:27 PM, masonka...@libero.it wrote:
>
>> Hi,
>>
>> I'm using ibatis 3.0 and I need help using special character in xml
>> mapping
>> files.
>> Thanks to ibatis I switch between mysql server and Apache derby Embedded
>> database easily but i need to write a like condition in a way compatible
>> with
>> both db.
>>
>> What I want to get is "like '%<value>%'", but in xml this create some
>> problem
>> (% is special character, I try with cddata but doesn't work).
>> At first I solve in mysql using concat function concat('%',<value>,'%').
>> This doesn't work with apache derby, because it doesn't support this kind
>> of
>> function.
>> Somebody can help me to write this expression in a way that work with both
>> databases.
>>
>> Thanks.
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
>> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
> For additional commands, e-mail: user-java-h...@ibatis.apache.org
>
>
