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#a11383532 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
