title: How to Select a BLOB column from database using iBatis
body: <p>One of a table's column is of BLOB datatype (Oracle 10g). We have a simple select query executed via iBatis to select the BLOB column and display it using Struts2 &amp; JSP.  <BR> <BR></p>
  
  <p>The result tag in the iBatis xml file had the jdbctype as java.sql.Blob <br><br></p>
  
  <pre><code>&lt;result property="uploadContent" column="uploadcontent" jdbctype="Blob"/&gt;   
  </code></pre>
  
  <p>Should we be mentioning any typeHandler class for Blob column ? <strong>Currently we are getting an error stating column type mismatch.</strong></p>
  
  <p>Note: This column is selected and mapped into a java bean who has an attribute of type java.sql.Blob</p>