JPA "cannot be cast to java.sql.Blob"

Question

I'm using JPA2 with hibernate 3.6.1. and a Derby database and I used the following annotation for a blob:

@Column(length = Integer.MAX_VALUE)
@Lob
long[] bucket;

Hibernate creates the correct blob column but if I try to save an entity I get the following exception:

java.lang.ClassCastException: [J cannot be cast to java.sql.Blob

why and how can I make this work?

If I annotate it without the @Lob I get a "Varchar for bit data" column which can only contain up to 32m.

Augusto · Accepted Answer · 2011-03-07 16:48:08Z

9

You need to map the property as a byte[], not as long[].

The documentation says

@Lob indicates that the property should be persisted in a Blob or a Clob depending on the property type: java.sql.Clob, Character[], char[] and java.lang.String will be persisted in a Clob. java.sql.Blob, Byte[], byte[] and serializable type will be persisted in a Blob.

If the property type implements java.io.Serializable and is not a basic type, and if the property is not annotated with @Lob, then the Hibernate serializable type is used.

If you want to persist the array, you'll need to build a custom user type to transform the data type. You can find an example here http://docs.jboss.org/hibernate/annotations/3.5/reference/en/html/entity.html#d0e2794

edited Mar 7, 2011 at 16:48

answered Mar 7, 2011 at 16:34

Augusto

30.2k6 gold badges66 silver badges98 bronze badges

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

2 Comments

suicide Over a year ago

ok, thanks. Is there any other way to persist a long[] without having to "convert" it to a byte[] or something manually?

Augusto Over a year ago

Please check the answer, I've added a link with one example from the documentation.

Collectives™ on Stack Overflow

JPA "cannot be cast to java.sql.Blob"

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related