November 19, 2006 | Category:

iBatis And Like

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.