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

Reply via email to