ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrea Selva <selva.an...@gmail.com>
Subject Re: special characters in xml
Date Tue, 11 May 2010 10:15:23 GMT
Hi,
in this case i would try to use  the xml substitution for the % character,
so becomes "like '&#37;<value> &#37;'"
I hope this could help
 Andrea

On Mon, May 10, 2010 at 8:26 PM, Juan Chung <jiayanchung@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, masonkante@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-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

Mime
View raw message