ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Niels Beekman" <n.beek...@wis.nl>
Subject RE: How to convert BLOB/CLOB to String.
Date Thu, 30 Mar 2006 06:54:04 GMT
You should really take a look at the docs, it's all there...

 

Niels

 

________________________________

From: Zsolt [mailto:zkoppanylist@intland.com] 
Sent: donderdag 30 maart 2006 8:14
To: user-java@ibatis.apache.org
Subject: RE: How to convert BLOB/CLOB to String.

 

I don't want to convert all BLOBs to String only for one table.

 

Zsolt

 

________________________________

From: Clinton Begin [mailto:clinton.begin@gmail.com] 
Sent: Thursday, March 30, 2006 5:51 AM
To: user-java@ibatis.apache.org; Balaji
Subject: Re: How to convert BLOB/CLOB to String.

 


iBATIS comes with a BLOB and CLOB type handler....it has for some time
now.

Clinton

On 3/27/06, Balaji < balaji@objectec.com <mailto:balaji@objectec.com> >
wrote:

Does anyone have a custom type handler for Clob - String written that
you 
can share.

Thanks,

Balaji

----- Original Message -----
From: "Nathan Maves" <Nathan.Maves@Sun.COM>
To: < user-java@ibatis.apache.org <mailto:user-java@ibatis.apache.org> >
Sent: Tuesday, March 14, 2006 9:59 AM
Subject: Re: How to convert BLOB to String.


> Yes.
>
> All you would have to do is write your own custom type handler.  It 
> would do just as Gustavo suggested but you would only have String
> properties in your POJO.
>
> Nathan
> On Mar 14, 2006, at 8:43 AM, Zsolt wrote:
>
> > 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: gribas@cpqd.com.br]
> >> Sent: Tuesday, March 14, 2006 12:11 PM
> >> To: user-java@ibatis.apache.org
> >> 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: zkoppanylist@intland.com
<mailto:zkoppanylist@intland.com> ]
> >>> Sent: Tuesday, March 14, 2006 4:55 AM
> >>> To: user-java@ibatis.apache.org
> >>> 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:
> >>> [ B@185982c
> >>>
> >>> How can I fix that?
> >>>
> >>> I use ibatis-2.1.7.597.
> >>>
> >>> zsolt
> >>>
> >>> 
> >>>
> >>>
> >
>
>
>

 


Mime
View raw message