I'm using Spring / iBATIS and I couldn't make inserting a BLOB work. The workaround I did (which worked, but I still don't know why) is that I first inserted the data not including the BLOB column (the BLOB column has null as default value), and then I just issue an update on the BLOB column).
Regards, wowiesy Mark P Ashworth wrote: > > Good Day, > > At first I did not have the jdbcType or javaType and then systematically > added them because I was getting the same error the whole time. > > I used the php admin interface to add file data in the blob data field, > and when I retrieve the data is present, I am just not sure how to get the > insert to work. > > Regards, > Mark P Ashworth > > > > Larry Meadors-2 wrote: >> >> Did you try it w/o the jdbcType and javaType? >> >> Larry >> >> >> On 7/1/07, Mark P Ashworth <[EMAIL PROTECTED]> wrote: >>> >>> Good Day, >>> >>> I am trying to insert a byte[] field into a MySQL database. >>> >>> <resultMap id="EmailResult" class="Email"> >>> <result property="id" column="email_id"/> >>> <result property="name" column="name"/> >>> <result property="subject" column="subject"/> >>> <result property="from" column="from"/> >>> <result property="body" column="body" jdbcType="BLOB" >>> javaType="[B"/> >>> <result property="type" column="type" /> >>> </resultMap> >>> >>> <insert id="insertEmail" parameterClass="Email"> >>> insert into email ( >>> name, >>> subject, >>> from, >>> body, >>> type >>> ) values ( >>> #name#, >>> #subject#, >>> #from#, >>> #body#, >>> #type# >>> ) >>> </insert> >>> >>> When I look at the SQL generated I see that it has not converted the >>> body >>> field correctly so that MySQL will accept the statement. >>> >>> insert into email ( name, subject, from, body, >>> type ) values ( 'register', 'Test', >>> '[EMAIL PROTECTED]', '[EMAIL PROTECTED]', '' ) >>> >>> I am using iBatis 2.3.0.677 >>> >>> Regards, >>> Mark P Ashworth >>> -- >>> View this message in context: >>> http://www.nabble.com/MySQL-and-Blob-tf4007004.html#a11379634 >>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >>> >>> >> >> > > -- View this message in context: http://www.nabble.com/MySQL-and-Blob-tf4007004.html#a11539704 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
