How to Select a BLOB column from database using iBatis

oracle mapping blob ibatis
yathirigan picture yathirigan · Aug 21, 2012 · Viewed 14.1k times · Source

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 & JSP.

The result tag in the iBatis xml file had the jdbctype as java.sql.Blob 

<result property="uploadContent" column="uploadcontent" jdbctype="Blob"/>

Should we be mentioning any typeHandler class for Blob column ? Currently we are getting an error stating column type mismatch.

Note: This column is selected and mapped into a java bean who has an attribute of type java.sql.Blob

Answer

AnBisw picture AnBisw · Aug 21, 2012

I think you cannot use native jdbctype for LOB types in Oracle with iBatis. The solution is to create custom typeHandler to handle LOB and then map it like -

<result property="aClassStringProperty" column="aClobColumn" typeHandler="com.path.to.my.ClobTypeHandler"/>

More information on typeHandlerCallback here.

Related questions

Mapping java.long to oracle.Number(14)

I have db column whose datatype is Number (15) and i have the corresponding field in java classes as long. The question is how would i map it using java.sql.Types. would Types.BIGINT work? Or shall i use something …

Read More
Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More