Quick primer on iBatis SQL Map

Owned by Vaishnavi Sridhar (Unlicensed)

This section is not to be considered as the source of truth for all features supported by iBatis. Instead this covers a few basics that apply to modeling queries in iBatis.


All SQL maps are created with following XML structure -

  • sqlMap – This is the root element
  • resultMap – This is optional. This is used to define how the various columns need to be mapped into the target result object.
  • select / insert / update / delete – This is the actual query type that needs to be executed
  • parameterMap – This is optional. This is used to define how the various parameters need to be mapped.
  • sql – This is a reusable SQL fragment that can be included into a DML


Let us look at each of the elements.