Return-Path: 
 <user-java-return-10848-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 61418 invoked from network); 28 Feb 2007 10:47:53 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 28 Feb 2007 10:47:53 -0000
Received: (qmail 32960 invoked by uid 500); 28 Feb 2007 10:47:55 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 32949 invoked by uid 500); 28 Feb 2007 10:47:55 -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 32938 invoked by uid 99); 28 Feb 2007 10:47:55 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Feb 2007 02:47:55 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [85.18.250.180] (HELO mail.rime.it) (85.18.250.180)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 28 Feb 2007 02:47:44 -0800
Received: from mailsrv1.rimelan.lan ([192.168.1.200]) by mail.rime.it with
 Microsoft SMTPSVC(6.0.3790.1830);
	 Wed, 28 Feb 2007 11:47:28 +0100
Subject: using typeHandler 
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Date: Wed, 28 Feb 2007 11:37:34 +0100
Content-class: urn:content-classes:message
X-MimeOLE: Produced By Microsoft Exchange V6.5
Message-ID: <28A62AD0E18CF34DADDBE0536403256D17D47A@mailsrv1.rimelan.lan>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: using typeHandler 
thread-index: AcdOwAX7uiOX9Id1TLu0ZEK5Spm8PQMZG8y/
References: <28A62AD0E18CF34DADDBE0536403256D17D457@mailsrv1.rimelan.lan>
From: "Stefano Mancini" <smancini@idoq.it>
To: <user-java@ibatis.apache.org>
X-OriginalArrivalTime: 28 Feb 2007 10:47:28.0943 (UTC)
 FILETIME=[D76BC3F0:01C75B25]
X-Virus-Checked: Checked by ClamAV on apache.org


Hi,

I've the following problem:

I want to read the rows of a generic table into a List of HashMaps using =
a statement like this one

<select id=3D"selectAll" remapResults=3D"true" =
resultClass=3D"java.util.HashMap" parameterClass=3D"java.util.Map">
    select * from $table$=09
</select>

If the table contains a column of type BLOB in the resulting map is =
inserted an object of type oracle.sql.BLOB (I'm using oracle 10g), I =
would like to have a byte[] in this case. I've inserted the following =
mapping

<typeHandler jdbcType=3D"BLOB" javaType =3D "[B" =
callback=3D"com.ibatis.sqlmap.engine.type.BlobTypeHandlerCallback" />=20

in the SqlMap with no results (I've used "[B] as javaType because byte[] =
isn't accepted).
Obviously if I use a resultMap with all the properties specified all =
works fine, but it's no more general.

Any ideas ?