Return-Path: Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 91376 invoked by uid 99); 25 Jan 2005 01:30:05 -0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS X-Spam-Check-By: apache.org Received-SPF: neutral (hermes.apache.org: local policy) Received: from hmail03.netvigator.com (HELO hmail03dat.netvigator.com) (218.102.23.142) by apache.org (qpsmtpd/0.28) with ESMTP; Mon, 24 Jan 2005 17:30:03 -0800 Received: from [192.168.123.136] (really [219.79.211.170]) by hmail03dat.netvigator.com (InterMail vM.6.01.03.02 201-2131-111-104-20040324) with ESMTP id <20050125012959.CZQX1013.hmail03dat.netvigator.com@[192.168.123.136]> for ; Tue, 25 Jan 2005 09:29:59 +0800 Message-ID: <41F5A116.6030403@codeczar.com> Date: Tue, 25 Jan 2005 09:29:58 +0800 From: Nathan Coast User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: ibatis-user-java@incubator.apache.org Subject: Re: ibatis and streams References: <41F4AB39.3070200@codeczar.com> <16178eb1050124093340758da5@mail.gmail.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked thanks guys, I tried using streams directly with jdbc and I got exactly the same error - think I misunderstood what the max-packet error was telling me. So yes, it looks like increasing the max-packet param is the only solution. Thanks Nathan Brice Ruth wrote: > In the meantime, if you have access to the MySQL server (with rights), > changing the max-packet parameter isn't really all that difficult. Its > well documented on mysql.com, in the documentation. > > > On Mon, 24 Jan 2005 10:33:00 -0700, Clinton Begin > wrote: > >>2.0.9 does support blobs. But the current implementation does not use >>Streams. Someone has already posted a fix that we'll include in the >>next release. >> >>Cheers, >>Clinton >> >> >>On Mon, 24 Jan 2005 16:00:57 +0800, Nathan Coast wrote: >> >>>Hi, >>> >>>Does ibatis support blob types, specifically to stream blobs in / out of >>>the database? I notice something about blobs are mentioned for the >>>2.0.9 release. Are there any docs examples anywhere? >>> >>>I'm using mysql and I currently get errors for trying to write large >>>byte[] data types to the db (exceeding a db configuration - max packet >>>size). I'm hoping to avoid having to re-configure the db by using streams. >>> >>>thanks >>>Nathan >>> >>>btw, ibatis is a great tool, thanks for the effort. >>>-- >>>Nathan Coast >>>Managing Director >>>Codeczar Ltd >>>mob : (852) 9049 5581 >>>tel : (852) 2834 8733 >>>fax : (852) 2834 8755 >>>web : http://www.codeczar.com >>> >> > > -- Nathan Coast Managing Director Codeczar Ltd mob : (852) 9049 5581 tel : (852) 2834 8733 fax : (852) 2834 8755 web : http://www.codeczar.com