title: MyBatis invalid column type when using a parameter type int
body: <p>I'm getting the SQLException "Invalid Column Type" whenever I try to use a parameter in my query. The database field "assessment_id" is of type "NUMBER(15)" in oracle.  If I change #{value} to 1 then it works properly and returns my list of Concern objects.  However when I try using this parameter, I get the SQL Exception.  I'm still not sure what to put for the variable name in the XML, I tried using the same name as the variable I'm passing in.</p>
  
  <p>Here is my mapper config.</p>
  
  <pre><code>&lt;mapper namespace="ConcernMap"&gt;
  &lt;resultMap id="ConcernResult" type="com.xxx.name.model.Concern" &gt;
      &lt;result column="insCurrent" property="insCurrent"/&gt;
  &lt;/resultMap&gt;
  
  &lt;select id="fetchConcernsByWorkflowId" parameterType="int" resultMap="ConcernResult"&gt;
      SELECT 
      INSURANCE_CURRENT as insCurrent 
      from KOR_CONCERN where assessment_id = #{value}
  &lt;/select&gt;
  &lt;/mapper&gt;
  </code></pre>