Problem updating BLOB with Hibernate?

Question

i am having problem updating a blob with hibernate. (i am using Hibernate 3.3.1-GA)

my model have these getters/setters for hibernate, i.e. internally i deal with byte[] so any getter/setter convert the byte[] to blog.

I can create an initial object without problem, but if I try to change the content of the blob, the database column is not updated. I do not get any error message, everything looks fine, except that the database is not updated.

/** do not use, for hibernate only */
public Blob getLogoBinaryBlob() {
    if(logoBinary == null){
        return null;
    }
    return Hibernate.createBlob(logoBinary);
}

/** do not use, for hibernate only */
public void setLogoBinaryBlob(Blob logoBinaryBlob) {

    ByteArrayOutputStream baos = new ByteArrayOutputStream();
    try {
        logoBinary = toByteArrayImpl(logoBinaryBlob, baos);
    } catch (Exception e) {
    }
  }

my hibernate mapping for the blob looks like

<property name="logoBinaryBlob" column="LOGO_BINARY" type="blob" />

The database used is Oracle.

Are your properties mapped using JPA or just old fashion hibernate property mappings (for instance, <property name="logoBinary" type="blob" column="logo" />). Also which version of Hibernate do you use ? — Lars Tackmann
– Lars Tackmann, Commented Mar 30, 2010 at 10:12
hm, i use getHibernateTemplate().merge(object); to update the entry. when reading this post: forum.hibernate.org/viewtopic.php?f=1&t=942365&start=0 it sounds like merge is not possible to use for models with blobs...any workarounds? — JohnSmith
– JohnSmith, Commented Mar 30, 2010 at 12:10

Jason Plank · Accepted Answer · 2011-08-23 05:10:50Z

2

Wow, I was finally able to find the solution for the Update in BLOB data using Hibernate.

session.merge(domain); // changes blob value to 44

Changing it to this fixes the problem:

Domain merged = (Domain) session.merge(domain);
merged.setBlob(Hibernate.createBlob(domain.getBlob().getBinaryStream()));

Thanks to Chris Bredesen for his post.

edited Aug 23, 2011 at 5:10

Jason Plank

2,3325 gold badges32 silver badges40 bronze badges

answered Jun 10, 2010 at 21:46

suresh

213 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

zho Over a year ago

i'm not sure, what do you mean with "change blob value to 44" ? i use hibernate 5.3.9 and this problem still exists

JohnSmith · Accepted Answer · 2010-03-31 14:23:26Z

0

Ok, what i ended up doing in the end is creating a separate table for the blob, and by any update of the main object, it will delete and create new entries in the separate table. (hence no updates are performed)

Not ideal, but it works.

answered Mar 31, 2010 at 14:23

JohnSmith

4,6889 gold badges27 silver badges25 bronze badges

Collectives™ on Stack Overflow

Problem updating BLOB with Hibernate?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related