A reminder for myself for the future (and any other people doing Java development): using the like operator in iBatis. The meta character escaping you need in your XML is column like '%'||#property#||'%', where property property is a bean property in your parameter class.
Also, if you’re doing everything in your where clause dynamically, I would recommend looking at dynamic and isNotNull tags.
-
Many thanks. U have solved one of my problem
1 comment
Comments feed for this article
Trackback link: http://solitude.vkps.co.uk/Archives/2006/11/19/iBatisAndLike/trackback/