Re: How to convert BLOB to String.

[Nathan Maves]

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:[EMAIL PROTECTED]
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:[EMAIL PROTECTED]
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:
[EMAIL PROTECTED]

How can I fix that?

I use ibatis-2.1.7.597.

zsolt