Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (asf.osuosl.org: domain of alan@chandlerfamily.org.uk
 designates 195.188.213.6 as permitted sender)
From: Alan Chandler <alan@chandlerfamily.org.uk>
To: user-java@ibatis.apache.org
Subject: Re: confused about storing image data in my database
Date: Tue, 8 Nov 2005 00:55:01 +0000
User-Agent: KMail/1.8.2
References: <200511071856.49219.alan@chandlerfamily.org.uk>
 <200511072227.59867.alan@chandlerfamily.org.uk>
 <c593b8750511071510o43c73bb0s5b5dc751a1cb22c3@mail.gmail.com>
In-Reply-To: <c593b8750511071510o43c73bb0s5b5dc751a1cb22c3@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-6"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200511080055.01903.alan@chandlerfamily.org.uk>

On Monday 07 Nov 2005 23:10, Jeff Butler wrote:
> Ah...sorry.
>  This is sometimes hard to work through. The problem is that bytea doesn't
> map easily to a JDBC type - hence the posgresql documentation telling you
> exactly what JDBC method to call. If bytea means that you should call
> getBytes(), then I think you should use a byte[] in your bean, but NOT
> specify type of BLOB in the result map. This will cause iBATIS to use the
> ByteArrayTypeHandler, which calls getBytes().
>  You can see how iBATIS decides what to do by looking at the class
> com.ibatis.sqlmap.engine.type.TypeHandlerFactory. If there is a property of
> type byte[], and JDBC type is not BLOB or LONGVARBINARY, then iBATIS will
> use the ByteArrayTypeHandler - which should do what you want.
>  I hope I understand it this time :)

Thanks that is exactly what I was after.

-- 
Alan Chandler
http://www.chandlerfamily.org.uk
Open Source. It's the difference between trust and antitrust.