JPA - Update binary data

I am new to JPA and hibernate.

I am using HSQLDB 2.0 and hibernate-JPA to insert image into BINARY column. I have annotated as follows

@Lob
private byte[] profileImage;

I can insert the image into the database.

I am retrieving the entity from database along with the binary column and converting the byte array into Image.

But when I request to persist the entity again after an update, I am getting following error.

Caused by: org.hibernate.exception.DataException: Could not execute JDBC batch update
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
    at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:237)
    at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:142)
    at org.hibernate.event.def.AbstractFlushingEventListener.开发者_如何学运维performExecutions(AbstractFlushingEventListener.java:298)
    at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
    at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
    at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)
    at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
    at org.hibernate.ejb.TransactionImpl.commit(TransactionImpl.java:54)
    ... 68 more

Caused by: java.sql.BatchUpdateException: data exception: string data, right truncation at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) ... 76 more

Can anyone please let me know what might be the issue?

Thank you in advance,

Regards, Niranjan

You need to use the latest Hibernate 3.6.2 and HSQLDB 2.1. Also, use a column of LONGVARBINARY or BLOB to store images. A BINARY column stores extra zero bytes after the image data to fill up its declared length, while the other two types do not add zero padding.