ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Blob
Date Mon, 23 May 2005 03:17:21 GMT
One almost unrelated thing on this (that I have screwed up before) is
that you may want to leave out the blob unless you really, really need
it. :-)

Imagine 10-20 users in a web app loading up these lists...and all of
those blobs getting suffed into memory. ;-)

Larry


On 5/22/05, Lieven De Keyzer <lieven_dekeyzer@hotmail.com> wrote:
> I want to retrieve the values from a table where 1 column is of type Blob.
> My Bean to store these values has a field of type java.sql.Blob and the
> appropriate getters and setters.
> 
> My resultmap looks like this:
> 
> <sqlMap namespace="Bookmark">
> 
>   <typeAlias alias="bookmark" type="com.vub.bookmarked.domain.Bookmark"/>
> 
>   <resultMap id="bookmarkResult" class="bookmark">
>     <result property="bookmarkId" column="bookmark_id"/>
>     <result property="folderId" column="folder_id"/>
>     <result property="url" column="url"/>
>     <result property="bookmarkname" column="bookmarkname"/>
>     <result property="cache" column="cache"/>
>   </resultMap>
> 
> When my webapplication actually needs this data, I get following exception:
> 
> 
> Cause: com.ibatis.dao.client.DaoException: Failed to queryForList - id
> [getBookmarkListByParentId], parameterObject [71]. Cause:
> com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred
> in com/vub/bookmarked/persistence/sqlmapdao/sql/Bookmark.xml. --- The error
> occurred while applying a result map. --- Check the Bookmark.bookmarkResult.
> --- Check the result mapping for the 'cache' property. --- Cause:
> com.ibatis.sqlmap.client.SqlMapException: No type handler could be found to
> map the property 'cache' to the column 'cache'. One or both of the types, or
> the combination of types is not supported.
> 
> 
> Isn't type Blob supported in iBatis? I have the latest version.
> 
> 
>

Mime
View raw message