umm... how dumb do you have to be to do something like that? uurmm... oh yeah... i did that too!
Brandon On 5/22/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > 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 <[EMAIL PROTECTED]> 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. > > > > > > >
