Yes I would like an error message too...but there is none. I just get the first few bytes of the BLOB.
the typeHandler has not affect. I tracked this down a little, the handler is working fine, just what I get from the database seems to be cut off. is there anything I have to do to the standard connection parameters to get BLOBS working?? thx. Steve. -----Original Message----- From: Nathan Maves [mailto:[EMAIL PROTECTED] An error would be nice :) The only thing I can see is that you might try removing the typeHandler attribute. iBatis will figure it out based on the jdbcType. Nathan On Aug 12, 2005, at 9:39 AM, Steven Pannell wrote: > Hi, > > I'm trying to get a BLOB from an oracle 10g DB but all I get are > the first > few bytes. I have the latest jdbc14.jar from oracle and the map > looks like > this: > > <resultMap id="testMap" class="TestBean"> > <result property="content" column="document" jdbcType="BLOB" > typeHandler="com.ibatis.sqlmap.engine.type.BlobTypeHandlerCallback"/> > </resultMap> > > <select id="test" resultMap="testMap" parameterClass="long"> > select document from document_table where id = #value# > </select> > > My bean is as so.. > > public class TestBean { > > byte[] content; > > public byte[] getContent() { > return this.content; > } > > public void setContent(byte[] b) { > content = b; > } > > } > > > What am I doing wrong?? I followed the wiki note...but still no > joy. anyone > some tips?? > > thx. > Steve. >
