Thank you Gustavo. Is it possible to configure ibatis to put the BLOB directly into a string?
Zsolt >-----Original Message----- >From: Gustavo Henrique Sberze Ribas [mailto:[EMAIL PROTECTED] >Sent: Tuesday, March 14, 2006 12:11 PM >To: [email protected] >Subject: RE: How to convert BLOB to String. > >Hello, > > iBATIS can fetch the BLOB as a stream of bytes. One way of doing what you >want is to create get/setters using byte[] that store/read to/from a >private >String field, ie: > >public class MyBean implements Serializable{ > > private String myString; > > public void setStringAsByteArray(byte[] b) { > myString = String(b); > } > public byte[] getStringAsByteArray() { > return myString.getBytes(); > } > > public void setMyString(String s) { > myString = s; > } > public String getMyString() { > return myString; > } >} > >and your result map: > ><resultMap class="MyBean" id="MyBeanResultMap"> > <result column="BLOB_COLUMN" property="stringAsByteArray" >jdbcType="BLOB"/> ></resultMap> > >That way you also have the chance to set the appropriate encoding to >your string. > > >regards, > >-- >Gustavo > > > >> -----Original Message----- >> From: Zsolt [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, March 14, 2006 4:55 AM >> To: [email protected] >> Subject: How to convert BLOB to String. >> >> >> Hi, >> >> I have a BLOB field in mysql-4.1.18 and want to get that as >> String. The >> property I use as follows: >> >> setArgument(String arg) {...} >> >> In the mapping file I tried to use the code below but that >> didn't help. >> <result property="argument" column="argument_types" jdbcType="BLOB" >> javaType="java.lang.String"/> >> >> Instead of the string I get something like below: >> [EMAIL PROTECTED] >> >> How can I fix that? >> >> I use ibatis-2.1.7.597. >> >> zsolt >> >> >> >>
