Return-Path: 
 <user-java-return-11960-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 2501 invoked from network); 1 Jul 2007 16:54:46 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 1 Jul 2007 16:54:46 -0000
Received: (qmail 3009 invoked by uid 500); 1 Jul 2007 16:54:45 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 2990 invoked by uid 500); 1 Jul 2007 16:54:45 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 2971 invoked by uid 99); 1 Jul 2007 16:54:45 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Jul 2007 09:54:45 -0700
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of lists@nabble.com designates
 216.139.236.158 as permitted sender)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 01 Jul 2007 09:54:41 -0700
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>)
	id 1I52gn-0004bj-1e
	for user-java@ibatis.apache.org; Sun, 01 Jul 2007 09:54:21 -0700
Message-ID: <11383532.post@talk.nabble.com>
Date: Sun, 1 Jul 2007 09:54:20 -0700 (PDT)
From: Mark P Ashworth <info@connext.co.za>
To: user-java@ibatis.apache.org
Subject: Re: MySQL and Blob
In-Reply-To: <a10a823c0707010930j5d967090s7a48066097762d4b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: info@connext.co.za
References: <11379634.post@talk.nabble.com>
 <a10a823c0707010930j5d967090s7a48066097762d4b@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org


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 <info@connext.co.za> 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',
>> 'info@connext.co.za',       '[B@11381e7',       ''     )
>>
>> 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.