Error to retrieve data
<p><strong><em>My table:</em></strong></p>

<pre><code>CREATE TABLE [dbo].[R_ACADEMIE](
    [ID_ACADEMIE] [dbo].[IDENTIFIANT] NOT NULL,
    [LC_ACADEMIE_CODE] [dbo].[LIBELLE_COURT] NOT NULL,
    [LM_ACADEMIE_LIBELLE] [dbo].[LIBELLE_MOYEN] NOT NULL
) ON [PRIMARY]
</code></pre>

<p><strong><em>My result map:</em></strong></p>

<pre><code>&lt;resultMap class="business.bo.AcademieBO"
    id="AcademieBOResult"&gt;
    &lt;result column="ID_ACADEMIE" jdbcType="NUMERIC"
        property="idAcademie" /&gt;
    &lt;result column="LC_ACADEMIE_CODE" jdbcType="VARCHAR"
        property="lcAcademieCode" /&gt;
    &lt;result column="LM_ACADEMIE_LIBELLE" jdbcType="VARCHAR"
        property="lmAcademieLibelle" /&gt;
&lt;/resultMap&gt;
</code></pre>

<p><strong><em>AcademiBO.java:</em></strong></p>

<pre><code>import java.io.Serializable;
import java.math.BigDecimal;

public class AcademieBO implements Serializable{

    /**
     * 
     */
    private static final long serialVersionUID = 1L;

    /**
     * &lt;code&gt;idCivilite&lt;/code&gt; the idCivilite
     */
    private BigDecimal idAcademie;

    /**
     * &lt;code&gt;lcCivCode&lt;/code&gt; the lcCivCode
     */
    private String lcAcademieCode;

    /**
     * &lt;code&gt;lmCivLibelle&lt;/code&gt; the lmCivLibelle
     */
    private String lmAcademieLibelle;

    public BigDecimal getIdAcademie() {
        return idAcademie;
    }

    public void setIdAcademie(BigDecimal idAcademie) {
        this.idAcademie = idAcademie;
    }

    public String getLcAcademieCode() {
        return lcAcademieCode;
    }

    public void setLcAcademieCode(String lcAcademieCode) {
        this.lcAcademieCode = lcAcademieCode;
    }

    public String getLmAcademieLibelle() {
        return lmAcademieLibelle;
    }

    public void setLmAcademieLibelle(String lmAcademieLibelle) {
        this.lmAcademieLibelle = lmAcademieLibelle;
    }


}
</code></pre>

<p><strong><em>dbo_ACADEMIE_SqlMap.xml:</em></strong></p>

<pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
&lt;!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd"&gt;
&lt;sqlMap namespace="dbo_ACADEMIE"&gt;
    &lt;resultMap class="business.bo.AcademieBO"
        id="AcademieBOResult"&gt;
        &lt;result column="ID_ACADEMIE" jdbcType="NUMERIC" property="idAcademie" /&gt;
        &lt;result column="LC_ACADEMIE_CODE" jdbcType="VARCHAR" property="lcAcademieCode" /&gt;
        &lt;result column="LM_ACADEMIE_LIBELLE" jdbcType="VARCHAR"
            property="lmAcademieLibelle" /&gt;
    &lt;/resultMap&gt;

    &lt;select id="listAll" resultMap="AcademieBOResult"&gt;
        select * from dbo.R_ACADEMIE
        ORDER BY ID_ACADEMIE ASC
    &lt;/select&gt;

    &lt;select id="selectByIdCivilite" resultMap="AcademieBOResult"&gt;
        select * from dbo.R_ACADEMIE where ID_ACADEMIE = #idAcademie:INTEGER#
    &lt;/select&gt;
&lt;/sqlMap&gt;
</code></pre>

<p><strong><em>The error :</em></strong></p>

<blockquote>
  <p>SqlMapClient operation; uncategorized SQLException for SQL [];<br>
  SQL state [null];<br>
  error code [0];<br>
  The error occurred in<br>
  dao/maps/dbo_ACADEMIE_SqlMap.xml.<br>
  The error occurred while applying a result map.<br>
  Check the dbo_ACADEMIE.AcademieBOResult. 
  Check the result mapping for the 'idAcademie' property.<br>
  Cause: com.ibatis.sqlmap.client.SqlMapException: Error getting nested result
  map values for 'academie'.<br>
  Cause: java.sql.SQLException: Invalid column name ID_ACADEMIE.;<br>
  nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:<br>
  The error occurred in dao/maps/dbo_ACADEMIE_SqlMap.xml.<br>
  The error occurred while applying a result map.<br>
  Check the dbo_ACADEMIE.AcademieBOResult.<br>
  Check the result mapping for the 'idAcademie' property.<br>
  Cause: com.ibatis.sqlmap.client.SqlMapException: Error getting nested result  map values for 'academie'.<br>
  Cause: java.sql.SQLException: Invalid column name ID_ACADEMIE.  </p>
</blockquote>